23 |
SELECT 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_achat, e.date_mandat, e.property_type,
e.house_type, e.type_transaction, e.created_at,
e.updated_at, e.active, e.prix_en_baisse, e.reduction,
e.nouveaute, e.nouveaute_accueil, e.coup_de_coeur,
e.coup_de_coeur_accueil, e.exclusivite,
e.exclusivite_accueil, e.vendu_loue, e.compromis, e.status,
e.images_url, e.build_quality, e.adress, e.code_postal,
e.ville, e.sector, e.departement, e.code_postal_web,
e.ville_web, e.coordonnees_gps, e.distance_to_shops,
e.distance_to_forest, e.distance_to_sea,
e.distance_to_mountain, e.distance_to_golf, e.price,
e.price_unit, e.fai, e.commission, e.taxe_fonciere,
e.taxe_habitation, e.charges, e.honoraires,
e.pourcentage_honoraire, e.frais_agence,
e.provisions_charges, e.depot_garantie, e.hc_cc,
e.type_affichage_honoraire, e.surface_habitable,
e.surface_terrain, e.surface_carrez, e.surface_sejour,
e.surface_chambre_1, e.surface_chambre_2, e.surface_cuisine,
e.surface_salon, e.surface_garage, e.disponibilite, e.mel,
e.etage, e.nbre_etages, e.plain_pied, e.annee_construction,
e.condition, e.nbre_pieces, e.nbre_chambres,
e.nbre_salles_bain, e.nbre_salles_eau, e.nbre_wc,
e.heating_type, e.heating_nature, e.meuble,
e.handicap_adapt, e.cuisine_equipee, e.with_terrasse,
e.with_garden, e.terrasses_number, e.with_parking,
e.parking_int_number, e.parking_ext_number, e.with_garage,
e.garages_box_number, e.lotissement, e.nbre_murs_mitoyens,
e.suite_parentale, e.kitchen, e.swimming_pool, e.cellar,
e.balcony, e.air_conditioning, e.veranda, e.terrain_tennis,
e.box_chevaux, e.four_pain, e.cellier, e.adsl, e.puit,
e.cheminee, e.buanderie, e.bureau, e.ramassage_scolaire,
e.sia, e.dressing, e.gardien, e.interphone, e.ascenseur,
e.alarme, e.niveaux, e.dependances, e.anciennete, e.dpe,
e.dpe_val, e.ges, e.ges_val, 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.keys, e.map, e.appreciation, 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.style, el.exposition, el.environment, el.view,
el.short_content, el.long_content, el.assainissement,
el.heating_mode, el.usages, el.bail_type, el.bail_duration,
el.cuisine, el.garden_infos, el.terrasse_infos,
el.services_proximite, el.dependance, el.title_tag,
el.meta_description, el.title_seo, el.meta_keywords,
el.slug, eci.category_id, eci.estate_i18n_id FROM
oktopusV4_mod_estate_i18n AS e LEFT JOIN
oktopusV4_mod_estate_i18n_locales AS el ON
el.estate_i18n_id=e.id LEFT JOIN
oktopusV4_mod_estate_i18n_categories_items AS eci ON
eci.estate_i18n_id=e.id LEFT JOIN
oktopusV4_mod_estate_i18n_legislations_items AS eli ON
eli.category_id=e.category_id LEFT JOIN oktopusV4_core_users
AS u ON u.id=e.user_id_updated WHERE 1 AND
el.language_code='fr' AND (e.property_type=2) AND
(e.vendu_loue=0) AND e.active=1 ORDER BY el.title ASC LIMIT
0,10
|
0.00326 |