title: CakePHP and subquery
body: <p>How can I write a SQL subquery using cake syntax?
  I know how to code a simple query, but I can't handle subqueries.</p>
  
  <p>This is the original query:</p>
  
  <pre><code>SELECT Assumption.id, Referee.id, Referee.first_name, Referee.second_name
  FROM referees AS Referee
  INNER JOIN (
  
      SELECT a.id, a.referee_id
      FROM assumptions a
      WHERE a.season_id =7
  ) AS Assumption ON Referee.id = Assumption.referee_id
  </code></pre>