title: Order by date a select query on UNION ALL
body: <p>I have little problem with my MySql query:
  I have two tables:</p>
  
  <p>Table <strong>timeline</strong></p>
  
  <pre><code>id | date      |  text
  1    2013-10-13   Hello
  </code></pre>
  
  <p>Table <strong>reps</strong></p>
  
  <pre><code>id | date      | text
  1   2013-10-12   Its me again
  1   2013-10-11   What?
  1   2013-10-10   Lorem ipsum
  </code></pre>
  
  <p>What i am doing is  <code>UNION ALL</code> timeline and reps.First row should always be the row from timeline(it's always one row) and then all rows from reps table but in <code>DESC</code> order.</p>
  
  <p>My query is the following one(which work ok except from order by)</p>
  
  <pre><code>select id,date,text from timeline UNION ALL select * from reps order by date desc
  </code></pre>
  
  <p>Think something like a comment (sits on top) with replies on the comment in desc order,newest first.</p>
  
  <p>Thank you in advance.</p>