SELECT lotTime FROM mx_result_tran WHERE uID="1" AND lotdate="2024-07-22" AND lotTime <> "05:30" GROUP BY lotTime ORDER BY lotID DESC
SELECT lotTime FROM mx_result_tran WHERE uID="1" AND lotdate="2024-07-22" AND lotTime <> "05:30" GROUP BY lotTime ORDER BY lotID DESC
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'star99_mind_set.mx_result_tran.lotID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by