Tegnap este egy jó kis 10 perces szívás CakePHP-val:
$this->set('_tho', $this->ind->find('count', array('fields' => 'DISTINCT org_id')));
OKÉ! A generált sql: SELECT COUNT(DISTINCT org_id) AS "count" FROM "inds" AS "ind" WHERE 1 = 1
$this->set('_thp', $this->ind->find('count', array('fields' => 'DISTINCT project_id')));
OKÉ! A generált sql: SELECT COUNT(DISTINCT project_id) AS "count" FROM "inds" AS "ind" WHERE 1 = 1
$this->set('_thc', $this->ind->find('count', array('fields' => 'DISTINCT country_id')));