Mysql group by + order does not take effect

= =

Mysql Mariadb, the project used mysql before, but later the project migrated to another database. Mariadb is installed in my colleague database, while Maria does not support mysql order by + Group by

Stackoverflow.com/questions/3…

www.icode9.com/content-2-5…

—

A draft. I have time to write it