SELECT COUNT(jm.id), s.URL
FROM joueurs_medias jm
LEFT OUTER JOIN sitemap s ON param=jm.id_joueur AND Rewrite_URL='content/photos-joueurs.php'
WHERE jm.etat='1' AND jm.type='1' AND jm.id_joueur='119'
GROUP BY jm.id_joueur
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'poker.s.URL' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by