Warning: mysqli::__construct(): (HY000/2002): Connection refused in /home/couple/www/functions/connect.php on line 16

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

Warning: mysqli::__construct(): (HY000/2002): Connection refused 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=923 GROUP BY c.id