ORDER BY cannot be used in the sql statement of a UNION.

It can be used only after the UNION, hence only one ORDER BY is allowed.