In a QUERY statement with the outermost QUERY expression containing at least one UNION, INTERSECT or EXCEPT, the ORDER clause must not contain column specifications.
Replace the column specifications with the corresponding numbers of the output columns or with the result column name (result_column_name) used in the first QUERY specification of the outer QUERY expression.