select CASE WHEN date IS NULL THEN SELECT STR_TO_DATE('01/01/2999', '%m/%d/%Y') ELSE SELECT date END as date_order, date from bla where blabla order by 1