SET NAMES utf8mb4

SELECT u.*, g.*, o.logged, o.csrf_token, o.prev_url FROM
oktopusV5_core_users AS u INNER JOIN
oktopusV5_core_users_groups AS g ON g.group_id=u.group_id
LEFT JOIN oktopusV5_core_users_online AS o ON
o.ident='35.171.183.133' WHERE u.id=1

UPDATE oktopusV5_core_users_online SET logged=1642624858,
prev_url='https://www.immocentrefrance.fr/agence/agence-d-ygrande'
WHERE ident='35.171.183.133'

SELECT ec.id, ec.user_id_created, ec.user_id_updated,
ecl.category_id, ecl.language_code, ecl.name, ecl.slug FROM
oktopusV5_mod_estate_i18n_categories AS ec LEFT JOIN
oktopusV5_mod_estate_i18n_categories_locales AS ecl ON
ecl.category_id=ec.id WHERE 1 AND ecl.language_code='fr' 
AND ec.active=1 

SELECT ec.id, ec.user_id_created, ec.user_id_updated,
ecl.category_id, ecl.language_code, ecl.name, ecl.slug FROM
oktopusV5_mod_estate_i18n_categories AS ec LEFT JOIN
oktopusV5_mod_estate_i18n_categories_locales AS ecl ON
ecl.category_id=ec.id WHERE 1 AND ecl.language_code='fr' 
AND ec.active=1 

SELECT tr.id, field, tr.depending_data, tr.min, tr.max FROM
oktopusV5_mod_estate_i18n_tranches AS tr WHERE 1  AND
tr.field='price' ORDER BY tr.id ASC 

SELECT tr.id, field, tr.depending_data, tr.min, tr.max FROM
oktopusV5_mod_estate_i18n_tranches AS tr WHERE 1  AND
tr.field='surface_habitable' ORDER BY tr.id ASC 

SELECT tr.id, field, tr.depending_data, tr.min, tr.max FROM
oktopusV5_mod_estate_i18n_tranches AS tr WHERE 1  AND
tr.field='surface_terrain' ORDER BY tr.id ASC 

SELECT ec.id, ec.user_id_created, ec.user_id_updated,
ecl.category_id, ecl.language_code, ecl.name, ecl.slug FROM
oktopusV5_mod_estate_i18n_categories AS ec LEFT JOIN
oktopusV5_mod_estate_i18n_categories_locales AS ecl ON
ecl.category_id=ec.id WHERE 1 AND ecl.language_code='fr' 
AND ec.active=1 

SELECT dt.*, dtl.* FROM oktopusV5_mod_estate_i18n_data_types
AS dt LEFT JOIN oktopusV5_mod_estate_i18n_data_types_locales
AS dtl ON dtl.data_type_id = dt.id WHERE 1  AND dt.data_type
= "property_type" AND dtl.language_code='fr' AND dt.active=1
ORDER BY position 

SELECT dt.*, dtl.* FROM oktopusV5_mod_estate_i18n_data_types
AS dt LEFT JOIN oktopusV5_mod_estate_i18n_data_types_locales
AS dtl ON dtl.data_type_id = dt.id WHERE 1  AND dt.data_type
= "house_type" AND dtl.language_code='fr' AND dt.active=1
ORDER BY position 

SELECT dt.*, dtl.* FROM oktopusV5_mod_estate_i18n_data_types
AS dt LEFT JOIN oktopusV5_mod_estate_i18n_data_types_locales
AS dtl ON dtl.data_type_id = dt.id WHERE 1  AND dt.data_type
= "purchase_type" AND dtl.language_code='fr' AND dt.active=1
ORDER BY position 

SELECT dt.*, dtl.* FROM oktopusV5_mod_estate_i18n_data_types
AS dt LEFT JOIN oktopusV5_mod_estate_i18n_data_types_locales
AS dtl ON dtl.data_type_id = dt.id WHERE 1  AND dt.data_type
= "rental_type" AND dtl.language_code='fr' AND dt.active=1
ORDER BY position 

SELECT dt.*, dtl.* FROM oktopusV5_mod_estate_i18n_data_types
AS dt LEFT JOIN oktopusV5_mod_estate_i18n_data_types_locales
AS dtl ON dtl.data_type_id = dt.id WHERE 1  AND dt.data_type
= "lease_type" AND dtl.language_code='fr' AND dt.active=1
ORDER BY position 

