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

Synthesizing a Row Number Column for Efficient UNION Queries in MySQL