Hence no point putting aliases on the fields in the subsequent subqueries.
Also note that the Union keyword will automatically apply a Distinct on the records so there are no repeats. In this situation there clearly can be no duplicates so UNION ALL should be used to avoid the waste of time...