Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'data_fame.bn.beaunom' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by -> SELECT s.studio,bn.beaunom FROM data_fame.scenes s LEFT JOIN data_fame.beaunom bn ON bn.nomflux=s.studio AND bn.type='studio' WHERE s.releaseDate <= '2021-08-06' AND pic_lu=1 AND s.base = 'hustler' GROUP BY s.studio ORDER BY s.studio ASC
