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 = 'pelussin' AND MR.nom_MR_url = 'residence-le-grillon' GROUP BY MR.id_MR
