SELECT
inscriptions.NO_INSCRIPTION,
inscriptions.GENRE_PROPRIETE,
inscriptions.NO_CIVIQUE_DEBUT,
inscriptions.NOM_RUE_COMPLET,
inscriptions.PRIX_DEMANDE,
inscriptions.PRIX_LOCATION_DEMANDE,
inscriptions.CODE_STATUT,
inscriptions.NO_INSCRIPTION,
inscriptions.MUN_CODE,
inscriptions.QUARTR_CODE,
inscriptions.DATE_MISE_EN_VIGUEUR,
inscriptions.CATEGORIE_PROPRIETE AS inscriptions_Cat,
inscriptions.COURTIER_INSCRIPTEUR_1,
inscriptions.NB_CHAMBRES,
inscriptions.NB_SALLES_BAINS,
quartiers.DESCRIPTION_FRANCAISE,
photos.PhotoURL,
membres.PRENOM,
municipalites.CODE as municipalites_Id,
municipalites.DESCRIPTION as municipalites_Description
FROM inscriptions, quartiers , municipalites, photos, membres
WHERE COURTIER_INSCRIPTEUR_1 IN (1046616,107421,102278,1047134, 107130) AND municipalites.CODE=inscriptions.MUN_CODE
AND photos.NO_INSCRIPTION = inscriptions.NO_INSCRIPTION
AND quartiers.MUN_CODE = inscriptions.MUN_CODE GROUP BY NO_INSCRIPTION ORDER BY DATE_MISE_EN_VIGUEUR DESC LIMIT 0, 10
