Erreur SQL !
SELECT COUNT(b.idPelerin) as pax , a.nbPlace FROM sejours a left outer join sejour_pelerin b on b.confirm in (1,0) and b.idSejour=a.id left outer join pelerins p on p.id = b.idPelerin and p.civilite in(1,2,3) where a.id=