title: How to write query in CakePHP format?
body: <p>Please check my query. I need to convert it into to cakephp format.</p>
  
  <pre><code>SELECT category,user_id 
  FROM `products` 
  WHERE status=1 
  GROUP BY category  
  ORDER BY COUNT(category) DESC
  </code></pre>
  
  <p><strong>CakePHP</strong></p>
  
  <pre><code>$conditions=array('Product.status'=&gt;1)
  $fields = array('Product.category','Product.user_id');
  $groups = array('Product.category');
  
  $order = array('COUNT'=&gt;array('Product.category DESC'))
  
  $this-&gt;Product-&gt;find("all",array('conditions'=&gt;$conditions,'group'=&gt;$groups, 'order'=&gt;$order, 'limit'=&gt;10));
  </code></pre>
  
  <p>Above CakePHP query i am getting null result. Please help me.</p>