title: cakephp distinct find error
body: <p>I am using cakephp2.7 and need to get distinct values from a table   </p>
  
  <pre><code>$rows = $this-&gt;Skill-&gt;find('list',array(
              'conditions'=&gt;array(
                      'Skill.status'=&gt;1,
                      'Skill.percent &gt;='=&gt; 70,
                      'Skill.percent &lt;='=&gt; 100,
                  ),
              'fields' =&gt; array('DISTINCT Skill.row AS row'),
              //'fields' =&gt; 'DISTINCT Skill.row AS row',/*also tried*/
          ));
  </code></pre>
  
  <p>but it is giving mysql error <code>...near DISTINCT....</code><br>
  generated query is as below</p>
  
  <pre><code>SELECT `Skill`.`id`, DISTINCT `Skill`.`row` AS `row` FROM `mydb`.`skills` AS `Skill` WHERE `Skill`.`status` = 1 AND `Skill`.`percent` &gt;= 70 AND `Skill`.`percent` &lt;= 100
  </code></pre>
  
  <p>i tried same query in mysql giving same error but when I remove <code>id</code> column in mysql query it is running fine.</p>
  
  <p>now issue is that <code>skill.id</code> column is added in query automatically by cakephp and it is <code>primary key</code>
  how to prevent including <code>id</code> column in <code>find()</code>?</p>