Erreur SQL : Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'commun.cct.nom' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (1055)
SELECT c_c.com_id, c_c.id, IF(c_c.sport = 2, (IF(c_c.nom REGEXP 'wta|WTA' = 1, 'WTA', 'ATP')), '') AS sexe, c_c.sport, IF(cct.nom <> '', cct.nom, cct0.nom) AS nom, IF (cci.ico <> '', CONCAT(LOWER(cs.nom), '/', cci.ico), '') AS logo, IF(cpt.nom <> '', cpt.nom, cpt0.nom) AS pays FROM `cotes`.`championnats` AS c_c JOIN `commun`.`championnats` cc ON cc.idchampionnat = c_c.com_id LEFT JOIN `commun`.`championnats_trads` cct ON cct.idchampionnat = cc.idchampionnat AND cct.LCID = 2057 AND cct.version LIKE 'defaut' AND cct.actif = 1 LEFT JOIN `commun`.`championnats_trads` cct0 ON cct0.idchampionnat = cc.idchampionnat AND cct0.LCID = 0 AND cct0.version LIKE 'defaut' AND cct0.actif = 1 LEFT JOIN `cotes`.`pays` c_p ON c_c.pays=c_p.id LEFT JOIN `commun`.`pays` cp ON c_p.com_id = cp.idpays LEFT JOIN `commun`.`pays_trads` cpt ON cpt.idpays = cp.idpays AND cpt.LCID = 2057 AND cpt.version LIKE 'defaut' AND cpt.actif = 1 LEFT JOIN `commun`.`pays_trads` cpt0 ON cpt0.idpays = cp.idpays AND cpt0.LCID = 0 AND cpt0.version LIKE 'defaut' AND cpt0.actif = 1 LEFT OUTER JOIN `commun`.`championnats_img` cci ON cci.idchampionnat = cc.idchampionnat JOIN `commun`.`sports` cs ON cs.idsport = cc.id_sport WHERE c_c.id IN (306) GROUP BY c_c.id;