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 = 'beauvais' AND MR.nom_MR_url = 'l-age-d-or-60' GROUP BY MR.id_MR

L'Age D'Or 60 - Beauvais

Accueil > Annuaire > Maisons de retraite dans les Hauts-de-France > Maisons de retraite dans l'Oise

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