Select
nex_location.*,
nex_extras_fields.*,
INSCRIPTIONS.NOM_FICHIER_PHOTO,
INSCRIPTIONS.NO_INSCRIPTION,
MUNICIPALITES.DESCRIPTION,
REGIONS.DESCRIPTION_FRANCAISE AS Region,
INSCRIPTIONS.CODE_LANGUE_INSCRIPTION,
INSCRIPTIONS.AGENT_INSCRIPTEUR_1,
INSCRIPTIONS.BUREAU_INSCRIPTEUR_1,
INSCRIPTIONS.AGENT_INSCRIPTEUR_2,
INSCRIPTIONS.BUREAU_INSCRIPTEUR_2,
INSCRIPTIONS.PRIX_DEMANDE,
INSCRIPTIONS.UM_PRIX_DEMANDE,
INSCRIPTIONS.PRIX_LOCATION_DEMANDE,
INSCRIPTIONS.UM_PRIX_LOCATION_DEMANDE,
INSCRIPTIONS.DATE_INSCRIPTION,
INSCRIPTIONS.NB_PIECES,
INSCRIPTIONS.NOM_RUE_COMPLET,
INSCRIPTIONS.NO_CIVIQUE_DEBUT,
INSCRIPTIONS.CODE_POSTAL,
INSCRIPTIONS.NB_CHAMBRES,
INSCRIPTIONS.NB_SALLES_BAINS,
INSCRIPTIONS.NB_SALLES_EAU,
INSCRIPTIONS.IND_ADRESSE_SUR_INTERNET,
INSCRIPTIONS.SUPERFICIE_TERRAIN,
INSCRIPTIONS.UM_SUPERFICIE_TERRAIN,
INSCRIPTIONS.visible AS publish,
MEMBRES.NOM,
MEMBRES.PRENOM,
FIRMES.NOM_LEGAL,
TYPES_BANNIERES.NOM_FRANCAIS,
GENRES_PROPRIETES.DESCRIPTION_FRANCAISE AS `Type`
From
INSCRIPTIONS
LEFT Join nex_location ON INSCRIPTIONS.NO_INSCRIPTION = nex_location.NO_INSCRIPTION
LEFT Join nex_extras_fields ON INSCRIPTIONS.NO_INSCRIPTION = nex_extras_fields.NO_INSCRIPTION
Left Join MUNICIPALITES ON INSCRIPTIONS.MUN_CODE = MUNICIPALITES.CODE
Left Join REGIONS ON MUNICIPALITES.REGION_CODE = REGIONS.CODE
LEFT Join MEMBRES ON INSCRIPTIONS.AGENT_INSCRIPTEUR_1 = MEMBRES.CODE
LEFT Join BUREAUX ON INSCRIPTIONS.BUREAU_INSCRIPTEUR_1 = BUREAUX.CODE
LEFT Join FIRMES ON BUREAUX.FIRME_CODE = FIRMES.CODE
LEFT Join TYPES_BANNIERES ON FIRMES.BANNIERE_CODE = TYPES_BANNIERES.CODE
LEFT JOIN GENRES_PROPRIETES ON ( INSCRIPTIONS.GENRE_PROPRIETE = GENRES_PROPRIETES.GENRE_PROPRIETE AND INSCRIPTIONS.CATEGORIE_PROPRIETE = GENRES_PROPRIETES.CATEGORIE_PROPRIETE )
WHERE 1 AND( INSCRIPTIONS.AGENT_INSCRIPTEUR_1 LIKE 'MT82541' OR INSCRIPTIONS.AGENT_INSCRIPTEUR_2 LIKE 'MT82541' ) AND (INSCRIPTIONS.visible = 0) ORDER BY DATE_INSCRIPTION DESC LIMIT 0 , 10
