title: Insert SQL query into controller in cakephp
body: <p>I'm using cake php version 2.4.1</p>
  
  <p>I want change this SQL query into PHP code for my controller in cakePHP</p>
  
  <pre><code>SELECT id,name 
  FROM providers 
  WHERE id not in 
      (SELECT c.provider_id 
      FROM token_maps a 
      INNER JOIN token_map_groups b ON b.token_map_id = a.id 
      INNER JOIN token_map_group_providers c on c.token_map_group_id=b.id 
      LEFT JOIN providers p on p.id=c.provider_id 
      WHERE a.id=2
      )
  </code></pre>
  
  <p>I can't use  <code>$this-&gt;Provider-&gt;query('sql query');</code>
  because it will give me false result different from when I execute the query in mysql. </p>
  
  <p>can anyone help me?</p>