Using INSERT … SELECT With Subqueries
You cannot specify an ORDER BY clause in the SELECT component of an INSERT … SELECT request when the SELECT is a subquery.
You cannot specify an ORDER BY clause in the SELECT component of an INSERT … SELECT request when the SELECT is a subquery.