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 'MT83073' OR INSCRIPTIONS.AGENT_INSCRIPTEUR_2 LIKE 'MT83073' ) AND (INSCRIPTIONS.visible = 0) ORDER BY DATE_INSCRIPTION DESC LIMIT 0 , 10