SELECT * , GROUP_CONCAT(rp_facility_facilityType.rp_facilityTypeID) AS MR_type , MR.id_MR AS id_MR , regions.nom AS nom_region ,departements.nom AS nom_dep , GROUP_CONCAT(photos_MR_new.url SEPARATOR ',') as urls_photo FROM MR LEFT JOIN photos_MR_new ON photos_MR_new.id_MR = MR.id_MR LEFT JOIN rp_facility_facilityType ON rp_facility_facilityType.rp_facilityID = MR.id_MR LEFT JOIN asso_contact_MR ON asso_contact_MR.id_MR = MR.id_MR AND contact_MR_type = 11 LEFT JOIN departements ON id_dep = MR.rp_facilityDepartement LEFT JOIN regions ON regions.id = departements.nouvelleRegionCode WHERE etat_MR IN (1, 2, 3, 5, 6) AND rp_facilityTypeID IN (1, 4) AND rp_facilityTypeID IN (1, 4) AND MR.nom_ville_url = 'fleure' AND MR.nom_MR_url = 'saint-thibault' GROUP BY MR.id_MR

Saint Thibault - Fleuré

Accueil > Annuaire > Maisons de retraite en Nouvelle-Aquitaine > Maisons de retraite en Vienne

Trouvez un hébergement adapté pour personne âgée