SELECT r.*, g.id as id_groupe, g.nom as nom_groupe, g.image as image_groupe, g.estvisible as estVisible_groupe, g.adressePage as adressePage_groupe FROM residences r LEFT JOIN groupes_residences g ON r.groupe = g.id WHERE (SELECT COUNT(*) FROM villes v WHERE v.nom = r.ville AND v.region=r.region AND v.mrc ='18') > 0 AND region = 12 AND r.id != 2293 AND r.id != 2292 AND enActivite = 1 GROUP BY r.id ORDER BY (SELECT COUNT(*) FROM utilisateurs u WHERE u.res_id = r.id AND u.relation = 'Client') DESC, RAND(367599) LIMIT 45,15