SELECT dt.*, dtl.* FROM oktopusV5_mod_estate_i18n_data_types
AS dt LEFT JOIN oktopusV5_mod_estate_i18n_data_types_locales
AS dtl ON dtl.data_type_id = dt.id WHERE 1  AND dt.data_type
= "sector" AND dtl.language_code='fr' AND dt.active=1 ORDER
BY position 

SELECT dt.*, dtl.* FROM oktopusV5_mod_estate_i18n_data_types
AS dt LEFT JOIN oktopusV5_mod_estate_i18n_data_types_locales
AS dtl ON dtl.data_type_id = dt.id WHERE 1  AND dt.data_type
= "environment" AND dtl.language_code='fr' AND dt.active=1
ORDER BY position 

SELECT dt.*, dtl.* FROM oktopusV5_mod_estate_i18n_data_types
AS dt LEFT JOIN oktopusV5_mod_estate_i18n_data_types_locales
AS dtl ON dtl.data_type_id = dt.id WHERE 1  AND dt.data_type
= "kitchen" AND dtl.language_code='fr' AND dt.active=1 ORDER
BY position 

SELECT dt.*, dtl.* FROM oktopusV5_mod_estate_i18n_data_types
AS dt LEFT JOIN oktopusV5_mod_estate_i18n_data_types_locales
AS dtl ON dtl.data_type_id = dt.id WHERE 1  AND dt.data_type
= "heating_type" AND dtl.language_code='fr' AND dt.active=1
ORDER BY position 

SELECT dt.*, dtl.* FROM oktopusV5_mod_estate_i18n_data_types
AS dt LEFT JOIN oktopusV5_mod_estate_i18n_data_types_locales
AS dtl ON dtl.data_type_id = dt.id WHERE 1  AND dt.data_type
= "particularity" AND dtl.language_code='fr' AND dt.active=1
ORDER BY position 

SELECT o.id, o.user_id_created, o.user_id_updated,
o.lastname, o.firstname, o.adress, o.zip, o.city, o.tel,
o.gsm_tel_1, o.gsm_tel_2, o.fax, o.mail, o.comments,
o.active, o.position, o.created_at, o.updated_at FROM
oktopusV5_mod_estate_i18n_owners AS o WHERE 1 AND o.active=1
ORDER BY lastname 

SELECT ec.id, ec.user_id_created, ec.user_id_updated,
ec.position, ec.parent_id, ec.level, ec.parent_id, ec.ref,
ec.tel, ec.gsm_tel, ec.fax, ec.mail, ec.adress, ec.zip,
ec.city, ec.coordonnees_gps, ec.created_at, ec.updated_at,
ec.active, ec.coup_coeur, ec.images_url, ec.avancement,
ec.images, ec.files, ecl.category_id, ecl.language_code,
ecl.name, ecl.meta_title, ecl.meta_description,
ecl.meta_keywords, ecl.slug, ecl.details_avancement,
ecl.les_plus, ecl.description FROM
oktopusV5_mod_estate_i18n_categories AS ec LEFT JOIN
oktopusV5_mod_estate_i18n_categories_locales AS ecl ON
ecl.category_id=ec.id LEFT JOIN oktopusV5_core_users AS u ON
u.id=ec.user_id_updated WHERE 1  AND ecl.language_code='fr' 
AND ecl.slug='agence-d-ygrande' AND ec.active=1 ORDER BY
ec.nleft ASC 

SELECT * FROM oktopusV5_mod_estate_i18n_legislations_items
WHERE category_id=1

SELECT f.*, fl.title FROM
oktopusV5_mod_estate_i18n_search_fields f LEFT JOIN
oktopusV5_mod_estate_i18n_search_fields_locales AS fl ON
fl.field_id=f.id AND fl.search_id=f.search_id WHERE 1  AND
f.active>0 ORDER BY ord ASC 

SELECT ec.id, ec.user_id_created, ec.user_id_updated,
ecl.category_id, ecl.language_code, ecl.name, ecl.slug FROM
oktopusV5_mod_estate_i18n_categories AS ec LEFT JOIN
oktopusV5_mod_estate_i18n_categories_locales AS ecl ON
ecl.category_id=ec.id WHERE 1 AND ecl.language_code='fr' 
AND ec.active=1 

