Ci sono:

codice:
SELECT * FROM tbl ORDER BY IF(date1,date1,date2) DESC