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.serie,bn.beaunom FROM data_fame.scenes s LEFT JOIN data_fame.beaunom bn ON bn.nomflux=s.serie AND bn.type='serie' WHERE s.releaseDate <= '2023-12-02' AND pic_lu=1 AND (studio = 'girlsway') AND s.base = 'webyoung' GROUP BY s.serie ORDER BY s.serie ASC