| 1 |
0.71 ms |
SELECT t0.id AS id_2, t0.ref_netty AS ref_netty_3, t0.ref_contract AS ref_contract_4, t0.ref_sage AS ref_sage_5, t0.ref_ubiflow_promup AS ref_ubiflow_promup_6, t0.ref_ubiflow_kimpli AS ref_ubiflow_kimpli_7, t0.ref_bienpreter_promup AS ref_bienpreter_promup_8, t0.ref_bienpreter_kimpli AS ref_bienpreter_kimpli_9, t0.ref_bienpreter_kimpli_invest AS ref_bienpreter_kimpli_invest_10, t0.designation AS designation_11, t0.title AS title_12, t0.summary AS summary_13, t0.description AS description_14, t0.price AS price_15, t0.loc_lat AS loc_lat_16, t0.loc_lng AS loc_lng_17, t0.remarks AS remarks_18, t0.primary_info AS primary_info_19, t0.statistics AS statistics_20, t0.notary_name AS notary_name_21, t0.notary_info AS notary_info_22, t0.notary_email AS notary_email_23, t0.links AS links_24, t0.package_price AS package_price_25, t0.is_package_price_edited AS is_package_price_edited_26, t0.is_diffusion AS is_diffusion_27, t0.startup_delay AS startup_delay_28, t0.start_selling_at AS start_selling_at_29, t0.start_price AS start_price_30, t0.start_price_now AS start_price_now_31, t0.start_estimated_by AS start_estimated_by_32, t0.start_has_compromise AS start_has_compromise_33, t0.start_is_agency AS start_is_agency_34, t0.start_agency_type AS start_agency_type_35, t0.start_nb_agency AS start_nb_agency_36, t0.available_at AS available_at_37, t0.start_nb_appointments AS start_nb_appointments_38, t0.start_selling_delay AS start_selling_delay_39, t0.start_selling_reason AS start_selling_reason_40, t0.nb_views AS nb_views_41, t0.nb_demands AS nb_demands_42, t0.nb_appointments AS nb_appointments_43, t0.nb_offers AS nb_offers_44, t0.status AS status_45, t0.archived AS archived_46, t0.bp_status_promup AS bp_status_promup_47, t0.bp_status_kimpli AS bp_status_kimpli_48, t0.bp_status_kimpli_invest AS bp_status_kimpli_invest_49, t0.bp_first_funded_at_promup AS bp_first_funded_at_promup_50, t0.bp_first_funded_at_kimpli AS bp_first_funded_at_kimpli_51, t0.bp_first_funded_at_kimpli_invest AS bp_first_funded_at_kimpli_invest_52, t0.is_writing_asked AS is_writing_asked_53, t0.is_writing_featured AS is_writing_featured_54, t0.writing_validation AS writing_validation_55, t0.retractation_choice AS retractation_choice_56, t0.presta_info AS presta_info_57, t0.presta_step AS presta_step_58, t0.status_reason AS status_reason_59, t0.is_pre_litigation AS is_pre_litigation_60, t0.litigation_reason AS litigation_reason_61, t0.is_customer_validated AS is_customer_validated_62, t0.is_payable AS is_payable_63, t0.is_compromise_offer AS is_compromise_offer_64, t0.is_compromise AS is_compromise_65, t0.is_photographer_cancelled AS is_photographer_cancelled_66, t0.is_photographer_confirmed AS is_photographer_confirmed_67, t0.is_photographer_validated AS is_photographer_validated_68, t0.is_snapshots_needed AS is_snapshots_needed_69, t0.is_sold_by_promup AS is_sold_by_promup_70, t0.is_payment_by_notary AS is_payment_by_notary_71, t0.is_multiple_payments AS is_multiple_payments_72, t0.filename AS filename_73, t0.photograph_brief AS photograph_brief_74, t0.url_video AS url_video_75, t0.url_video_youtube_id AS url_video_youtube_id_76, t0.url_video_360 AS url_video_360_77, t0.comment AS comment_78, t0.phone AS phone_79, t0.contract_nb_signatures AS contract_nb_signatures_80, t0.contract_guarantor AS contract_guarantor_81, t0.contract_proxy AS contract_proxy_82, t0.contract_signed_where AS contract_signed_where_83, t0.logs AS logs_84, t0.created_at AS created_at_85, t0.updated_at AS updated_at_86, t0.writer_validated_at AS writer_validated_at_87, t0.contract_signed_at AS contract_signed_at_88, t0.contract_validated_at AS contract_validated_at_89, t0.compromise_signed_at AS compromise_signed_at_90, t0.authentic_act_signed_at AS authentic_act_signed_at_91, t0.notary_last_call AS notary_last_call_92, t0.notary1_sent_at AS notary1_sent_at_93, t0.notary2_sent_at AS notary2_sent_at_94, t0.notary_paid_writing_at AS notary_paid_writing_at_95, t0.pictured_at AS pictured_at_96, t0.bat_sent_at AS bat_sent_at_97, t0.bat_validated_at AS bat_validated_at_98, t0.litigation_started_at AS litigation_started_at_99, t0.litigation_ended_at AS litigation_ended_at_100, t0.rar1_sent_at AS rar1_sent_at_101, t0.rar1_received_at AS rar1_received_at_102, t0.rar2_sent_at AS rar2_sent_at_103, t0.rar2_received_at AS rar2_received_at_104, t0.rar3_sent_at AS rar3_sent_at_105, t0.rar3_received_at AS rar3_received_at_106, t0.last_writing_at AS last_writing_at_107, t0.contract_received_at AS contract_received_at_108, t0.open_at AS open_at_109, t0.customer_id AS customer_id_110, t0.user_consulting_id AS user_consulting_id_111, t0.user_telemarketing_id AS user_telemarketing_id_112, t0.user_photographer_id AS user_photographer_id_113, t0.user_writer_id AS user_writer_id_114, t0.user_bienpreter_id AS user_bienpreter_id_115, t0.department_id AS department_id_116, t0.address_id AS address_id_117, t0.compromise_appointment_id AS compromise_appointment_id_118, t0.promup_info_id AS promup_info_id_119, t0.notary_address_id AS notary_address_id_120, t0.open_by AS open_by_121, t0.type, t1.estate_detail AS estate_detail_122, t1.opening_time AS opening_time_123, t1.category AS category_124, t1.category_precision AS category_precision_125, t1.business_name AS business_name_126, t1.business_activity AS business_activity_127, t1.ref_cadastral AS ref_cadastral_128, t1.material AS material_129, t1.roofing AS roofing_130, t1.carpentry AS carpentry_131, t1.glazing AS glazing_132, t1.environment AS environment_133, t1.`view` AS view_134, t1.kitchen_equipment AS kitchen_equipment_135, t1.kitchen_style AS kitchen_style_136, t1.kitchen_detail AS kitchen_detail_137, t1.neighbors_distance AS neighbors_distance_138, t1.construction_year AS construction_year_139, t1.renovation_year AS renovation_year_140, t1.land_space AS land_space_141, t1.living_space AS living_space_142, t1.floor_space AS floor_space_143, t1.detail_space AS detail_space_144, t1.detail_building_permit AS detail_building_permit_145, t1.global_condition AS global_condition_146, t1.interior_condition AS interior_condition_147, t1.exterior_condition AS exterior_condition_148, t1.roofing_condition AS roofing_condition_149, t1.common_condition AS common_condition_150, t1.joint_ownership AS joint_ownership_151, t1.nb_floors AS nb_floors_152, t1.nb_apartments AS nb_apartments_153, t1.nb_rooms AS nb_rooms_154, t1.nb_bed_rooms AS nb_bed_rooms_155, t1.nb_bath_rooms AS nb_bath_rooms_156, t1.nb_shower_rooms AS nb_shower_rooms_157, t1.nb_toilet_rooms AS nb_toilet_rooms_158, t1.appartment_options AS appartment_options_159, t1.gate AS gate_160, t1.gate_options AS gate_options_161, t1.is_buildable AS is_buildable_162, t1.is_building_permit AS is_building_permit_163, t1.is_serviced AS is_serviced_164, t1.is_divisible AS is_divisible_165, t1.is_servitude AS is_servitude_166, t1.is_swimming_pool_compliant AS is_swimming_pool_compliant_167, t1.is_pmr_compliant AS is_pmr_compliant_168, t1.is_wall_for_sales AS is_wall_for_sales_169, t1.is_tenant_priority AS is_tenant_priority_170, t1.is_rented AS is_rented_171, t1.is_rented_after_sale AS is_rented_after_sale_172, t1.is_well_furnished AS is_well_furnished_173, t1.is_mortgage_registration AS is_mortgage_registration_174, t1.is_collective_ownership AS is_collective_ownership_175, t1.nb_collective_units AS nb_collective_units_176, t1.collective_manager AS collective_manager_177, t1.is_ownership_procedures AS is_ownership_procedures_178, t1.sanitation AS sanitation_179, t1.sanitation_status AS sanitation_status_180, t1.connections_detail AS connections_detail_181, t1.demarcation AS demarcation_182, t1.border AS border_183, t1.border_options AS border_options_184, t1.heater_type AS heater_type_185, t1.heater_cost AS heater_cost_186, t1.heater_nature AS heater_nature_187, t1.heater_detail AS heater_detail_188, t1.work_to AS work_to_189, t1.close_to AS close_to_190, t1.on_the_spot AS on_the_spot_191, t1.connections AS connections_192, t1.info_land AS info_land_193, t1.info_garage AS info_garage_194, t1.info_car_park AS info_car_park_195, t1.info_exposure AS info_exposure_196, t1.info_exposure2 AS info_exposure2_197, t1.info_staff_housing AS info_staff_housing_198, t1.info_dependence AS info_dependence_199, t1.info_attic AS info_attic_200, t1.info_garden AS info_garden_201, t1.info_swimming_pool AS info_swimming_pool_202, t1.info_well AS info_well_203, t1.info_drilling AS info_drilling_204, t1.info_courtyard AS info_courtyard_205, t1.info_terrace AS info_terrace_206, t1.info_balcony AS info_balcony_207, t1.info_basement AS info_basement_208, t1.info_cellar AS info_cellar_209, t1.info_other AS info_other_210, t1.diag_eligibility AS diag_eligibility_211, t1.diag_eligibility_at AS diag_eligibility_at_212, t1.dpe AS dpe_213, t1.ges AS ges_214, t1.ces AS ces_215, t1.property_tax AS property_tax_216, t1.housing_tax AS housing_tax_217, t1.rent_charges AS rent_charges_218, t1.common_charges AS common_charges_219, t1.revenue AS revenue_220, t1.net_income AS net_income_221, t1.gross_income AS gross_income_222, t1.charges_detail AS charges_detail_223, t1.lease_type AS lease_type_224, t1.lease_term AS lease_term_225, t1.lease_end_at AS lease_end_at_226, t1.kimpli_info_id AS kimpli_info_id_227 FROM contract t0 LEFT JOIN contract_estate t1 ON t0.id = t1.id WHERE t0.status = ? AND t0.is_diffusion = ? ORDER BY t0.id DESC LIMIT 8
SELECT
t0.id AS id_2,
t0.ref_netty AS ref_netty_3,
t0.ref_contract AS ref_contract_4,
t0.ref_sage AS ref_sage_5,
t0.ref_ubiflow_promup AS ref_ubiflow_promup_6,
t0.ref_ubiflow_kimpli AS ref_ubiflow_kimpli_7,
t0.ref_bienpreter_promup AS ref_bienpreter_promup_8,
t0.ref_bienpreter_kimpli AS ref_bienpreter_kimpli_9,
t0.ref_bienpreter_kimpli_invest AS ref_bienpreter_kimpli_invest_10,
t0.designation AS designation_11,
t0.title AS title_12,
t0.summary AS summary_13,
t0.description AS description_14,
t0.price AS price_15,
t0.loc_lat AS loc_lat_16,
t0.loc_lng AS loc_lng_17,
t0.remarks AS remarks_18,
t0.primary_info AS primary_info_19,
t0.statistics AS statistics_20,
t0.notary_name AS notary_name_21,
t0.notary_info AS notary_info_22,
t0.notary_email AS notary_email_23,
t0.links AS links_24,
t0.package_price AS package_price_25,
t0.is_package_price_edited AS is_package_price_edited_26,
t0.is_diffusion AS is_diffusion_27,
t0.startup_delay AS startup_delay_28,
t0.start_selling_at AS start_selling_at_29,
t0.start_price AS start_price_30,
t0.start_price_now AS start_price_now_31,
t0.start_estimated_by AS start_estimated_by_32,
t0.start_has_compromise AS start_has_compromise_33,
t0.start_is_agency AS start_is_agency_34,
t0.start_agency_type AS start_agency_type_35,
t0.start_nb_agency AS start_nb_agency_36,
t0.available_at AS available_at_37,
t0.start_nb_appointments AS start_nb_appointments_38,
t0.start_selling_delay AS start_selling_delay_39,
t0.start_selling_reason AS start_selling_reason_40,
t0.nb_views AS nb_views_41,
t0.nb_demands AS nb_demands_42,
t0.nb_appointments AS nb_appointments_43,
t0.nb_offers AS nb_offers_44,
t0.status AS status_45,
t0.archived AS archived_46,
t0.bp_status_promup AS bp_status_promup_47,
t0.bp_status_kimpli AS bp_status_kimpli_48,
t0.bp_status_kimpli_invest AS bp_status_kimpli_invest_49,
t0.bp_first_funded_at_promup AS bp_first_funded_at_promup_50,
t0.bp_first_funded_at_kimpli AS bp_first_funded_at_kimpli_51,
t0.bp_first_funded_at_kimpli_invest AS bp_first_funded_at_kimpli_invest_52,
t0.is_writing_asked AS is_writing_asked_53,
t0.is_writing_featured AS is_writing_featured_54,
t0.writing_validation AS writing_validation_55,
t0.retractation_choice AS retractation_choice_56,
t0.presta_info AS presta_info_57,
t0.presta_step AS presta_step_58,
t0.status_reason AS status_reason_59,
t0.is_pre_litigation AS is_pre_litigation_60,
t0.litigation_reason AS litigation_reason_61,
t0.is_customer_validated AS is_customer_validated_62,
t0.is_payable AS is_payable_63,
t0.is_compromise_offer AS is_compromise_offer_64,
t0.is_compromise AS is_compromise_65,
t0.is_photographer_cancelled AS is_photographer_cancelled_66,
t0.is_photographer_confirmed AS is_photographer_confirmed_67,
t0.is_photographer_validated AS is_photographer_validated_68,
t0.is_snapshots_needed AS is_snapshots_needed_69,
t0.is_sold_by_promup AS is_sold_by_promup_70,
t0.is_payment_by_notary AS is_payment_by_notary_71,
t0.is_multiple_payments AS is_multiple_payments_72,
t0.filename AS filename_73,
t0.photograph_brief AS photograph_brief_74,
t0.url_video AS url_video_75,
t0.url_video_youtube_id AS url_video_youtube_id_76,
t0.url_video_360 AS url_video_360_77,
t0.comment AS comment_78,
t0.phone AS phone_79,
t0.contract_nb_signatures AS contract_nb_signatures_80,
t0.contract_guarantor AS contract_guarantor_81,
t0.contract_proxy AS contract_proxy_82,
t0.contract_signed_where AS contract_signed_where_83,
t0.logs AS logs_84,
t0.created_at AS created_at_85,
t0.updated_at AS updated_at_86,
t0.writer_validated_at AS writer_validated_at_87,
t0.contract_signed_at AS contract_signed_at_88,
t0.contract_validated_at AS contract_validated_at_89,
t0.compromise_signed_at AS compromise_signed_at_90,
t0.authentic_act_signed_at AS authentic_act_signed_at_91,
t0.notary_last_call AS notary_last_call_92,
t0.notary1_sent_at AS notary1_sent_at_93,
t0.notary2_sent_at AS notary2_sent_at_94,
t0.notary_paid_writing_at AS notary_paid_writing_at_95,
t0.pictured_at AS pictured_at_96,
t0.bat_sent_at AS bat_sent_at_97,
t0.bat_validated_at AS bat_validated_at_98,
t0.litigation_started_at AS litigation_started_at_99,
t0.litigation_ended_at AS litigation_ended_at_100,
t0.rar1_sent_at AS rar1_sent_at_101,
t0.rar1_received_at AS rar1_received_at_102,
t0.rar2_sent_at AS rar2_sent_at_103,
t0.rar2_received_at AS rar2_received_at_104,
t0.rar3_sent_at AS rar3_sent_at_105,
t0.rar3_received_at AS rar3_received_at_106,
t0.last_writing_at AS last_writing_at_107,
t0.contract_received_at AS contract_received_at_108,
t0.open_at AS open_at_109,
t0.customer_id AS customer_id_110,
t0.user_consulting_id AS user_consulting_id_111,
t0.user_telemarketing_id AS user_telemarketing_id_112,
t0.user_photographer_id AS user_photographer_id_113,
t0.user_writer_id AS user_writer_id_114,
t0.user_bienpreter_id AS user_bienpreter_id_115,
t0.department_id AS department_id_116,
t0.address_id AS address_id_117,
t0.compromise_appointment_id AS compromise_appointment_id_118,
t0.promup_info_id AS promup_info_id_119,
t0.notary_address_id AS notary_address_id_120,
t0.open_by AS open_by_121,
t0.type,
t1.estate_detail AS estate_detail_122,
t1.opening_time AS opening_time_123,
t1.category AS category_124,
t1.category_precision AS category_precision_125,
t1.business_name AS business_name_126,
t1.business_activity AS business_activity_127,
t1.ref_cadastral AS ref_cadastral_128,
t1.material AS material_129,
t1.roofing AS roofing_130,
t1.carpentry AS carpentry_131,
t1.glazing AS glazing_132,
t1.environment AS environment_133,
t1.`view` AS view_134,
t1.kitchen_equipment AS kitchen_equipment_135,
t1.kitchen_style AS kitchen_style_136,
t1.kitchen_detail AS kitchen_detail_137,
t1.neighbors_distance AS neighbors_distance_138,
t1.construction_year AS construction_year_139,
t1.renovation_year AS renovation_year_140,
t1.land_space AS land_space_141,
t1.living_space AS living_space_142,
t1.floor_space AS floor_space_143,
t1.detail_space AS detail_space_144,
t1.detail_building_permit AS detail_building_permit_145,
t1.global_condition AS global_condition_146,
t1.interior_condition AS interior_condition_147,
t1.exterior_condition AS exterior_condition_148,
t1.roofing_condition AS roofing_condition_149,
t1.common_condition AS common_condition_150,
t1.joint_ownership AS joint_ownership_151,
t1.nb_floors AS nb_floors_152,
t1.nb_apartments AS nb_apartments_153,
t1.nb_rooms AS nb_rooms_154,
t1.nb_bed_rooms AS nb_bed_rooms_155,
t1.nb_bath_rooms AS nb_bath_rooms_156,
t1.nb_shower_rooms AS nb_shower_rooms_157,
t1.nb_toilet_rooms AS nb_toilet_rooms_158,
t1.appartment_options AS appartment_options_159,
t1.gate AS gate_160,
t1.gate_options AS gate_options_161,
t1.is_buildable AS is_buildable_162,
t1.is_building_permit AS is_building_permit_163,
t1.is_serviced AS is_serviced_164,
t1.is_divisible AS is_divisible_165,
t1.is_servitude AS is_servitude_166,
t1.is_swimming_pool_compliant AS is_swimming_pool_compliant_167,
t1.is_pmr_compliant AS is_pmr_compliant_168,
t1.is_wall_for_sales AS is_wall_for_sales_169,
t1.is_tenant_priority AS is_tenant_priority_170,
t1.is_rented AS is_rented_171,
t1.is_rented_after_sale AS is_rented_after_sale_172,
t1.is_well_furnished AS is_well_furnished_173,
t1.is_mortgage_registration AS is_mortgage_registration_174,
t1.is_collective_ownership AS is_collective_ownership_175,
t1.nb_collective_units AS nb_collective_units_176,
t1.collective_manager AS collective_manager_177,
t1.is_ownership_procedures AS is_ownership_procedures_178,
t1.sanitation AS sanitation_179,
t1.sanitation_status AS sanitation_status_180,
t1.connections_detail AS connections_detail_181,
t1.demarcation AS demarcation_182,
t1.border AS border_183,
t1.border_options AS border_options_184,
t1.heater_type AS heater_type_185,
t1.heater_cost AS heater_cost_186,
t1.heater_nature AS heater_nature_187,
t1.heater_detail AS heater_detail_188,
t1.work_to AS work_to_189,
t1.close_to AS close_to_190,
t1.on_the_spot AS on_the_spot_191,
t1.connections AS connections_192,
t1.info_land AS info_land_193,
t1.info_garage AS info_garage_194,
t1.info_car_park AS info_car_park_195,
t1.info_exposure AS info_exposure_196,
t1.info_exposure2 AS info_exposure2_197,
t1.info_staff_housing AS info_staff_housing_198,
t1.info_dependence AS info_dependence_199,
t1.info_attic AS info_attic_200,
t1.info_garden AS info_garden_201,
t1.info_swimming_pool AS info_swimming_pool_202,
t1.info_well AS info_well_203,
t1.info_drilling AS info_drilling_204,
t1.info_courtyard AS info_courtyard_205,
t1.info_terrace AS info_terrace_206,
t1.info_balcony AS info_balcony_207,
t1.info_basement AS info_basement_208,
t1.info_cellar AS info_cellar_209,
t1.info_other AS info_other_210,
t1.diag_eligibility AS diag_eligibility_211,
t1.diag_eligibility_at AS diag_eligibility_at_212,
t1.dpe AS dpe_213,
t1.ges AS ges_214,
t1.ces AS ces_215,
t1.property_tax AS property_tax_216,
t1.housing_tax AS housing_tax_217,
t1.rent_charges AS rent_charges_218,
t1.common_charges AS common_charges_219,
t1.revenue AS revenue_220,
t1.net_income AS net_income_221,
t1.gross_income AS gross_income_222,
t1.charges_detail AS charges_detail_223,
t1.lease_type AS lease_type_224,
t1.lease_term AS lease_term_225,
t1.lease_end_at AS lease_end_at_226,
t1.kimpli_info_id AS kimpli_info_id_227
FROM
contract t0
LEFT JOIN contract_estate t1 ON t0.id = t1.id
WHERE
t0.status = ?
AND t0.is_diffusion = ?
ORDER BY
t0.id DESC
LIMIT
8
SELECT t0.id AS id_2, t0.ref_netty AS ref_netty_3, t0.ref_contract AS ref_contract_4, t0.ref_sage AS ref_sage_5, t0.ref_ubiflow_promup AS ref_ubiflow_promup_6, t0.ref_ubiflow_kimpli AS ref_ubiflow_kimpli_7, t0.ref_bienpreter_promup AS ref_bienpreter_promup_8, t0.ref_bienpreter_kimpli AS ref_bienpreter_kimpli_9, t0.ref_bienpreter_kimpli_invest AS ref_bienpreter_kimpli_invest_10, t0.designation AS designation_11, t0.title AS title_12, t0.summary AS summary_13, t0.description AS description_14, t0.price AS price_15, t0.loc_lat AS loc_lat_16, t0.loc_lng AS loc_lng_17, t0.remarks AS remarks_18, t0.primary_info AS primary_info_19, t0.statistics AS statistics_20, t0.notary_name AS notary_name_21, t0.notary_info AS notary_info_22, t0.notary_email AS notary_email_23, t0.links AS links_24, t0.package_price AS package_price_25, t0.is_package_price_edited AS is_package_price_edited_26, t0.is_diffusion AS is_diffusion_27, t0.startup_delay AS startup_delay_28, t0.start_selling_at AS start_selling_at_29, t0.start_price AS start_price_30, t0.start_price_now AS start_price_now_31, t0.start_estimated_by AS start_estimated_by_32, t0.start_has_compromise AS start_has_compromise_33, t0.start_is_agency AS start_is_agency_34, t0.start_agency_type AS start_agency_type_35, t0.start_nb_agency AS start_nb_agency_36, t0.available_at AS available_at_37, t0.start_nb_appointments AS start_nb_appointments_38, t0.start_selling_delay AS start_selling_delay_39, t0.start_selling_reason AS start_selling_reason_40, t0.nb_views AS nb_views_41, t0.nb_demands AS nb_demands_42, t0.nb_appointments AS nb_appointments_43, t0.nb_offers AS nb_offers_44, t0.status AS status_45, t0.archived AS archived_46, t0.bp_status_promup AS bp_status_promup_47, t0.bp_status_kimpli AS bp_status_kimpli_48, t0.bp_status_kimpli_invest AS bp_status_kimpli_invest_49, t0.bp_first_funded_at_promup AS bp_first_funded_at_promup_50, t0.bp_first_funded_at_kimpli AS bp_first_funded_at_kimpli_51, t0.bp_first_funded_at_kimpli_invest AS bp_first_funded_at_kimpli_invest_52, t0.is_writing_asked AS is_writing_asked_53, t0.is_writing_featured AS is_writing_featured_54, t0.writing_validation AS writing_validation_55, t0.retractation_choice AS retractation_choice_56, t0.presta_info AS presta_info_57, t0.presta_step AS presta_step_58, t0.status_reason AS status_reason_59, t0.is_pre_litigation AS is_pre_litigation_60, t0.litigation_reason AS litigation_reason_61, t0.is_customer_validated AS is_customer_validated_62, t0.is_payable AS is_payable_63, t0.is_compromise_offer AS is_compromise_offer_64, t0.is_compromise AS is_compromise_65, t0.is_photographer_cancelled AS is_photographer_cancelled_66, t0.is_photographer_confirmed AS is_photographer_confirmed_67, t0.is_photographer_validated AS is_photographer_validated_68, t0.is_snapshots_needed AS is_snapshots_needed_69, t0.is_sold_by_promup AS is_sold_by_promup_70, t0.is_payment_by_notary AS is_payment_by_notary_71, t0.is_multiple_payments AS is_multiple_payments_72, t0.filename AS filename_73, t0.photograph_brief AS photograph_brief_74, t0.url_video AS url_video_75, t0.url_video_youtube_id AS url_video_youtube_id_76, t0.url_video_360 AS url_video_360_77, t0.comment AS comment_78, t0.phone AS phone_79, t0.contract_nb_signatures AS contract_nb_signatures_80, t0.contract_guarantor AS contract_guarantor_81, t0.contract_proxy AS contract_proxy_82, t0.contract_signed_where AS contract_signed_where_83, t0.logs AS logs_84, t0.created_at AS created_at_85, t0.updated_at AS updated_at_86, t0.writer_validated_at AS writer_validated_at_87, t0.contract_signed_at AS contract_signed_at_88, t0.contract_validated_at AS contract_validated_at_89, t0.compromise_signed_at AS compromise_signed_at_90, t0.authentic_act_signed_at AS authentic_act_signed_at_91, t0.notary_last_call AS notary_last_call_92, t0.notary1_sent_at AS notary1_sent_at_93, t0.notary2_sent_at AS notary2_sent_at_94, t0.notary_paid_writing_at AS notary_paid_writing_at_95, t0.pictured_at AS pictured_at_96, t0.bat_sent_at AS bat_sent_at_97, t0.bat_validated_at AS bat_validated_at_98, t0.litigation_started_at AS litigation_started_at_99, t0.litigation_ended_at AS litigation_ended_at_100, t0.rar1_sent_at AS rar1_sent_at_101, t0.rar1_received_at AS rar1_received_at_102, t0.rar2_sent_at AS rar2_sent_at_103, t0.rar2_received_at AS rar2_received_at_104, t0.rar3_sent_at AS rar3_sent_at_105, t0.rar3_received_at AS rar3_received_at_106, t0.last_writing_at AS last_writing_at_107, t0.contract_received_at AS contract_received_at_108, t0.open_at AS open_at_109, t0.customer_id AS customer_id_110, t0.user_consulting_id AS user_consulting_id_111, t0.user_telemarketing_id AS user_telemarketing_id_112, t0.user_photographer_id AS user_photographer_id_113, t0.user_writer_id AS user_writer_id_114, t0.user_bienpreter_id AS user_bienpreter_id_115, t0.department_id AS department_id_116, t0.address_id AS address_id_117, t0.compromise_appointment_id AS compromise_appointment_id_118, t0.promup_info_id AS promup_info_id_119, t0.notary_address_id AS notary_address_id_120, t0.open_by AS open_by_121, t0.type, t1.estate_detail AS estate_detail_122, t1.opening_time AS opening_time_123, t1.category AS category_124, t1.category_precision AS category_precision_125, t1.business_name AS business_name_126, t1.business_activity AS business_activity_127, t1.ref_cadastral AS ref_cadastral_128, t1.material AS material_129, t1.roofing AS roofing_130, t1.carpentry AS carpentry_131, t1.glazing AS glazing_132, t1.environment AS environment_133, t1.`view` AS view_134, t1.kitchen_equipment AS kitchen_equipment_135, t1.kitchen_style AS kitchen_style_136, t1.kitchen_detail AS kitchen_detail_137, t1.neighbors_distance AS neighbors_distance_138, t1.construction_year AS construction_year_139, t1.renovation_year AS renovation_year_140, t1.land_space AS land_space_141, t1.living_space AS living_space_142, t1.floor_space AS floor_space_143, t1.detail_space AS detail_space_144, t1.detail_building_permit AS detail_building_permit_145, t1.global_condition AS global_condition_146, t1.interior_condition AS interior_condition_147, t1.exterior_condition AS exterior_condition_148, t1.roofing_condition AS roofing_condition_149, t1.common_condition AS common_condition_150, t1.joint_ownership AS joint_ownership_151, t1.nb_floors AS nb_floors_152, t1.nb_apartments AS nb_apartments_153, t1.nb_rooms AS nb_rooms_154, t1.nb_bed_rooms AS nb_bed_rooms_155, t1.nb_bath_rooms AS nb_bath_rooms_156, t1.nb_shower_rooms AS nb_shower_rooms_157, t1.nb_toilet_rooms AS nb_toilet_rooms_158, t1.appartment_options AS appartment_options_159, t1.gate AS gate_160, t1.gate_options AS gate_options_161, t1.is_buildable AS is_buildable_162, t1.is_building_permit AS is_building_permit_163, t1.is_serviced AS is_serviced_164, t1.is_divisible AS is_divisible_165, t1.is_servitude AS is_servitude_166, t1.is_swimming_pool_compliant AS is_swimming_pool_compliant_167, t1.is_pmr_compliant AS is_pmr_compliant_168, t1.is_wall_for_sales AS is_wall_for_sales_169, t1.is_tenant_priority AS is_tenant_priority_170, t1.is_rented AS is_rented_171, t1.is_rented_after_sale AS is_rented_after_sale_172, t1.is_well_furnished AS is_well_furnished_173, t1.is_mortgage_registration AS is_mortgage_registration_174, t1.is_collective_ownership AS is_collective_ownership_175, t1.nb_collective_units AS nb_collective_units_176, t1.collective_manager AS collective_manager_177, t1.is_ownership_procedures AS is_ownership_procedures_178, t1.sanitation AS sanitation_179, t1.sanitation_status AS sanitation_status_180, t1.connections_detail AS connections_detail_181, t1.demarcation AS demarcation_182, t1.border AS border_183, t1.border_options AS border_options_184, t1.heater_type AS heater_type_185, t1.heater_cost AS heater_cost_186, t1.heater_nature AS heater_nature_187, t1.heater_detail AS heater_detail_188, t1.work_to AS work_to_189, t1.close_to AS close_to_190, t1.on_the_spot AS on_the_spot_191, t1.connections AS connections_192, t1.info_land AS info_land_193, t1.info_garage AS info_garage_194, t1.info_car_park AS info_car_park_195, t1.info_exposure AS info_exposure_196, t1.info_exposure2 AS info_exposure2_197, t1.info_staff_housing AS info_staff_housing_198, t1.info_dependence AS info_dependence_199, t1.info_attic AS info_attic_200, t1.info_garden AS info_garden_201, t1.info_swimming_pool AS info_swimming_pool_202, t1.info_well AS info_well_203, t1.info_drilling AS info_drilling_204, t1.info_courtyard AS info_courtyard_205, t1.info_terrace AS info_terrace_206, t1.info_balcony AS info_balcony_207, t1.info_basement AS info_basement_208, t1.info_cellar AS info_cellar_209, t1.info_other AS info_other_210, t1.diag_eligibility AS diag_eligibility_211, t1.diag_eligibility_at AS diag_eligibility_at_212, t1.dpe AS dpe_213, t1.ges AS ges_214, t1.ces AS ces_215, t1.property_tax AS property_tax_216, t1.housing_tax AS housing_tax_217, t1.rent_charges AS rent_charges_218, t1.common_charges AS common_charges_219, t1.revenue AS revenue_220, t1.net_income AS net_income_221, t1.gross_income AS gross_income_222, t1.charges_detail AS charges_detail_223, t1.lease_type AS lease_type_224, t1.lease_term AS lease_term_225, t1.lease_end_at AS lease_end_at_226, t1.kimpli_info_id AS kimpli_info_id_227 FROM contract t0 LEFT JOIN contract_estate t1 ON t0.id = t1.id WHERE t0.status = 5 AND t0.is_diffusion = 1 ORDER BY t0.id DESC LIMIT 8;
|