DUMP: 

    SELECT
      a.id_annonce,
      a.id_type_offre,
      a.id_sous_type_bien,
      a.nom_rue,
      a.num_rue,
      a.nb_piece as rooms,
      v.libelle as city,
      q.libelle as city_part,
      tsb.libelle as property_type,
      ttc.libelle as commercial,
      l.id__langue as lang_id,
      l._langue_abrev as lang
    FROM
      annonce a 
      INNER JOIN ville v on a.id_ville = v.id_ville
      INNER JOIN trad_annonce ta ON ta.id__annonce = a.id_annonce
      LEFT JOIN quartier q ON a.id_quartier = q.id_quartier
      LEFT JOIN trad_sous_type_bien tsb ON a.id_sous_type_bien = tsb.id__sous_type_bien AND tsb.id__langue IN (5)
      LEFT JOIN trad_type_commercial ttc ON a.id_type_commercial = ttc.id__type_commercial AND ttc.id__langue = tsb.id__langue
      LEFT JOIN _langue l ON l.id__langue = tsb.id__langue
    WHERE
    	ta.nice_url = ''
     	 AND a.id_annonce = '111816' limit 1 
  	ORDER BY a.id_annonce ASC

Exportujú k nám