Mariadb Articles
Behaviour of ORDER BY in FROM: MariaDB vs MySQL
01 Dec 2017 •SQL MARIADB MYSQL DATABASES TL; DR
In MariaDB, query with ORDER BY in a FROM subquery produces an unordered result. In effect, ORDER BY is ignored in FROM subqueries. MySQL does not ignore ORDER BY in FROM subqueries.