SELECT annonces.*, villes.villeNom, villeCP, departement, regionFR, rubriqueFR, rubriqueNavi_FR AS rubriqueNom, rubriqueURL_FR, rubriqueFooter_FR FROM (annonces, rubriques) LEFT OUTER JOIN villes ON villes.villeID = annonces.villeID LEFT OUTER JOIN departements ON departements.departementCode = LEFT(annonces.villeID, 2) LEFT OUTER JOIN regions ON regions.regionID = annonces.regionID WHERE annonces.rubriqueID = rubriques.rubriqueID AND annonces.annonceID = '207871' AND ((DATE_SUB(CURDATE(),INTERVAL 84 DAY) <= dteModif AND annonceValid > 0 AND annonceEtat <> 'S' AND annonceEtat <> 'V') OR (annonces.annonceEtat <> 'S' AND annonces.userID = ''))