SELECT dt.*, dtl.* FROM oktopusV5_mod_estate_i18n_data_types
AS dt LEFT JOIN oktopusV5_mod_estate_i18n_data_types_locales
AS dtl ON dtl.data_type_id = dt.id WHERE 1  AND dt.data_type
= "property_type" AND dtl.language_code='fr' AND dt.active=1
ORDER BY position 

SELECT COUNT(e.id) AS num_items 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 WHERE 1  AND
el.language_code='fr'  AND (eci.category_id=1) AND
e.active=1 

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.iframe, 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 (eci.category_id=1) AND
e.active=1 ORDER BY e.created_at ASC LIMIT 0,12 

SELECT dt.*, dtl.* FROM oktopusV5_mod_estate_i18n_data_types
AS dt LEFT JOIN oktopusV5_mod_estate_i18n_data_types_locales
AS dtl ON dtl.data_type_id = dt.id WHERE 1  AND dt.data_type
= "property_type" AND dtl.language_code='fr' AND dt.active=1
ORDER BY position 

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.iframe, 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 e.id = 859 ORDER
BY e.id DESC 

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.iframe, 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 e.id = 859 ORDER
BY e.id DESC 

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.iframe, 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 e.id = 860 ORDER
BY e.id DESC 

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.iframe, 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 e.id = 860 ORDER
BY e.id DESC 

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.iframe, 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 e.id = 861 ORDER
BY e.id DESC 

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.iframe, 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 e.id = 861 ORDER
BY e.id DESC 

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.iframe, 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 e.id = 862 ORDER
BY e.id DESC 

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.iframe, 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 e.id = 862 ORDER
BY e.id DESC 

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.iframe, 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 e.id = 863 ORDER
BY e.id DESC 

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.iframe, 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 e.id = 863 ORDER
BY e.id DESC 

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.iframe, 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 e.id = 864 ORDER
BY e.id DESC 

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.iframe, 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 e.id = 864 ORDER
BY e.id DESC 

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.iframe, 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 e.id = 865 ORDER
BY e.id DESC 

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.iframe, 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 e.id = 865 ORDER
BY e.id DESC 

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.iframe, 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 e.id = 866 ORDER
BY e.id DESC 

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.iframe, 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 e.id = 866 ORDER
BY e.id DESC 

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.iframe, 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 e.id = 867 ORDER
BY e.id DESC 

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.iframe, 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 e.id = 867 ORDER
BY e.id DESC 

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.iframe, 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 e.id = 868 ORDER
BY e.id DESC 

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.iframe, 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 e.id = 868 ORDER
BY e.id DESC 

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.iframe, 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 e.id = 869 ORDER
BY e.id DESC 

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.iframe, 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 e.id = 869 ORDER
BY e.id DESC 

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.iframe, 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 e.id = 870 ORDER
BY e.id DESC 

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.iframe, 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 e.id = 870 ORDER
BY e.id DESC 

 SELECT t.*,
                            DATE_FORMAT(t.date_creation,
'%d/%m/%Y %H:%i:%s') as date_creation_fr,
                            DATE_FORMAT(t.date_modification,
'%d/%m/%Y %H:%i:%s') as date_modification_fr
                       FROM oktopusV5_mod_slideshow_type t
                       WHERE 1 AND CASE 
                                       WHEN t.choix_rubrique
= 1 THEN
                                           t.rubrique LIKE
'%\'/agence/agence-d-ygrande\'%'
                                       WHEN t.choix_rubrique
= 2 THEN
                                          
                   (  SELECT COUNT(t.id_type) FROM
oktopusV5_mod_slideshow_type t
                      WHERE t.choix_rubrique = 1 AND
t.rubrique LIKE '%\'/agence/agence-d-ygrande\'%' AND t.actif
= 1
                   ) = 0
                
                                           AND
                                           t.rubrique NOT
LIKE '%\'/agence/agence-d-ygrande\'%'
                                       ELSE     
                                          
                   (  SELECT COUNT(t.id_type) FROM
oktopusV5_mod_slideshow_type t
                      WHERE t.choix_rubrique = 1 AND
t.rubrique LIKE '%\'/agence/agence-d-ygrande\'%' AND t.actif
= 1
                   ) = 0
                 
                                   END AND actif = '1' ORDER
BY nom 

