select ...

union

select ...

union

select ...

union

select ...

This is a ridiculous construct! If you are certain you do want to use union because you want to sort and deduplicate the rows, then you should always use this construct instead:

select ...

union all

select ...

union all

select ...

union

select ...