cakePHP and GROUP BY

Question

I am trying to solve a hopefully simple problem here is the query I am trying produce:

SELECT `categories`.*, COUNT(`entities`.id)
FROM `categories` 
LEFT JOIN `entities` ON (`categories`.`id` = `entities`.`category_id`)
GROUP BY `categories`.`id`

I am really struggling to do this is in cakePHP 1.2

How would/should I go about doing this... (I am using 'Containable' if that helps)

Thanks in advance

Answer 1

Model->find() has a group param.

Answer 2

This is what I eneded up with:

 $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);