Actualité de Titan Poker

SELECT r.nom, r.nom2, ro.code_url FROM room r INNER JOIN rooms_options ro ON r.id=ro.id_room AND LCID='1036' AND ro.rooms_actualites='1' INNER JOIN articles_thematiques at ON at.idGroup_theme='11' AND id_spec=r.id INNER JOIN articles a ON at.idGroup_article=a.idGroup AND a.etat='1' WHERE id_spec='1' GROUP BY r.nom
Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'poker.ro.code_url' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by