To Set Humanity Totally and Unconditionally Free
Connect with Oneness
Malaysia Oneness Trainer
QUERY: select t.*, GROUP_CONCAT(l.location_name SEPARATOR ", ") as location_name, l.location_id from trainer t left join trainer_location tl on (t.trainer_id = tl.trainer_id) left join location l on (l.location_id = tl.location_id) group by t.trainer_id order by t.trainer_order asc
ERROR: Expression #11 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'onemalay_db.l.location_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by