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