SELECT `Property`.`id`, `Property`.`branch_code`, `Property`.`active`, `Property`.`status`, `Property`.`property_name`, `Property`.`owner_id`, `Property`.`owner_agreement`, `Property`.`owner_comment`, `Property`.`partner_id`, `Property`.`partner_reference`, `Property`.`partner_url`, `Property`.`partner_contact`, `Property`.`partner_agreement`, `Property`.`user_id`, `Property`.`reference`, `Property`.`country`, `Property`.`state`, `Property`.`province`, `Property`.`istat`, `Property`.`city`, `Property`.`district`, `Property`.`urbanization`, `Property`.`postalcode`, `Property`.`streetname`, `Property`.`streetnumber`, `Property`.`floor`, `Property`.`block`, `Property`.`stair`, `Property`.`latitude`, `Property`.`longitude`, `Property`.`coordinates_precision`, `Property`.`address_comment`, `Property`.`sales_price`, `Property`.`sales_price_before`, `Property`.`rental_price`, `Property`.`price_qualifier`, `Property`.`hide_price`, `Property`.`community_costs`, `Property`.`property_tax`, `Property`.`special_terms`, `Property`.`internal_comment`, `Property`.`external_owner_url`, `Property`.`youtube_url`, `Property`.`balcony`, `Property`.`terrace`, `Property`.`bathrooms`, `Property`.`single_bedrooms`, `Property`.`double_bedrooms`, `Property`.`constructed_area`, `Property`.`plot_area`, `Property`.`usable_area`, `Property`.`living_area`, `Property`.`parking`, `Property`.`heating`, `Property`.`air_conditioning`, `Property`.`elevator`, `Property`.`garden`, `Property`.`pool`, `Property`.`private_pool`, `Property`.`chimney`, `Property`.`seaview`, `Property`.`lakeview`, `Property`.`orientation`, `Property`.`construction_year`, `Property`.`cadastre_code`, `Property`.`cedula`, `Property`.`energy_certification`, `Property`.`emission_rating`, `Property`.`emissions`, `Property`.`consumption_rating`, `Property`.`consumption`, `Property`.`condition`, `Property`.`created`, `Property`.`modified`, (`Property`.`single_bedrooms` + `Property`.`double_bedrooms`) AS `Property__bedrooms`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`role`, `User`.`first_name`, `User`.`last_name`, `User`.`phone`, `User`.`fax`, `User`.`mobile`, `User`.`country`, `User`.`city`, `User`.`streetname`, `User`.`streetnumber`, `User`.`postalcode`, `User`.`email`, `User`.`email_disclaimer`, `User`.`show_clients_preference`, `User`.`feed_url`, `User`.`created`, `User`.`modified` FROM `db483700`.`properties` AS `Property` LEFT JOIN `db483700`.`users` AS `User` ON (`Property`.`user_id` = `User`.`id`) WHERE `Property`.`id` = 6152 LIMIT 1 | 1 | 1 | 1 | |