.. ================================================== .. FOR YOUR INFORMATION .. -------------------------------------------------- .. -*- coding: utf-8 -*- with BOM. .. include:: ../../../Includes.txt .. _bugs_sql_mysql57: 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 https://stackoverflow.com/questions/36829911/how-to-resolve-order-by-clause-is-not-in-select-list-caused-mysql-5-7-with-sel