Les Annonces des Professionnels du Cheval

Espace AnnonceurDevenir Annonceur

recherchefavorisvisiteur

Partager

PDOStatement Object ( [queryString] => SELECT * FROM sejours S JOIN type_sejours Ts ON S.ID_TYPE_SEJOUR = Ts.ID_TYPE_SEJOUR JOIN dates Da ON S.NUM_SEJOUR = Da.NUM_SEJOUR JOIN departements D ON S.ID_DEPT = D.ID_DEPT JOIN niveau_cavalier Nc ON S.ID_NIVEAU_CAVALIER = Nc.ID_NIVEAU_CAVALIER JOIN membres_gestion Mg ON S.NUM_MEMB = Mg.NUM_MEMB WHERE URL_DEPT = 'ardennes' AND Mg.NUM_COMITE != 'c11' AND Ts.CATEGORIE = 'rando' AND Ts.ID_TYPE_SEJOUR != 442 AND Ts.ID_TYPE_SEJOUR != 402 AND Ts.ID_TYPE_SEJOUR != 25 AND Da.DATE_DEB > DATE(NOW()) GROUP BY Da.NUM_SEJOUR ORDER BY RAND() )

Grand-Est
Ardennes

• Tous les departs à partir du 28 avril 2024