title: Extracting from multiple tables by id and ordering by created date
body: <p>I`m trying to extract the activity of a user with a single query. I need to do it with one single query so I can use zend paginator.</p>
  
  <p>I have 5 tables: <code>users</code>, <code>replies</code>, <code>threads</code>, <code>wiki_articles</code> and <code>wiki_article_revisions</code>. Each table has 2 common columns <code>created_by</code> and <code>created_on</code>. </p>
  
  <p>I've tried using <code>left join</code> but I think what it returns is not correct and I'm unable to order all activity by <code>created_on</code></p>
  
  <p>Here is the join I've tried:</p>
  
  <pre><code>SELECT * FROM `users` u
  LEFT join `replies` r ON u.id = r.created_by
  LEFT join `threads` t ON u.id = t.created_by
  LEFT join `wiki_articles` wa ON u.id = wa.created_by
  LEFT join `wiki_article_revisions` war ON u.id = war.created_by
  WHERE (u.`name` = 'CGeorges') 
  </code></pre>