title: cakephp and SQL_CALC_FOUND_ROWS
body: <p>I am trying to add the SQL_CALC_FOUND_ROWS into a query (Please note this isn't for pagination)</p>
  
  <p>please note I am trying to add this to a cakePHP query the code I currently have is below:</p>
  
  <pre><code>return $this-&gt;find('all', array(
                  'conditions' =&gt; $conditions,
                  'fields'=&gt;array('SQL_CALC_FOUND_ROWS','Category.*','COUNT(`Entity`.`id`) as `entity_count`'),
                  'joins' =&gt; array('LEFT JOIN `entities` AS Entity ON `Entity`.`category_id` = `Category`.`id`'),
                  'group' =&gt; '`Category`.`id`',
                  'order' =&gt; $sort,
                  'limit'=&gt;$params['limit'],
                  'offset'=&gt;$params['start'],
                  'contain' =&gt; array('Domain' =&gt; array('fields' =&gt; array('title')))
              ));
  </code></pre>
  
  <p>Note the <code>'fields'=&gt;array('SQL_CALC_FOUND_ROWS','</code> this obviously doesn't work as It tries to apply the <code>SQL_CALC_FOUND_ROWS</code> to the table e.g. <code>SELECT</code>Category<code>.</code>SQL_CALC_FOUND_ROWS<code>,</code></p>
  
  <p>Is there anyway of doing this? Any help would be greatly appreciated, thanks.</p>