使用Cake
PHP 1.2,我正在尝试生成一个GROUP BY查询：
- SELECT `categories`.*,COUNT(`entities`.id)
- FROM `categories`
- LEFT JOIN `entities` ON (`categories`.`id` = `entities`.`category_id`)
- GROUP BY `categories`.`id`
这样做/我该怎么办？我正在使用“可容纳”,如果这有帮助.
这是我所了解的：
- $options = array(
- 'conditions' => $conditions,'fields'=>array('Category.*','COUNT(`Entity`.`id`) as `entity_count`'),'joins' => array('LEFT JOIN `entities` AS Entity ON `Entity`.`category_id` = `Category`.`id`'),'group' => '`Category`.`id`','contain' => array('Domain' => array('fields' => array('title')))
- );
- return $this->find('all',$options);