SELECT t.*, 
                        DATE_FORMAT(t.date_creation,
'%d/%m/%Y %H:%i:%s') as date_creation_fr,
                        DATE_FORMAT(t.date_modification,
'%d/%m/%Y %H:%i:%s') as date_modification_fr 
                     FROM oktopusV5_mod_slideshow_type t
                     WHERE t.id_type = '2'

 SELECT p.*, pl.valeur AS legende, pl.lien,
pl.contenu_titre,  pl.contenu_ss_titre,
pl.contenu_description, pl.primaire_texte,
pl.primaire_texte_mobile, pl.secondaire_texte,
pl.secondaire_texte_mobile, pl.primaire_slug,
pl.secondaire_slug, pl.lien2,  
                          DATE_FORMAT(p.date_creation,
'%d/%m/%Y %H:%i:%s') as date_creation_fr,
                          DATE_FORMAT(p.date_modification,
'%d/%m/%Y %H:%i:%s') as date_modification_fr
                       FROM oktopusV5_mod_slideshow p
                       LEFT JOIN
oktopusV5_mod_slideshow_locales pl ON pl.id_slideshow =
p.id_slideshow AND pl.language = 'fr'
                       WHERE 1 AND p.actif = '1' AND id_type
= '2' ORDER BY position

SELECT f.*, fl.title FROM
oktopusV5_mod_estate_i18n_search_fields f LEFT JOIN
oktopusV5_mod_estate_i18n_search_fields_locales AS fl ON
fl.field_id=f.id AND fl.search_id=f.search_id WHERE 1  AND
f.active>0 ORDER BY ord ASC 

SELECT ec.id, ec.user_id_created, ec.user_id_updated,
ecl.category_id, ecl.language_code, ecl.name, ecl.slug FROM
oktopusV5_mod_estate_i18n_categories AS ec LEFT JOIN
oktopusV5_mod_estate_i18n_categories_locales AS ecl ON
ecl.category_id=ec.id WHERE 1 AND ecl.language_code='fr' 
AND ec.active=1 

SELECT dt.*, dtl.* FROM oktopusV5_mod_estate_i18n_data_types
AS dt LEFT JOIN oktopusV5_mod_estate_i18n_data_types_locales
AS dtl ON dtl.data_type_id = dt.id WHERE 1  AND dt.data_type
= "property_type" AND dtl.language_code='fr' AND dt.active=1
ORDER BY position 

SELECT id, title FROM oktopusV5_mod_estate_i18n_search WHERE
1  AND id=2 ORDER BY title ASC 

SELECT f.*, fl.title FROM
oktopusV5_mod_estate_i18n_search_fields f LEFT JOIN
oktopusV5_mod_estate_i18n_search_fields_locales AS fl ON
fl.field_id=f.id AND fl.search_id=f.search_id WHERE 1  AND
f.active>0  AND f.search_id = "2" ORDER BY ord ASC 

SELECT ec.id, ec.user_id_created, ec.user_id_updated,
ecl.category_id, ecl.language_code, ecl.name, ecl.slug FROM
oktopusV5_mod_estate_i18n_categories AS ec LEFT JOIN
oktopusV5_mod_estate_i18n_categories_locales AS ecl ON
ecl.category_id=ec.id WHERE 1 AND ecl.language_code='fr' 
AND ec.active=1 

SELECT dt.*, dtl.* FROM oktopusV5_mod_estate_i18n_data_types
AS dt LEFT JOIN oktopusV5_mod_estate_i18n_data_types_locales
AS dtl ON dtl.data_type_id = dt.id WHERE 1  AND dt.data_type
= "property_type" AND dtl.language_code='fr' AND dt.active=1
ORDER BY position 

SELECT tr.id, field, tr.depending_data, tr.min, tr.max FROM
oktopusV5_mod_estate_i18n_tranches AS tr WHERE 1  AND
tr.field='price' ORDER BY tr.id ASC 

SELECT f.*, fl.title FROM
oktopusV5_mod_estate_i18n_search_fields f LEFT JOIN
oktopusV5_mod_estate_i18n_search_fields_locales AS fl ON
fl.field_id=f.id AND fl.search_id=f.search_id WHERE 1  AND
f.active>0 ORDER BY ord ASC 

SELECT ec.id, ec.user_id_created, ec.user_id_updated,
ecl.category_id, ecl.language_code, ecl.name, ecl.slug FROM
oktopusV5_mod_estate_i18n_categories AS ec LEFT JOIN
oktopusV5_mod_estate_i18n_categories_locales AS ecl ON
ecl.category_id=ec.id WHERE 1 AND ecl.language_code='fr' 
AND ec.active=1 

