Two queries, connected by the union each query can't use the order by sorting, try using the select in the peripheral rewrite a query, will sort the query as the subquery, then they are connected by the union, the order by still doesn't work, and great god teach how to write to make the order by each query work!!!!!!