26 |
SELECT DISTINCT e.id, e.user_id_created, e.user_id_updated,
e.position, e.created_at, e.updated_at, e.reference,
e.num_mandat, e.date_mandat, e.property_type, e.house_type,
e.type_transaction, e.status, e.purchase_type,
e.rental_type, e.bail_type, e.annee_construction,
e.nbre_pieces, e.nbre_chambres, e.surface_terrain,
e.surface_unit, e.surface_habitable, e.surface_carrez,
e.surface_sejour, e.created_at, e.updated_at, e.images_url,
e.prix_en_baisse, e.compromis, e.coup_de_coeur,
e.coup_de_coeur_accueil, e.derniere_vente, e.exclusivite,
e.exclusivite_accueil, e.nouveaute, e.nouveaute_accueil,
e.active, e.adress, e.code_postal, e.ville, e.sector,
e.departement, e.coordonnees_gps, e.cp_afficher,
e.ville_afficher, e.price, e.price_unit, e.taxe_habitation,
e.charges, e.commission, e.frais_agence, e.fai,
e.taxe_fonciere, e.pourcentage_honoraire, e.hc_cc,
e.type_affichage_honoraire, e.honoraires,
e.provisions_charges, e.depot_garantie, e.etage,
e.nbre_etages, e.meuble, e.exposition, e.vis_a_vis,
e.services_proximite, e.kitchen, e.heating_type,
e.nbre_salles_bain, e.nbre_salles_eau, e.nbre_wc,
e.wc_separe, e.suite_parentale, e.dressing, e.bureau,
e.cellier, e.buanderie, e.particularity, e.comble, e.cellar,
e.balcony, e.veranda, e.terrasses_number, e.with_garden,
e.with_garage, e.garages_box_number, e.with_parking,
e.parking_int_number, e.parking_ext_number, e.dependances,
e.swimming_pool, e.terrain_tennis, e.box_chevaux,
e.air_conditioning, e.alarme, e.ascenseur, e.interphone,
e.gardien, e.plain_pied, e.mitoyennete,
e.nbre_murs_mitoyens, e.handicap_adapt, e.lotissement,
e.video, e.dpe, e.dpe_val, e.ges, e.ges_val, e.dpe_date,
e.dpe_annee_ref, e.dpe_montant_mini, e.dpe_montant_maxi,
e.cu, e.frais_plan_bornage, e.provisions_ass_syndic, e.shon,
e.eau_terrain, e.electricite_terrain,
e.tout_a_egout_terrain, e.telecommunication_terrain,
e.gaz_terrain, e.viabilise, e.depot_permis_construire,
e.coef_cos, e.emprise_au_sol, e.lot_number, e.parcel_number,
e.owner, e.residence_name, e.syndic, e.comments,
e.is_from_gateway, e.is_update_from_gateway, e.images,
e.files, el.estate_i18n_id, el.language_code, el.title,
el.bail_duration, el.short_content, el.long_content,
el.title_tag, el.meta_description, el.title_seo,
el.meta_keywords, el.slug, eci.category_id,
eci.estate_i18n_id FROM oktopusV5_mod_estate_i18n AS e LEFT
JOIN oktopusV5_mod_estate_i18n_locales AS el ON
el.estate_i18n_id=e.id LEFT JOIN
oktopusV5_mod_estate_i18n_categories_items AS eci ON
eci.estate_i18n_id=e.id LEFT JOIN
oktopusV5_mod_estate_i18n_legislations_items AS eli ON
eli.category_id=e.category_id LEFT JOIN oktopusV5_core_users
AS u ON u.id=e.user_id_updated WHERE 1 AND
el.language_code='fr' AND e.status NOT IN (6,7) AND
e.type_transaction IN (3) AND e.rental_type IN (55) AND
e.active=1 ORDER BY el.title ASC LIMIT 0,9
|
0.00720 |