title: Cakephp order by associated models
body: <p>I have following model associations:</p>
  
  <pre><code>//User Model
  public $hasMany = array(
      'MessageSent' =&gt; array(
          'className' =&gt; 'Message',
          'foreignKey' =&gt; 'sender_id'
      ),
      'MessageReceived' =&gt; array(
          'className' =&gt; 'Message',
          'foreignKey' =&gt; 'receiver_id'
      ));
  
  //Message Model
  public $belongsTo = array(
      'Sender' =&gt; array(
          'className' =&gt; 'User',
          'foreignKey' =&gt; 'sender_id'
      ),
      'Receiver' =&gt; array(
          'className' =&gt; 'User',
          'foreignKey' =&gt; 'receiver_id'
      )
  );
  </code></pre>
  
  <p>Now i would like to fetch a User with the messages ordered by "created", so that i can create a message stream ala facebook.</p>
  
  <pre><code>$this-&gt;User-&gt;contain(array(
      'MessageSent' =&gt; array('conditions' =&gt; array('MessageSent.receiver_id' =&gt; 
          $this-&gt;Auth-&gt;user('id'))),
      'MessageReceived' =&gt; array('conditions' =&gt; array('MessageReceived.sender_id' =&gt;
          $this-&gt;Auth-&gt;user('id')))
      ));
  $partner = $this-&gt;User-&gt;find('all', array('conditions' =&gt; array('slug' =&gt;
      $this-&gt;request-&gt;params['slug'])));
  </code></pre>
  
  <p>So i need something like "ORDER BY Message.created" so that i get MessageSent and MessageReceived mixed together and ordered by date . How do i do that?</p>