Stupid Query Tricks
Ordering, limiting, and ordering again

   (SELECT * FROM mytable
   WHERE col1 = ‘foo’
   ORDER BY col2 LIMIT 50)
   ORDER BY col3
Copyright 2003, Jeremy Zawodny