SELECT dt.*, dtl.* FROM oktopusV5_mod_estate_i18n_data_types
AS dt LEFT JOIN oktopusV5_mod_estate_i18n_data_types_locales
AS dtl ON dtl.data_type_id = dt.id WHERE 1  AND dt.data_type
= "property_type" AND dtl.language_code='fr' AND dt.active=1
ORDER BY position 

#0 in_array( called at [/oktThemes/default/templates/slideshow/insert/r-splide/template.php:155]

#1 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]

#2 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]

#3 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#4 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateRenderer.php:45]

#5 sfTemplateRenderer->__call( called at [/oktThemes/rci10/templates/layout.php:82]

#6 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]

#7 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]

#8 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#9 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:117]

#10 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#11 oktTemplating->render( called at [/oktModules/estate_i18n/inc/class.estate_i18n.controller.php:1034]

#12 estate_i18nController->estate_i18nCategory( called at [/oktInc/classes/router/class.oktRouter.php:317]

#13 oktRouter->callRouteHanlder( called at [/oktopus.php:58]

#0 in_array( called at [/oktThemes/default/templates/slideshow/insert/r-splide/template.php:160]

#1 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]

#2 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]

#3 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#4 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateRenderer.php:45]

#5 sfTemplateRenderer->__call( called at [/oktThemes/rci10/templates/layout.php:82]

#6 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]

#7 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]

#8 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#9 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:117]

#10 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#11 oktTemplating->render( called at [/oktModules/estate_i18n/inc/class.estate_i18n.controller.php:1034]

#12 estate_i18nController->estate_i18nCategory( called at [/oktInc/classes/router/class.oktRouter.php:317]

#13 oktRouter->callRouteHanlder( called at [/oktopus.php:58]

#0 in_array( called at [/oktThemes/default/templates/slideshow/insert/r-splide/template.php:165]

#1 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]

#2 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]

#3 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#4 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateRenderer.php:45]

#5 sfTemplateRenderer->__call( called at [/oktThemes/rci10/templates/layout.php:82]

#6 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]

#7 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]

#8 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#9 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:117]

#10 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#11 oktTemplating->render( called at [/oktModules/estate_i18n/inc/class.estate_i18n.controller.php:1034]

#12 estate_i18nController->estate_i18nCategory( called at [/oktInc/classes/router/class.oktRouter.php:317]

#13 oktRouter->callRouteHanlder( called at [/oktopus.php:58]

#0 in_array( called at [/oktThemes/default/templates/slideshow/insert/r-splide/template.php:170]

#1 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]

#2 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]

#3 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#4 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateRenderer.php:45]

#5 sfTemplateRenderer->__call( called at [/oktThemes/rci10/templates/layout.php:82]

#6 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]

#7 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]

#8 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#9 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:117]

#10 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#11 oktTemplating->render( called at [/oktModules/estate_i18n/inc/class.estate_i18n.controller.php:1034]

#12 estate_i18nController->estate_i18nCategory( called at [/oktInc/classes/router/class.oktRouter.php:317]

#13 oktRouter->callRouteHanlder( called at [/oktopus.php:58]

#0 in_array( called at [/oktThemes/default/templates/slideshow/insert/r-splide/template.php:155]

#1 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]

#2 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]

#3 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#4 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateRenderer.php:45]

#5 sfTemplateRenderer->__call( called at [/oktThemes/rci10/templates/layout.php:82]

#6 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]

#7 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]

#8 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#9 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:117]

#10 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#11 oktTemplating->render( called at [/oktModules/estate_i18n/inc/class.estate_i18n.controller.php:1034]

#12 estate_i18nController->estate_i18nCategory( called at [/oktInc/classes/router/class.oktRouter.php:317]

#13 oktRouter->callRouteHanlder( called at [/oktopus.php:58]

#0 in_array( called at [/oktThemes/default/templates/slideshow/insert/r-splide/template.php:160]

#1 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]

#2 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]

#3 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#4 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateRenderer.php:45]

#5 sfTemplateRenderer->__call( called at [/oktThemes/rci10/templates/layout.php:82]

#6 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]

#7 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]

#8 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#9 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:117]

#10 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#11 oktTemplating->render( called at [/oktModules/estate_i18n/inc/class.estate_i18n.controller.php:1034]

