Nice article!

I've seen some weirdness mixing unions and union all with unexpected results in the past.

select ...

union

select ....

union

select ....

union all

select ....

something to beware of I guess in the future.