title: CakePHP and GROUP BY
body: <p>Using CakePHP 1.2, I am trying produce a <code>GROUP BY</code> query:</p>
  
  <pre><code>SELECT `categories`.*, COUNT(`entities`.id)
  FROM `categories` 
  LEFT JOIN `entities` ON (`categories`.`id` = `entities`.`category_id`)
  GROUP BY `categories`.`id`
  </code></pre>
  
  <p>How would/should I go about doing this?  I am using 'Containable' if that helps.</p>