#12 estate_i18nController->estate_i18nCategory( called at [/oktInc/classes/router/class.oktRouter.php:317]

#13 oktRouter->callRouteHanlder( called at [/oktopus.php:58]

#0 in_array( called at [/oktThemes/default/templates/slideshow/insert/r-splide/template.php:165]

#1 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]

#2 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]

#3 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#4 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateRenderer.php:45]

#5 sfTemplateRenderer->__call( called at [/oktThemes/rci10/templates/layout.php:82]

#6 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]

#7 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]

#8 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#9 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:117]

#10 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#11 oktTemplating->render( called at [/oktModules/estate_i18n/inc/class.estate_i18n.controller.php:1034]

#12 estate_i18nController->estate_i18nCategory( called at [/oktInc/classes/router/class.oktRouter.php:317]

#13 oktRouter->callRouteHanlder( called at [/oktopus.php:58]

#0 in_array( called at [/oktThemes/default/templates/slideshow/insert/r-splide/template.php:170]

#1 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]

#2 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]

#3 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#4 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateRenderer.php:45]

#5 sfTemplateRenderer->__call( called at [/oktThemes/rci10/templates/layout.php:82]

#6 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]

#7 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]

#8 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#9 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:117]

#10 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#11 oktTemplating->render( called at [/oktModules/estate_i18n/inc/class.estate_i18n.controller.php:1034]

#12 estate_i18nController->estate_i18nCategory( called at [/oktInc/classes/router/class.oktRouter.php:317]

#13 oktRouter->callRouteHanlder( called at [/oktopus.php:58]

#0 in_array( called at [/oktThemes/default/templates/slideshow/insert/r-splide/template.php:155]

#1 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]

#2 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]

#3 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#4 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateRenderer.php:45]

#5 sfTemplateRenderer->__call( called at [/oktThemes/rci10/templates/layout.php:82]

#6 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]

#7 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]

#8 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#9 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:117]

#10 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#11 oktTemplating->render( called at [/oktModules/estate_i18n/inc/class.estate_i18n.controller.php:1034]

#12 estate_i18nController->estate_i18nCategory( called at [/oktInc/classes/router/class.oktRouter.php:317]

#13 oktRouter->callRouteHanlder( called at [/oktopus.php:58]

#0 in_array( called at [/oktThemes/default/templates/slideshow/insert/r-splide/template.php:160]

#1 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]

#2 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]

#3 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#4 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateRenderer.php:45]

#5 sfTemplateRenderer->__call( called at [/oktThemes/rci10/templates/layout.php:82]

#6 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]

#7 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]

#8 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#9 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:117]

#10 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#11 oktTemplating->render( called at [/oktModules/estate_i18n/inc/class.estate_i18n.controller.php:1034]

#12 estate_i18nController->estate_i18nCategory( called at [/oktInc/classes/router/class.oktRouter.php:317]

#13 oktRouter->callRouteHanlder( called at [/oktopus.php:58]

#0 in_array( called at [/oktThemes/default/templates/slideshow/insert/r-splide/template.php:165]

#1 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]

#2 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]

#3 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#4 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateRenderer.php:45]

#5 sfTemplateRenderer->__call( called at [/oktThemes/rci10/templates/layout.php:82]

#6 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]

#7 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]

#8 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#9 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:117]

#10 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#11 oktTemplating->render( called at [/oktModules/estate_i18n/inc/class.estate_i18n.controller.php:1034]

#12 estate_i18nController->estate_i18nCategory( called at [/oktInc/classes/router/class.oktRouter.php:317]

#13 oktRouter->callRouteHanlder( called at [/oktopus.php:58]

#0 in_array( called at [/oktThemes/default/templates/slideshow/insert/r-splide/template.php:170]

#1 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]

#2 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]

#3 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#4 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateRenderer.php:45]

#5 sfTemplateRenderer->__call( called at [/oktThemes/rci10/templates/layout.php:82]

#6 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]

#7 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]

#8 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#9 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:117]

#10 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#11 oktTemplating->render( called at [/oktModules/estate_i18n/inc/class.estate_i18n.controller.php:1034]

#12 estate_i18nController->estate_i18nCategory( called at [/oktInc/classes/router/class.oktRouter.php:317]

#13 oktRouter->callRouteHanlder( called at [/oktopus.php:58]