1.49 ms
(0.50%)
|
1 |
SELECT t0.id AS id_1, t0.street AS street_2, t0.street_door AS street_door_3, t0.zip_code_id AS zip_code_id_4, t0.city_id AS city_id_5, t0.zip_code_city_id AS zip_code_city_id_6, t7.id AS id_8, t7.revision AS revision_9, t7.public_id AS public_id_10, t7.offer_type AS offer_type_11, t7.sell_price AS sell_price_12, t7.rent_price AS rent_price_13, t7.publishing_status AS publishing_status_14, t7.apartments_count AS apartments_count_15, t7.rooms_count AS rooms_count_16, t7.bathrooms_count AS bathrooms_count_17, t7.floor AS floor_18, t7.floors_count AS floors_count_19, t7.living_area AS living_area_20, t7.land_area AS land_area_21, t7.usable_area AS usable_area_22, t7.ceiling_height AS ceiling_height_23, t7.year_built AS year_built_24, t7.last_renovation AS last_renovation_25, t7.calendly_url AS calendly_url_26, t7.tour_first_date_delay AS tour_first_date_delay_27, t7.tour_week_days AS tour_week_days_28, t7.waiting_list_active AS waiting_list_active_29, t7.favourite_richard AS favourite_richard_30, t7.location_optimiser_active AS location_optimiser_active_31, t7.video AS video_32, t7.video2 AS video2_33, t7.virtual_tour AS virtual_tour_34, t7.title AS title_35, t7.description_results AS description_results_36, t7.description_detail_view AS description_detail_view_37, t7.benefits AS benefits_38, t7.description_external_portals AS description_external_portals_39, t7.property_id AS property_id_40, t7.wordpress_export_active AS wordpress_export_active_41, t7.wordpress_exported_revision AS wordpress_exported_revision_42, t7.wordpress_page_url AS wordpress_page_url_43, t7.wordpress_post_id AS wordpress_post_id_44, t7.main_language AS main_language_45, t7.draft_at AS draft_at_46, t7.paused_at AS paused_at_47, t7.archived_at AS archived_at_48, t7.on_air_at AS on_air_at_49, t7.reserved_at AS reserved_at_50, t7.sold_or_rented_at AS sold_or_rented_at_51, t7.automatic_translation_disabled AS automatic_translation_disabled_52, t7.automatic_translated AS automatic_translated_53, t7.publish_full_address AS publish_full_address_54, t7.first_published_at AS first_published_at_55, t7.edit_lock_until AS edit_lock_until_56, t7.forced_publishing_phases AS forced_publishing_phases_57, t7.disallowed_publishing_phases AS disallowed_publishing_phases_58, t7.media_url_original_images AS media_url_original_images_59, t7.media_url_web_images AS media_url_web_images_60, t7.media_url_floor_plans AS media_url_floor_plans_61, t7.media_upload_status AS media_upload_status_62, t7.additional_publishing_delays AS additional_publishing_delays_63, t7.created_at AS created_at_64, t7.updated_at AS updated_at_65, t7.category_id AS category_id_66, t7.object_type_id AS object_type_id_67, t7.agent_id AS agent_id_68, t7.address_id AS address_id_69, t7.cloned_from_id AS cloned_from_id_70, t7.edit_lock_by_user_id AS edit_lock_by_user_id_71, t7.mandate_id AS mandate_id_72, t73.id AS id_74, t73.sent_at AS sent_at_75, t73.offer_type AS offer_type_76, t73.price AS price_77, t73.public_id AS public_id_78, t73.rooms_count AS rooms_count_79, t73.living_area AS living_area_80, t73.land_area AS land_area_81, t73.usable_area AS usable_area_82, t73.commercial_area AS commercial_area_83, t73.commercial_usable_area AS commercial_usable_area_84, t73.gross_area AS gross_area_85, t73.floor AS floor_86, t73.floors_count AS floors_count_87, t73.ceiling_height AS ceiling_height_88, t73.year_built AS year_built_89, t73.property_number_whole_house AS property_number_whole_house_90, t73.property_number_apartment AS property_number_apartment_91, t73.value_ratio AS value_ratio_92, t73.building_zone AS building_zone_93, t73.property_number_land AS property_number_land_94, t73.total_land_area AS total_land_area_95, t73.individual_land_areas AS individual_land_areas_96, t73.deposit AS deposit_97, t73.status_fund AS status_fund_98, t73.share AS share_99, t73.renovation_information_as_of_date AS renovation_information_as_of_date_100, t73.operating_expenses AS operating_expenses_101, t73.operating_expenses_information_as_of_date AS operating_expenses_information_as_of_date_102, t73.debt_certificates AS debt_certificates_103, t73.tax_value AS tax_value_104, t73.imputed_rental_value AS imputed_rental_value_105, t73.transfer_tax_first_level AS transfer_tax_first_level_106, t73.has_transfer_tax_second_level AS has_transfer_tax_second_level_107, t73.transfer_tax_second_level AS transfer_tax_second_level_108, t73.notary_and_registry AS notary_and_registry_109, t73.commission_purchase_price AS commission_purchase_price_110, t73.commission_purchase_price_responsibility AS commission_purchase_price_responsibility_111, t73.transaction_price_minimum AS transaction_price_minimum_112, t73.transaction_price_minimum_responsibility AS transaction_price_minimum_responsibility_113, t73.no_parking_available AS no_parking_available_114, t73.parking_facilities AS parking_facilities_115, t73.parking_facilities_counts AS parking_facilities_counts_116, t73.parking_included_in_price AS parking_included_in_price_117, t73.parking_price AS parking_price_118, t73.no_wet_rooms AS no_wet_rooms_119, t73.wet_rooms AS wet_rooms_120, t73.wet_rooms_counts AS wet_rooms_counts_121, t73.no_heating_system AS no_heating_system_122, t73.heating_systems AS heating_systems_123, t73.heating_systems_wood AS heating_systems_wood_124, t73.heating_systems_heat_pump AS heating_systems_heat_pump_125, t73.heating_systems_solar AS heating_systems_solar_126, t73.heating_systems_electric AS heating_systems_electric_127, t73.unknown_heat_distribution_system AS unknown_heat_distribution_system_128, t73.heat_distribution_systems AS heat_distribution_systems_129, t73.unknown_floor_coverings AS unknown_floor_coverings_130, t73.floor_coverings AS floor_coverings_131, t73.floor_coverings_parquet AS floor_coverings_parquet_132, t73.floor_coverings_stone AS floor_coverings_stone_133, t73.no_adjacent_rooms AS no_adjacent_rooms_134, t73.adjacent_rooms AS adjacent_rooms_135, t73.craft_room_heating AS craft_room_heating_136, t73.craft_room_ownership AS craft_room_ownership_137, t73.workshop_heating AS workshop_heating_138, t73.workshop_ownership AS workshop_ownership_139, t73.party_room_heating AS party_room_heating_140, t73.party_room_ownership AS party_room_ownership_141, t73.cellar_heating AS cellar_heating_142, t73.cellar_ownership AS cellar_ownership_143, t73.winter_garden_heating AS winter_garden_heating_144, t73.special_features AS special_features_145, t73.special_features_areas AS special_features_areas_146, t73.recordings_needed AS recordings_needed_147, t73.target_demographics AS target_demographics_148, t73.residence AS residence_149, t73.protected_site AS protected_site_150, t73.subject_to_building_regulations AS subject_to_building_regulations_151, t73.building_rights_holder AS building_rights_holder_152, t73.building_rights_end_main_building_only AS building_rights_end_main_building_only_153, t73.building_rights_end AS building_rights_end_154, t73.building_rights_interest AS building_rights_interest_155, t73.recordings_special_instructions AS recordings_special_instructions_156, t73.notes_for_contacts AS notes_for_contacts_157, t73.status AS status_158, t73.kick_off_meeting_necessary AS kick_off_meeting_necessary_159, t73.power_of_attorney_and_brokerage_filled AS power_of_attorney_and_brokerage_filled_160, t73.photo_assignment_email_sent AS photo_assignment_email_sent_161, t73.kickoff_meeting_email_sent AS kickoff_meeting_email_sent_162, t73.agent_recommendation_result AS agent_recommendation_result_163, t73.layout AS layout_164, t73.created_at AS created_at_165, t73.updated_at AS updated_at_166, t73.evaluator_id AS evaluator_id_167, t73.creator_id AS creator_id_168, t73.category_id AS category_id_169, t73.object_type_id AS object_type_id_170, t73.address_id AS address_id_171, t73.agent_recommended_id AS agent_recommended_id_172 FROM address t0 LEFT JOIN property t7 ON t7.address_id = t0.id LEFT JOIN mandate t73 ON t73.address_id = t0.id WHERE t0.id = ?
SELECT
t0.id AS id_1,
t0.street AS street_2,
t0.street_door AS street_door_3,
t0.zip_code_id AS zip_code_id_4,
t0.city_id AS city_id_5,
t0.zip_code_city_id AS zip_code_city_id_6,
t7.id AS id_8,
t7.revision AS revision_9,
t7.public_id AS public_id_10,
t7.offer_type AS offer_type_11,
t7.sell_price AS sell_price_12,
t7.rent_price AS rent_price_13,
t7.publishing_status AS publishing_status_14,
t7.apartments_count AS apartments_count_15,
t7.rooms_count AS rooms_count_16,
t7.bathrooms_count AS bathrooms_count_17,
t7.floor AS floor_18,
t7.floors_count AS floors_count_19,
t7.living_area AS living_area_20,
t7.land_area AS land_area_21,
t7.usable_area AS usable_area_22,
t7.ceiling_height AS ceiling_height_23,
t7.year_built AS year_built_24,
t7.last_renovation AS last_renovation_25,
t7.calendly_url AS calendly_url_26,
t7.tour_first_date_delay AS tour_first_date_delay_27,
t7.tour_week_days AS tour_week_days_28,
t7.waiting_list_active AS waiting_list_active_29,
t7.favourite_richard AS favourite_richard_30,
t7.location_optimiser_active AS location_optimiser_active_31,
t7.video AS video_32,
t7.video2 AS video2_33,
t7.virtual_tour AS virtual_tour_34,
t7.title AS title_35,
t7.description_results AS description_results_36,
t7.description_detail_view AS description_detail_view_37,
t7.benefits AS benefits_38,
t7.description_external_portals AS description_external_portals_39,
t7.property_id AS property_id_40,
t7.wordpress_export_active AS wordpress_export_active_41,
t7.wordpress_exported_revision AS wordpress_exported_revision_42,
t7.wordpress_page_url AS wordpress_page_url_43,
t7.wordpress_post_id AS wordpress_post_id_44,
t7.main_language AS main_language_45,
t7.draft_at AS draft_at_46,
t7.paused_at AS paused_at_47,
t7.archived_at AS archived_at_48,
t7.on_air_at AS on_air_at_49,
t7.reserved_at AS reserved_at_50,
t7.sold_or_rented_at AS sold_or_rented_at_51,
t7.automatic_translation_disabled AS automatic_translation_disabled_52,
t7.automatic_translated AS automatic_translated_53,
t7.publish_full_address AS publish_full_address_54,
t7.first_published_at AS first_published_at_55,
t7.edit_lock_until AS edit_lock_until_56,
t7.forced_publishing_phases AS forced_publishing_phases_57,
t7.disallowed_publishing_phases AS disallowed_publishing_phases_58,
t7.media_url_original_images AS media_url_original_images_59,
t7.media_url_web_images AS media_url_web_images_60,
t7.media_url_floor_plans AS media_url_floor_plans_61,
t7.media_upload_status AS media_upload_status_62,
t7.additional_publishing_delays AS additional_publishing_delays_63,
t7.created_at AS created_at_64,
t7.updated_at AS updated_at_65,
t7.category_id AS category_id_66,
t7.object_type_id AS object_type_id_67,
t7.agent_id AS agent_id_68,
t7.address_id AS address_id_69,
t7.cloned_from_id AS cloned_from_id_70,
t7.edit_lock_by_user_id AS edit_lock_by_user_id_71,
t7.mandate_id AS mandate_id_72,
t73.id AS id_74,
t73.sent_at AS sent_at_75,
t73.offer_type AS offer_type_76,
t73.price AS price_77,
t73.public_id AS public_id_78,
t73.rooms_count AS rooms_count_79,
t73.living_area AS living_area_80,
t73.land_area AS land_area_81,
t73.usable_area AS usable_area_82,
t73.commercial_area AS commercial_area_83,
t73.commercial_usable_area AS commercial_usable_area_84,
t73.gross_area AS gross_area_85,
t73.floor AS floor_86,
t73.floors_count AS floors_count_87,
t73.ceiling_height AS ceiling_height_88,
t73.year_built AS year_built_89,
t73.property_number_whole_house AS property_number_whole_house_90,
t73.property_number_apartment AS property_number_apartment_91,
t73.value_ratio AS value_ratio_92,
t73.building_zone AS building_zone_93,
t73.property_number_land AS property_number_land_94,
t73.total_land_area AS total_land_area_95,
t73.individual_land_areas AS individual_land_areas_96,
t73.deposit AS deposit_97,
t73.status_fund AS status_fund_98,
t73.share AS share_99,
t73.renovation_information_as_of_date AS renovation_information_as_of_date_100,
t73.operating_expenses AS operating_expenses_101,
t73.operating_expenses_information_as_of_date AS operating_expenses_information_as_of_date_102,
t73.debt_certificates AS debt_certificates_103,
t73.tax_value AS tax_value_104,
t73.imputed_rental_value AS imputed_rental_value_105,
t73.transfer_tax_first_level AS transfer_tax_first_level_106,
t73.has_transfer_tax_second_level AS has_transfer_tax_second_level_107,
t73.transfer_tax_second_level AS transfer_tax_second_level_108,
t73.notary_and_registry AS notary_and_registry_109,
t73.commission_purchase_price AS commission_purchase_price_110,
t73.commission_purchase_price_responsibility AS commission_purchase_price_responsibility_111,
t73.transaction_price_minimum AS transaction_price_minimum_112,
t73.transaction_price_minimum_responsibility AS transaction_price_minimum_responsibility_113,
t73.no_parking_available AS no_parking_available_114,
t73.parking_facilities AS parking_facilities_115,
t73.parking_facilities_counts AS parking_facilities_counts_116,
t73.parking_included_in_price AS parking_included_in_price_117,
t73.parking_price AS parking_price_118,
t73.no_wet_rooms AS no_wet_rooms_119,
t73.wet_rooms AS wet_rooms_120,
t73.wet_rooms_counts AS wet_rooms_counts_121,
t73.no_heating_system AS no_heating_system_122,
t73.heating_systems AS heating_systems_123,
t73.heating_systems_wood AS heating_systems_wood_124,
t73.heating_systems_heat_pump AS heating_systems_heat_pump_125,
t73.heating_systems_solar AS heating_systems_solar_126,
t73.heating_systems_electric AS heating_systems_electric_127,
t73.unknown_heat_distribution_system AS unknown_heat_distribution_system_128,
t73.heat_distribution_systems AS heat_distribution_systems_129,
t73.unknown_floor_coverings AS unknown_floor_coverings_130,
t73.floor_coverings AS floor_coverings_131,
t73.floor_coverings_parquet AS floor_coverings_parquet_132,
t73.floor_coverings_stone AS floor_coverings_stone_133,
t73.no_adjacent_rooms AS no_adjacent_rooms_134,
t73.adjacent_rooms AS adjacent_rooms_135,
t73.craft_room_heating AS craft_room_heating_136,
t73.craft_room_ownership AS craft_room_ownership_137,
t73.workshop_heating AS workshop_heating_138,
t73.workshop_ownership AS workshop_ownership_139,
t73.party_room_heating AS party_room_heating_140,
t73.party_room_ownership AS party_room_ownership_141,
t73.cellar_heating AS cellar_heating_142,
t73.cellar_ownership AS cellar_ownership_143,
t73.winter_garden_heating AS winter_garden_heating_144,
t73.special_features AS special_features_145,
t73.special_features_areas AS special_features_areas_146,
t73.recordings_needed AS recordings_needed_147,
t73.target_demographics AS target_demographics_148,
t73.residence AS residence_149,
t73.protected_site AS protected_site_150,
t73.subject_to_building_regulations AS subject_to_building_regulations_151,
t73.building_rights_holder AS building_rights_holder_152,
t73.building_rights_end_main_building_only AS building_rights_end_main_building_only_153,
t73.building_rights_end AS building_rights_end_154,
t73.building_rights_interest AS building_rights_interest_155,
t73.recordings_special_instructions AS recordings_special_instructions_156,
t73.notes_for_contacts AS notes_for_contacts_157,
t73.status AS status_158,
t73.kick_off_meeting_necessary AS kick_off_meeting_necessary_159,
t73.power_of_attorney_and_brokerage_filled AS power_of_attorney_and_brokerage_filled_160,
t73.photo_assignment_email_sent AS photo_assignment_email_sent_161,
t73.kickoff_meeting_email_sent AS kickoff_meeting_email_sent_162,
t73.agent_recommendation_result AS agent_recommendation_result_163,
t73.layout AS layout_164,
t73.created_at AS created_at_165,
t73.updated_at AS updated_at_166,
t73.evaluator_id AS evaluator_id_167,
t73.creator_id AS creator_id_168,
t73.category_id AS category_id_169,
t73.object_type_id AS object_type_id_170,
t73.address_id AS address_id_171,
t73.agent_recommended_id AS agent_recommended_id_172
FROM
address t0
LEFT JOIN property t7 ON t7.address_id = t0.id
LEFT JOIN mandate t73 ON t73.address_id = t0.id
WHERE
t0.id = ?
SELECT t0.id AS id_1, t0.street AS street_2, t0.street_door AS street_door_3, t0.zip_code_id AS zip_code_id_4, t0.city_id AS city_id_5, t0.zip_code_city_id AS zip_code_city_id_6, t7.id AS id_8, t7.revision AS revision_9, t7.public_id AS public_id_10, t7.offer_type AS offer_type_11, t7.sell_price AS sell_price_12, t7.rent_price AS rent_price_13, t7.publishing_status AS publishing_status_14, t7.apartments_count AS apartments_count_15, t7.rooms_count AS rooms_count_16, t7.bathrooms_count AS bathrooms_count_17, t7.floor AS floor_18, t7.floors_count AS floors_count_19, t7.living_area AS living_area_20, t7.land_area AS land_area_21, t7.usable_area AS usable_area_22, t7.ceiling_height AS ceiling_height_23, t7.year_built AS year_built_24, t7.last_renovation AS last_renovation_25, t7.calendly_url AS calendly_url_26, t7.tour_first_date_delay AS tour_first_date_delay_27, t7.tour_week_days AS tour_week_days_28, t7.waiting_list_active AS waiting_list_active_29, t7.favourite_richard AS favourite_richard_30, t7.location_optimiser_active AS location_optimiser_active_31, t7.video AS video_32, t7.video2 AS video2_33, t7.virtual_tour AS virtual_tour_34, t7.title AS title_35, t7.description_results AS description_results_36, t7.description_detail_view AS description_detail_view_37, t7.benefits AS benefits_38, t7.description_external_portals AS description_external_portals_39, t7.property_id AS property_id_40, t7.wordpress_export_active AS wordpress_export_active_41, t7.wordpress_exported_revision AS wordpress_exported_revision_42, t7.wordpress_page_url AS wordpress_page_url_43, t7.wordpress_post_id AS wordpress_post_id_44, t7.main_language AS main_language_45, t7.draft_at AS draft_at_46, t7.paused_at AS paused_at_47, t7.archived_at AS archived_at_48, t7.on_air_at AS on_air_at_49, t7.reserved_at AS reserved_at_50, t7.sold_or_rented_at AS sold_or_rented_at_51, t7.automatic_translation_disabled AS automatic_translation_disabled_52, t7.automatic_translated AS automatic_translated_53, t7.publish_full_address AS publish_full_address_54, t7.first_published_at AS first_published_at_55, t7.edit_lock_until AS edit_lock_until_56, t7.forced_publishing_phases AS forced_publishing_phases_57, t7.disallowed_publishing_phases AS disallowed_publishing_phases_58, t7.media_url_original_images AS media_url_original_images_59, t7.media_url_web_images AS media_url_web_images_60, t7.media_url_floor_plans AS media_url_floor_plans_61, t7.media_upload_status AS media_upload_status_62, t7.additional_publishing_delays AS additional_publishing_delays_63, t7.created_at AS created_at_64, t7.updated_at AS updated_at_65, t7.category_id AS category_id_66, t7.object_type_id AS object_type_id_67, t7.agent_id AS agent_id_68, t7.address_id AS address_id_69, t7.cloned_from_id AS cloned_from_id_70, t7.edit_lock_by_user_id AS edit_lock_by_user_id_71, t7.mandate_id AS mandate_id_72, t73.id AS id_74, t73.sent_at AS sent_at_75, t73.offer_type AS offer_type_76, t73.price AS price_77, t73.public_id AS public_id_78, t73.rooms_count AS rooms_count_79, t73.living_area AS living_area_80, t73.land_area AS land_area_81, t73.usable_area AS usable_area_82, t73.commercial_area AS commercial_area_83, t73.commercial_usable_area AS commercial_usable_area_84, t73.gross_area AS gross_area_85, t73.floor AS floor_86, t73.floors_count AS floors_count_87, t73.ceiling_height AS ceiling_height_88, t73.year_built AS year_built_89, t73.property_number_whole_house AS property_number_whole_house_90, t73.property_number_apartment AS property_number_apartment_91, t73.value_ratio AS value_ratio_92, t73.building_zone AS building_zone_93, t73.property_number_land AS property_number_land_94, t73.total_land_area AS total_land_area_95, t73.individual_land_areas AS individual_land_areas_96, t73.deposit AS deposit_97, t73.status_fund AS status_fund_98, t73.share AS share_99, t73.renovation_information_as_of_date AS renovation_information_as_of_date_100, t73.operating_expenses AS operating_expenses_101, t73.operating_expenses_information_as_of_date AS operating_expenses_information_as_of_date_102, t73.debt_certificates AS debt_certificates_103, t73.tax_value AS tax_value_104, t73.imputed_rental_value AS imputed_rental_value_105, t73.transfer_tax_first_level AS transfer_tax_first_level_106, t73.has_transfer_tax_second_level AS has_transfer_tax_second_level_107, t73.transfer_tax_second_level AS transfer_tax_second_level_108, t73.notary_and_registry AS notary_and_registry_109, t73.commission_purchase_price AS commission_purchase_price_110, t73.commission_purchase_price_responsibility AS commission_purchase_price_responsibility_111, t73.transaction_price_minimum AS transaction_price_minimum_112, t73.transaction_price_minimum_responsibility AS transaction_price_minimum_responsibility_113, t73.no_parking_available AS no_parking_available_114, t73.parking_facilities AS parking_facilities_115, t73.parking_facilities_counts AS parking_facilities_counts_116, t73.parking_included_in_price AS parking_included_in_price_117, t73.parking_price AS parking_price_118, t73.no_wet_rooms AS no_wet_rooms_119, t73.wet_rooms AS wet_rooms_120, t73.wet_rooms_counts AS wet_rooms_counts_121, t73.no_heating_system AS no_heating_system_122, t73.heating_systems AS heating_systems_123, t73.heating_systems_wood AS heating_systems_wood_124, t73.heating_systems_heat_pump AS heating_systems_heat_pump_125, t73.heating_systems_solar AS heating_systems_solar_126, t73.heating_systems_electric AS heating_systems_electric_127, t73.unknown_heat_distribution_system AS unknown_heat_distribution_system_128, t73.heat_distribution_systems AS heat_distribution_systems_129, t73.unknown_floor_coverings AS unknown_floor_coverings_130, t73.floor_coverings AS floor_coverings_131, t73.floor_coverings_parquet AS floor_coverings_parquet_132, t73.floor_coverings_stone AS floor_coverings_stone_133, t73.no_adjacent_rooms AS no_adjacent_rooms_134, t73.adjacent_rooms AS adjacent_rooms_135, t73.craft_room_heating AS craft_room_heating_136, t73.craft_room_ownership AS craft_room_ownership_137, t73.workshop_heating AS workshop_heating_138, t73.workshop_ownership AS workshop_ownership_139, t73.party_room_heating AS party_room_heating_140, t73.party_room_ownership AS party_room_ownership_141, t73.cellar_heating AS cellar_heating_142, t73.cellar_ownership AS cellar_ownership_143, t73.winter_garden_heating AS winter_garden_heating_144, t73.special_features AS special_features_145, t73.special_features_areas AS special_features_areas_146, t73.recordings_needed AS recordings_needed_147, t73.target_demographics AS target_demographics_148, t73.residence AS residence_149, t73.protected_site AS protected_site_150, t73.subject_to_building_regulations AS subject_to_building_regulations_151, t73.building_rights_holder AS building_rights_holder_152, t73.building_rights_end_main_building_only AS building_rights_end_main_building_only_153, t73.building_rights_end AS building_rights_end_154, t73.building_rights_interest AS building_rights_interest_155, t73.recordings_special_instructions AS recordings_special_instructions_156, t73.notes_for_contacts AS notes_for_contacts_157, t73.status AS status_158, t73.kick_off_meeting_necessary AS kick_off_meeting_necessary_159, t73.power_of_attorney_and_brokerage_filled AS power_of_attorney_and_brokerage_filled_160, t73.photo_assignment_email_sent AS photo_assignment_email_sent_161, t73.kickoff_meeting_email_sent AS kickoff_meeting_email_sent_162, t73.agent_recommendation_result AS agent_recommendation_result_163, t73.layout AS layout_164, t73.created_at AS created_at_165, t73.updated_at AS updated_at_166, t73.evaluator_id AS evaluator_id_167, t73.creator_id AS creator_id_168, t73.category_id AS category_id_169, t73.object_type_id AS object_type_id_170, t73.address_id AS address_id_171, t73.agent_recommended_id AS agent_recommended_id_172 FROM address t0 LEFT JOIN property t7 ON t7.address_id = t0.id LEFT JOIN mandate t73 ON t73.address_id = t0.id WHERE t0.id = 627;
|
1.38 ms
(0.47%)
|
1 |
SELECT t0.id AS id_1, t0.revision AS revision_2, t0.public_id AS public_id_3, t0.offer_type AS offer_type_4, t0.sell_price AS sell_price_5, t0.rent_price AS rent_price_6, t0.publishing_status AS publishing_status_7, t0.apartments_count AS apartments_count_8, t0.rooms_count AS rooms_count_9, t0.bathrooms_count AS bathrooms_count_10, t0.floor AS floor_11, t0.floors_count AS floors_count_12, t0.living_area AS living_area_13, t0.land_area AS land_area_14, t0.usable_area AS usable_area_15, t0.ceiling_height AS ceiling_height_16, t0.year_built AS year_built_17, t0.last_renovation AS last_renovation_18, t0.calendly_url AS calendly_url_19, t0.tour_first_date_delay AS tour_first_date_delay_20, t0.tour_week_days AS tour_week_days_21, t0.waiting_list_active AS waiting_list_active_22, t0.favourite_richard AS favourite_richard_23, t0.location_optimiser_active AS location_optimiser_active_24, t0.video AS video_25, t0.video2 AS video2_26, t0.virtual_tour AS virtual_tour_27, t0.title AS title_28, t0.description_results AS description_results_29, t0.description_detail_view AS description_detail_view_30, t0.benefits AS benefits_31, t0.description_external_portals AS description_external_portals_32, t0.property_id AS property_id_33, t0.wordpress_export_active AS wordpress_export_active_34, t0.wordpress_exported_revision AS wordpress_exported_revision_35, t0.wordpress_page_url AS wordpress_page_url_36, t0.wordpress_post_id AS wordpress_post_id_37, t0.main_language AS main_language_38, t0.draft_at AS draft_at_39, t0.paused_at AS paused_at_40, t0.archived_at AS archived_at_41, t0.on_air_at AS on_air_at_42, t0.reserved_at AS reserved_at_43, t0.sold_or_rented_at AS sold_or_rented_at_44, t0.automatic_translation_disabled AS automatic_translation_disabled_45, t0.automatic_translated AS automatic_translated_46, t0.publish_full_address AS publish_full_address_47, t0.first_published_at AS first_published_at_48, t0.edit_lock_until AS edit_lock_until_49, t0.forced_publishing_phases AS forced_publishing_phases_50, t0.disallowed_publishing_phases AS disallowed_publishing_phases_51, t0.media_url_original_images AS media_url_original_images_52, t0.media_url_web_images AS media_url_web_images_53, t0.media_url_floor_plans AS media_url_floor_plans_54, t0.media_upload_status AS media_upload_status_55, t0.additional_publishing_delays AS additional_publishing_delays_56, t0.created_at AS created_at_57, t0.updated_at AS updated_at_58, t0.category_id AS category_id_59, t0.object_type_id AS object_type_id_60, t0.agent_id AS agent_id_61, t0.address_id AS address_id_62, t0.cloned_from_id AS cloned_from_id_63, t0.edit_lock_by_user_id AS edit_lock_by_user_id_64, t0.mandate_id AS mandate_id_65 FROM property t0 WHERE t0.id = ?
SELECT
t0.id AS id_1,
t0.revision AS revision_2,
t0.public_id AS public_id_3,
t0.offer_type AS offer_type_4,
t0.sell_price AS sell_price_5,
t0.rent_price AS rent_price_6,
t0.publishing_status AS publishing_status_7,
t0.apartments_count AS apartments_count_8,
t0.rooms_count AS rooms_count_9,
t0.bathrooms_count AS bathrooms_count_10,
t0.floor AS floor_11,
t0.floors_count AS floors_count_12,
t0.living_area AS living_area_13,
t0.land_area AS land_area_14,
t0.usable_area AS usable_area_15,
t0.ceiling_height AS ceiling_height_16,
t0.year_built AS year_built_17,
t0.last_renovation AS last_renovation_18,
t0.calendly_url AS calendly_url_19,
t0.tour_first_date_delay AS tour_first_date_delay_20,
t0.tour_week_days AS tour_week_days_21,
t0.waiting_list_active AS waiting_list_active_22,
t0.favourite_richard AS favourite_richard_23,
t0.location_optimiser_active AS location_optimiser_active_24,
t0.video AS video_25,
t0.video2 AS video2_26,
t0.virtual_tour AS virtual_tour_27,
t0.title AS title_28,
t0.description_results AS description_results_29,
t0.description_detail_view AS description_detail_view_30,
t0.benefits AS benefits_31,
t0.description_external_portals AS description_external_portals_32,
t0.property_id AS property_id_33,
t0.wordpress_export_active AS wordpress_export_active_34,
t0.wordpress_exported_revision AS wordpress_exported_revision_35,
t0.wordpress_page_url AS wordpress_page_url_36,
t0.wordpress_post_id AS wordpress_post_id_37,
t0.main_language AS main_language_38,
t0.draft_at AS draft_at_39,
t0.paused_at AS paused_at_40,
t0.archived_at AS archived_at_41,
t0.on_air_at AS on_air_at_42,
t0.reserved_at AS reserved_at_43,
t0.sold_or_rented_at AS sold_or_rented_at_44,
t0.automatic_translation_disabled AS automatic_translation_disabled_45,
t0.automatic_translated AS automatic_translated_46,
t0.publish_full_address AS publish_full_address_47,
t0.first_published_at AS first_published_at_48,
t0.edit_lock_until AS edit_lock_until_49,
t0.forced_publishing_phases AS forced_publishing_phases_50,
t0.disallowed_publishing_phases AS disallowed_publishing_phases_51,
t0.media_url_original_images AS media_url_original_images_52,
t0.media_url_web_images AS media_url_web_images_53,
t0.media_url_floor_plans AS media_url_floor_plans_54,
t0.media_upload_status AS media_upload_status_55,
t0.additional_publishing_delays AS additional_publishing_delays_56,
t0.created_at AS created_at_57,
t0.updated_at AS updated_at_58,
t0.category_id AS category_id_59,
t0.object_type_id AS object_type_id_60,
t0.agent_id AS agent_id_61,
t0.address_id AS address_id_62,
t0.cloned_from_id AS cloned_from_id_63,
t0.edit_lock_by_user_id AS edit_lock_by_user_id_64,
t0.mandate_id AS mandate_id_65
FROM
property t0
WHERE
t0.id = ?
SELECT t0.id AS id_1, t0.revision AS revision_2, t0.public_id AS public_id_3, t0.offer_type AS offer_type_4, t0.sell_price AS sell_price_5, t0.rent_price AS rent_price_6, t0.publishing_status AS publishing_status_7, t0.apartments_count AS apartments_count_8, t0.rooms_count AS rooms_count_9, t0.bathrooms_count AS bathrooms_count_10, t0.floor AS floor_11, t0.floors_count AS floors_count_12, t0.living_area AS living_area_13, t0.land_area AS land_area_14, t0.usable_area AS usable_area_15, t0.ceiling_height AS ceiling_height_16, t0.year_built AS year_built_17, t0.last_renovation AS last_renovation_18, t0.calendly_url AS calendly_url_19, t0.tour_first_date_delay AS tour_first_date_delay_20, t0.tour_week_days AS tour_week_days_21, t0.waiting_list_active AS waiting_list_active_22, t0.favourite_richard AS favourite_richard_23, t0.location_optimiser_active AS location_optimiser_active_24, t0.video AS video_25, t0.video2 AS video2_26, t0.virtual_tour AS virtual_tour_27, t0.title AS title_28, t0.description_results AS description_results_29, t0.description_detail_view AS description_detail_view_30, t0.benefits AS benefits_31, t0.description_external_portals AS description_external_portals_32, t0.property_id AS property_id_33, t0.wordpress_export_active AS wordpress_export_active_34, t0.wordpress_exported_revision AS wordpress_exported_revision_35, t0.wordpress_page_url AS wordpress_page_url_36, t0.wordpress_post_id AS wordpress_post_id_37, t0.main_language AS main_language_38, t0.draft_at AS draft_at_39, t0.paused_at AS paused_at_40, t0.archived_at AS archived_at_41, t0.on_air_at AS on_air_at_42, t0.reserved_at AS reserved_at_43, t0.sold_or_rented_at AS sold_or_rented_at_44, t0.automatic_translation_disabled AS automatic_translation_disabled_45, t0.automatic_translated AS automatic_translated_46, t0.publish_full_address AS publish_full_address_47, t0.first_published_at AS first_published_at_48, t0.edit_lock_until AS edit_lock_until_49, t0.forced_publishing_phases AS forced_publishing_phases_50, t0.disallowed_publishing_phases AS disallowed_publishing_phases_51, t0.media_url_original_images AS media_url_original_images_52, t0.media_url_web_images AS media_url_web_images_53, t0.media_url_floor_plans AS media_url_floor_plans_54, t0.media_upload_status AS media_upload_status_55, t0.additional_publishing_delays AS additional_publishing_delays_56, t0.created_at AS created_at_57, t0.updated_at AS updated_at_58, t0.category_id AS category_id_59, t0.object_type_id AS object_type_id_60, t0.agent_id AS agent_id_61, t0.address_id AS address_id_62, t0.cloned_from_id AS cloned_from_id_63, t0.edit_lock_by_user_id AS edit_lock_by_user_id_64, t0.mandate_id AS mandate_id_65 FROM property t0 WHERE t0.id = 627;
|