SELECT lotTime FROM mx_result_tran WHERE uID="1" AND lotdate="2025-12-06" AND lotTime <> "08:45" GROUP BY lotTime ORDER BY lotID DESC
SELECT lotTime FROM mx_result_tran WHERE uID="1" AND lotdate="2025-12-06" AND lotTime <> "08:45" 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 'bigplayersco_rajshree.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