title: mysql order by with union doesn't seem to work
body: <p>Here is my query </p>
  
  <pre><code>(SELECT * FROM `jokes` WHERE `flags` &lt; 5 AND (`title` LIKE "%only three doors%" OR `joke` LIKE "%only three doors%") ORDER BY `ups` DESC,`downs` ASC)
  UNION
  (SELECT * FROM `jokes` WHERE `flags` &lt; 5 AND (`title` LIKE "%only%" OR `joke` LIKE "%only%") ORDER BY `ups` DESC,`downs` ASC)
  UNION
  (SELECT * FROM `jokes` WHERE `flags` &lt; 5 AND (`title` LIKE "%three%" OR `joke` LIKE "%three%") ORDER BY `ups` DESC,`downs` ASC)
  UNION
  (SELECT * FROM `jokes` WHERE `flags` &lt; 5 AND (`title` LIKE "%doors%" OR `joke` LIKE "%doors%") ORDER BY `ups` DESC,`downs` ASC)
   LIMIT 0, 30
  </code></pre>
  
  <p>For some reason it doesn't seem to order by ups or downs...it just tosses me back the results in the order they are naturally in the database.</p>
  
  <p>When I cut it down to only one query, it works fine, but other than that, it seems to ignore it.</p>
  
  <p>I also don't want to order by the entire results, or I would have put <code>LIMIT 0,30 Order By blah</code></p>