title: CakePHP paginate conditions in derived fields
body: <p>i would like to paginate  a list of games, where the sport is a chosen sport.
  the relatition is as followed:
  Game BelongsTo Competition BelongsTo Team BelongsTo sport
  What i would like to do is show all games where the teams sport_id = 1.
  The following doesn't work:</p>
  
  <pre><code>        $this-&gt;paginate = array('limit' =&gt; 30, 'page' =&gt; 1, 
      'conditions' =&gt; array('Competition.Team.sport_id' =&gt; '1'),
          'contain' =&gt; array('Competition', 'Competition.Team',
          'Gamefield', 'Changingroom', 'ChangingroomAway', 'Gametype'),
      'order'=&gt;array('game_date'=&gt;'asc'),         
      );  
  </code></pre>
  
  <p>Can anyone help me with this one?</p>