title: Cakephp: find() Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Interestslogs.interest_id' in 'field list'
body: <p>I have a table called 'Interestslogs' and model's name is Interestlog.</p>
  
  <p>I need to get the client_id according to id from that table in Cakephp.</p>
  
  <pre><code>$client_id = $this-&gt;Interestslog-&gt;find('first',array(
          'conditions' =&gt; array('Interestslogs.id' =&gt; $id),
          'fields' =&gt; array('Interestslogs.client_id'),
          )
      );
  </code></pre>
  
  <p>However I am getting database error:</p>
  
  <pre><code>Database Error
  </code></pre>
  
  <p>Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Interestslogs.interest_id' in 'field list'</p>
  
  <p>SQL Query: SELECT <code>Interestslogs</code>.<code>interest_id</code> FROM <code>efa</code>.<code>interestslogs</code> AS <code>Interestslog</code> LEFT JOIN <code>efa</code>.<code>interests</code> AS <code>Interest</code> ON (<code>Interestslog</code>.<code>interest_id</code> = <code>Interest</code>.<code>id</code>) LEFT JOIN <code>efa</code>.<code>clients</code> AS <code>Client</code> ON (<code>Interestslog</code>.<code>client_id</code> = <code>Client</code>.<code>id</code>) WHERE <code>Interestslogs</code>.<code>id</code> = 1 LIMIT 1</p>