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"
NB: don't forget to verify the comma separator
How to resolve “ORDER BY clause is not in SELECT list” caused MySQL 5.7 with SELECT DISTINCT and ORDER BY