Warning: mysqli::__construct(): (HY000/1045): Access denied for user 'elodie'@'141.95.154.192' (using password: YES) in /home/couple/www/functions/connect_pc.php on line 20

Warning: mysqli_query(): Couldn't fetch mysqli in /home/couple/www/clubs/fiche_club.php on line 16

Warning: mysqli_error() expects exactly 1 parameter, 0 given in /home/couple/www/clubs/fiche_club.php on line 16
SELECT c.*,d.libelle as libdept,d.preposition, ROUND(AVG(ca.note)) as note , count(ca.id_avis) as nb_note FROM club c LEFT JOIN club_avis ca ON ca.id_club = c.id INNER JOIN departements d ON d.id=c.id_dept WHERE c.id=605 GROUP BY c.id