Why does the order of the SELECT statements in the UNION affect the result ... works in PostgreSQL so I was not expecting a problem in MySQL.