- Recherchez un camping selon vos préférences en matières de loisirs et de qualité.
- Trouvez un camping dans votre région préférée.
- Posez vos question au aidez les internautes à choisir leur camping dans le Forum.
Recherchez un camping
Selectionnez une région sur la carte.
Région
Thématiques
Chaînes de campings
Trier par :
Camping
Ville
Etoiles
select c.id as idcamp,
c.nom as nomcamp,
c.ville as villee,
c.cp as cp,
c.tel1 as tel,
c.site as site_camping,
c.ordre as order_camp2,
c.ordre2 as order_camp,
ca.idcategorie as numdep,
ca.idpere as idcat,
ca.nom as nomdep,
(Select nom from categories ca2 where ca2.idcategorie=ca.idpere limit 1) as nomreg,
count(co.idcommentaire) as nbcom,
sum(co.note)/count(co.note) as notee,
c.espaceAquatique as a1,
c.nombrePiscine as a2,
c.nombrePiscineChauffees as a3,
c.nombrePiscineChauffeesCouvert as a4,
c.pataugeoire as a5,
c.mer as plage,
c.golf as cs1,
c.tirarc as cs2,
c.tennis as cs3,
c.badminton as cs4,
c.pingpong as cs5,
c.volleyball as cs6,
c.football as cs7,
c.basketball as cs8,
c.aquagym as cs9,
c.fitness as cs10,
c.musculation as cs11,
c.petanque as cs12,
c.minigolf as cs13,
c.charme as c_charme,
c.coup_coeur as c_coeur,
c.nb_soiree_pro_en_saison as nbprosaison,
c.club_enfant_payant as enfantpayant,
c.club_enfant_ouverture as enfantouverture,
c.commentaire as commentaire,
c.etoile as etoiles
from campings c Left join commentaires co on co.idsujet=c.id , categories ca where c.departement=ca.idcategorie and ( ca.idpere='174' and (c.espaceAquatique>=2 or c.nombrePiscine>=2 or c.nombrePiscineChauffees>=2 or c.nombrePiscineChauffeesCouvert>=2) group by c.id order by c.ordre2 DESC, rand(1082142787) limit 0,6
