string(795) "SELECT villes.nom_ville , MR.id_MR,url,CP_MR,nom_MR,ville_MR,CP_MR,regions.region_url,county.county_url,villes.nom_ville_url,nom_MR_url,descriptionVille,descriptionVilleRS
FROM villes
INNER JOIN MR ON MR.nom_ville_url = villes.nom_ville_url
INNER JOIN regions ON regions.nom = MR.region_MR
INNER JOIN county ON county.nom = MR.county_MR
LEFT JOIN photos_MR_new ON photos_MR_new.id_MR = MR.id_MR
WHERE MR.etat_MR IN (1, 2, 3)
AND regions.region_url = 'scotland'
AND county.county_url ='aberdeenshire'
AND villes.nom_ville_url = 'redhill'
GROUP BY MR.id_MR
ORDER BY villes.nom_ville_url ASC LIMIT 0,15"