title: Selecting and sorting query by subquery
body: <p>I'm selecting rows from <code>table recipes</code> that have the same <code>id</code> as <code>table likes</code> column <code>recipe_id</code> AND with a specific <code>user_id</code> (1). </p>
  
  <p>I want to sort/order everything by the <code>date</code> from table <code>likes</code> and not <code>recipes</code> as in my example...</p>
  
  <pre><code>SELECT DISTINCT name, slugged_url 
  FROM recipes
  WHERE id 
  IN
  (
      SELECT recipe_id 
      FROM likes t
      LEFT JOIN users tn ON tn.id = t.user_id
      WHERE tn.id = '1'
  )
  AND publish = '1' 
  ORDER BY date DESC
  LIMIT 0 , 5
  </code></pre>
  
  <p>Tried to put order in the sub-query but didn't work.</p>