ooooErreur SQL : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and a.idSejour=s.id and a.idSejour = sd.idSejour 
and a.idSejourDate= sd.id and ' at line 2<br>Requête : SELECT count(*) as nbPelerin, chambre, u.agence as agence, u.id, s.libelle as sejour, sd.dateDebut,sd.dateFin,s.id as idSejour, sd.id as 
idSejourDate FROM pelerins a , users u , sejours s , sejours_date sd  WHERE a.id&gt;0 and u.id=  and a.idSejour=s.id and a.idSejour = sd.idSejour 
and a.idSejourDate= sd.id and a.id&gt;0 and a.confirm=1 and u.id=a.uid group by u.agence, u.id ,chambre , s.libelle, sd.dateDebut, sd.dateFin,s.id,sd.id