MySQL 5.7
ORDER BY clause is not in SELECT list
If you have phpMyAdmin:
- go to the Variables tabs
- search label "sql mode"
- edit the content and delete the mode : "ONLY_FULL_GROUP_BY"
- save
NB: don't forget to verify the comma separator
Further Information
How to resolve “ORDER BY clause is not in SELECT list” caused MySQL 5.7 with SELECT DISTINCT and ORDER BY