Synthesizing a Row Number Column for Efficient UNION Queries in MySQL

Resolving MySQL Error: Using Non-Aggregated Columns in GROUP BY Clause