• Interesting how the one extra sentence at the end added more value than I thought!

    Mixing UNION and UNION ALL - definitely interesting. I think I'd be inclined to separate them with parens to give a good visual signal about what I was trying to achieve and why.