<?php } else{ ?>
<a href="<?php echo $image; ?>">
<img class="iframe" src="<?php echo $featuredImage ?>" data-layer="<div class='frame_layer'><i class='fa fa-play-circle'></i><p>Explore 3D Space</p><div>" />
$viewFile = '/home/workspaceasia/public_html/src/Template/Pages/lease_detail.ctp' $dataForView = [ 'fb_login_url' => 'https://www.facebook.com/v2.3/dialog/oauth?client_id=764495967085455&redirect_uri=http%3A%2F%2Fworkspaceasia.com%2Flogin&state=99509c62e73c6ea70418dfb858766e41&sdk=php-sdk-4.0.23&scope=email%2Cpublic_profile', 'property' => object(App\Model\Entity\Lease) { 'id' => (int) 114, 'name' => '鐵路大廈', 'prefix' => '', 'suffix' => '', 'slug' => 'railway-plaza', 'country_id' => (int) 98, 'area_id' => (int) 16, 'address' => '尖沙咀 漆咸道南39號', 'office_type' => (int) 2, 'featured_image' => null, 'images' => '', 'descriptions' => '位於尖東區核心地段的鐵路大廈是一棟高規格的標準大樓,地處優越,五分鐘即可至地鐵尖東站,從國內坐東鐵到公司只需半小時及港島區坐過海巴士到公司只需十五分鐘。享有便利的交通網。此商務中心價錢實惠,環境寧靜,為您提供齊全的設施和優良的品質, 致力於提供現代化及高科技之服務式辦公室、虛擬辦公室、會議室及其他專業服務。', 'meta_title' => null, 'meta_keywords' => null, 'meta_descriptions' => null, 'og_title' => null, 'og_type' => null, 'og_image' => null, 'amenities' => '["7","18","19","20","26","29","32","33","34"]', 'other_amenities' => null, 'space_verified' => (int) 0, 'featured' => (int) 0, 'guest_minimum' => null, 'guest_maximum' => null, 'payment_cancellation_policy' => null, 'air_con_hours' => null, 'top_features' => null, 'current_availability' => null, 'lat' => '22.298362', 'lng' => '114.175491', 'walking_distance' => null, 'status' => (int) 0, 'explore_space' => false, 'lease_order' => (int) 9999, 'created' => object(Cake\I18n\FrozenTime) {}, 'modified' => object(Cake\I18n\Time) {}, 'prices' => [ [maximum depth reached] ], 'area' => object(App\Model\Entity\Area) {}, 'country' => object(App\Model\Entity\Country) {}, 'office' => object(App\Model\Entity\Office) {}, '_locale' => 'zh_TW', '[new]' => false, '[accessible]' => [ [maximum depth reached] ], '[dirty]' => [[maximum depth reached]], '[original]' => [[maximum depth reached]], '[virtual]' => [[maximum depth reached]], '[errors]' => [[maximum depth reached]], '[invalid]' => [[maximum depth reached]], '[repository]' => 'Leases' }, 'amenities' => object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Amenities.id AS `Amenities__id`, Amenities.name AS `Amenities__name`, Amenities.fa_icon AS `Amenities__fa_icon`, Amenities.icon_image AS `Amenities__icon_image`, Amenities.custom_icon AS `Amenities__custom_icon`, Amenities_name_translation.id AS `Amenities_name_translation__id`, Amenities_name_translation.locale AS `Amenities_name_translation__locale`, Amenities_name_translation.model AS `Amenities_name_translation__model`, Amenities_name_translation.foreign_key AS `Amenities_name_translation__foreign_key`, Amenities_name_translation.field AS `Amenities_name_translation__field`, Amenities_name_translation.content AS `Amenities_name_translation__content` FROM amenities Amenities LEFT JOIN i18n Amenities_name_translation ON (Amenities_name_translation.model = :c0 AND Amenities_name_translation.field = :c1 AND Amenities_name_translation.content != :c2 AND Amenities_name_translation.locale = :c3 AND Amenities.id = (Amenities_name_translation.foreign_key))', 'params' => [ [maximum depth reached] ], 'defaultTypes' => [ [maximum depth reached] ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 1, 'mapReducers' => (int) 0, 'contain' => [ [maximum depth reached] ], 'matching' => [[maximum depth reached]], 'extraOptions' => [[maximum depth reached]], 'repository' => object(App\Model\Table\AmenitiesTable) {} }, 'properties' => object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Leases.id AS `Leases__id`, Leases.name AS `Leases__name`, Leases.prefix AS `Leases__prefix`, Leases.suffix AS `Leases__suffix`, Leases.slug AS `Leases__slug`, Leases.country_id AS `Leases__country_id`, Leases.area_id AS `Leases__area_id`, Leases.address AS `Leases__address`, Leases.office_type AS `Leases__office_type`, Leases.featured_image AS `Leases__featured_image`, Leases.images AS `Leases__images`, Leases.descriptions AS `Leases__descriptions`, Leases.meta_title AS `Leases__meta_title`, Leases.meta_keywords AS `Leases__meta_keywords`, Leases.meta_descriptions AS `Leases__meta_descriptions`, Leases.og_title AS `Leases__og_title`, Leases.og_type AS `Leases__og_type`, Leases.og_image AS `Leases__og_image`, Leases.amenities AS `Leases__amenities`, Leases.other_amenities AS `Leases__other_amenities`, Leases.space_verified AS `Leases__space_verified`, Leases.featured AS `Leases__featured`, Leases.guest_minimum AS `Leases__guest_minimum`, Leases.guest_maximum AS `Leases__guest_maximum`, Leases.payment_cancellation_policy AS `Leases__payment_cancellation_policy`, Leases.air_con_hours AS `Leases__air_con_hours`, Leases.top_features AS `Leases__top_features`, Leases.current_availability AS `Leases__current_availability`, Leases.lat AS `Leases__lat`, Leases.lng AS `Leases__lng`, Leases.walking_distance AS `Leases__walking_distance`, Leases.status AS `Leases__status`, Leases.explore_space AS `Leases__explore_space`, Leases.lease_order AS `Leases__lease_order`, Leases.created AS `Leases__created`, Leases.modified AS `Leases__modified`, Offices.id AS `Offices__id`, Offices.name AS `Offices__name`, Offices.slug AS `Offices__slug`, Offices.status AS `Offices__status`, Offices.created AS `Offices__created`, Offices.modified AS `Offices__modified`, Areas.id AS `Areas__id`, Areas.name AS `Areas__name`, Areas.slug AS `Areas__slug`, Areas.country_id AS `Areas__country_id`, Areas.state_id AS `Areas__state_id`, Areas.status AS `Areas__status`, Areas.area_order AS `Areas__area_order`, Areas.popular_location AS `Areas__popular_location`, Areas.meta_title AS `Areas__meta_title`, Areas.meta_keywords AS `Areas__meta_keywords`, Areas.meta_descriptions AS `Areas__meta_descriptions`, Areas.og_title AS `Areas__og_title`, Areas.og_type AS `Areas__og_type`, Areas.og_image AS `Areas__og_image`, Areas.modified AS `Areas__modified`, Countries.id AS `Countries__id`, Countries.name AS `Countries__name`, Countries.slug AS `Countries__slug`, Countries.parent_country AS `Countries__parent_country`, Countries.active AS `Countries__active`, Countries.country_order AS `Countries__country_order`, Countries.meta_title AS `Countries__meta_title`, Countries.meta_keywords AS `Countries__meta_keywords`, Countries.meta_descriptions AS `Countries__meta_descriptions`, Countries.og_title AS `Countries__og_title`, Countries.og_type AS `Countries__og_type`, Countries.og_image AS `Countries__og_image`, Countries.modified AS `Countries__modified`, Leases_name_translation.id AS `Leases_name_translation__id`, Leases_name_translation.locale AS `Leases_name_translation__locale`, Leases_name_translation.model AS `Leases_name_translation__model`, Leases_name_translation.foreign_key AS `Leases_name_translation__foreign_key`, Leases_name_translation.field AS `Leases_name_translation__field`, Leases_name_translation.content AS `Leases_name_translation__content`, Leases_prefix_translation.id AS `Leases_prefix_translation__id`, Leases_prefix_translation.locale AS `Leases_prefix_translation__locale`, Leases_prefix_translation.model AS `Leases_prefix_translation__model`, Leases_prefix_translation.foreign_key AS `Leases_prefix_translation__foreign_key`, Leases_prefix_translation.field AS `Leases_prefix_translation__field`, Leases_prefix_translation.content AS `Leases_prefix_translation__content`, Leases_suffix_translation.id AS `Leases_suffix_translation__id`, Leases_suffix_translation.locale AS `Leases_suffix_translation__locale`, Leases_suffix_translation.model AS `Leases_suffix_translation__model`, Leases_suffix_translation.foreign_key AS `Leases_suffix_translation__foreign_key`, Leases_suffix_translation.field AS `Leases_suffix_translation__field`, Leases_suffix_translation.content AS `Leases_suffix_translation__content`, Leases_address_translation.id AS `Leases_address_translation__id`, Leases_address_translation.locale AS `Leases_address_translation__locale`, Leases_address_translation.model AS `Leases_address_translation__model`, Leases_address_translation.foreign_key AS `Leases_address_translation__foreign_key`, Leases_address_translation.field AS `Leases_address_translation__field`, Leases_address_translation.content AS `Leases_address_translation__content`, Leases_descriptions_translation.id AS `Leases_descriptions_translation__id`, Leases_descriptions_translation.locale AS `Leases_descriptions_translation__locale`, Leases_descriptions_translation.model AS `Leases_descriptions_translation__model`, Leases_descriptions_translation.foreign_key AS `Leases_descriptions_translation__foreign_key`, Leases_descriptions_translation.field AS `Leases_descriptions_translation__field`, Leases_descriptions_translation.content AS `Leases_descriptions_translation__content`, Leases_meta_title_translation.id AS `Leases_meta_title_translation__id`, Leases_meta_title_translation.locale AS `Leases_meta_title_translation__locale`, Leases_meta_title_translation.model AS `Leases_meta_title_translation__model`, Leases_meta_title_translation.foreign_key AS `Leases_meta_title_translation__foreign_key`, Leases_meta_title_translation.field AS `Leases_meta_title_translation__field`, Leases_meta_title_translation.content AS `Leases_meta_title_translation__content`, Leases_meta_keywords_translation.id AS `Leases_meta_keywords_translation__id`, Leases_meta_keywords_translation.locale AS `Leases_meta_keywords_translation__locale`, Leases_meta_keywords_translation.model AS `Leases_meta_keywords_translation__model`, Leases_meta_keywords_translation.foreign_key AS `Leases_meta_keywords_translation__foreign_key`, Leases_meta_keywords_translation.field AS `Leases_meta_keywords_translation__field`, Leases_meta_keywords_translation.content AS `Leases_meta_keywords_translation__content`, Leases_meta_descriptions_translation.id AS `Leases_meta_descriptions_translation__id`, Leases_meta_descriptions_translation.locale AS `Leases_meta_descriptions_translation__locale`, Leases_meta_descriptions_translation.model AS `Leases_meta_descriptions_translation__model`, Leases_meta_descriptions_translation.foreign_key AS `Leases_meta_descriptions_translation__foreign_key`, Leases_meta_descriptions_translation.field AS `Leases_meta_descriptions_translation__field`, Leases_meta_descriptions_translation.content AS `Leases_meta_descriptions_translation__content`, Leases_og_title_translation.id AS `Leases_og_title_translation__id`, Leases_og_title_translation.locale AS `Leases_og_title_translation__locale`, Leases_og_title_translation.model AS `Leases_og_title_translation__model`, Leases_og_title_translation.foreign_key AS `Leases_og_title_translation__foreign_key`, Leases_og_title_translation.field AS `Leases_og_title_translation__field`, Leases_og_title_translation.content AS `Leases_og_title_translation__content`, Leases_og_type_translation.id AS `Leases_og_type_translation__id`, Leases_og_type_translation.locale AS `Leases_og_type_translation__locale`, Leases_og_type_translation.model AS `Leases_og_type_translation__model`, Leases_og_type_translation.foreign_key AS `Leases_og_type_translation__foreign_key`, Leases_og_type_translation.field AS `Leases_og_type_translation__field`, Leases_og_type_translation.content AS `Leases_og_type_translation__content`, Leases_top_features_translation.id AS `Leases_top_features_translation__id`, Leases_top_features_translation.locale AS `Leases_top_features_translation__locale`, Leases_top_features_translation.model AS `Leases_top_features_translation__model`, Leases_top_features_translation.foreign_key AS `Leases_top_features_translation__foreign_key`, Leases_top_features_translation.field AS `Leases_top_features_translation__field`, Leases_top_features_translation.content AS `Leases_top_features_translation__content`, Leases_current_availability_translation.id AS `Leases_current_availability_translation__id`, Leases_current_availability_translation.locale AS `Leases_current_availability_translation__locale`, Leases_current_availability_translation.model AS `Leases_current_availability_translation__model`, Leases_current_availability_translation.foreign_key AS `Leases_current_availability_translation__foreign_key`, Leases_current_availability_translation.field AS `Leases_current_availability_translation__field`, Leases_current_availability_translation.content AS `Leases_current_availability_translation__content`, Leases_walking_distance_translation.id AS `Leases_walking_distance_translation__id`, Leases_walking_distance_translation.locale AS `Leases_walking_distance_translation__locale`, Leases_walking_distance_translation.model AS `Leases_walking_distance_translation__model`, Leases_walking_distance_translation.foreign_key AS `Leases_walking_distance_translation__foreign_key`, Leases_walking_distance_translation.field AS `Leases_walking_distance_translation__field`, Leases_walking_distance_translation.content AS `Leases_walking_distance_translation__content`, Offices_name_translation.id AS `Offices_name_translation__id`, Offices_name_translation.locale AS `Offices_name_translation__locale`, Offices_name_translation.model AS `Offices_name_translation__model`, Offices_name_translation.foreign_key AS `Offices_name_translation__foreign_key`, Offices_name_translation.field AS `Offices_name_translation__field`, Offices_name_translation.content AS `Offices_name_translation__content`, Areas_name_translation.id AS `Areas_name_translation__id`, Areas_name_translation.locale AS `Areas_name_translation__locale`, Areas_name_translation.model AS `Areas_name_translation__model`, Areas_name_translation.foreign_key AS `Areas_name_translation__foreign_key`, Areas_name_translation.field AS `Areas_name_translation__field`, Areas_name_translation.content AS `Areas_name_translation__content`, Areas_meta_title_translation.id AS `Areas_meta_title_translation__id`, Areas_meta_title_translation.locale AS `Areas_meta_title_translation__locale`, Areas_meta_title_translation.model AS `Areas_meta_title_translation__model`, Areas_meta_title_translation.foreign_key AS `Areas_meta_title_translation__foreign_key`, Areas_meta_title_translation.field AS `Areas_meta_title_translation__field`, Areas_meta_title_translation.content AS `Areas_meta_title_translation__content`, Areas_meta_keywords_translation.id AS `Areas_meta_keywords_translation__id`, Areas_meta_keywords_translation.locale AS `Areas_meta_keywords_translation__locale`, Areas_meta_keywords_translation.model AS `Areas_meta_keywords_translation__model`, Areas_meta_keywords_translation.foreign_key AS `Areas_meta_keywords_translation__foreign_key`, Areas_meta_keywords_translation.field AS `Areas_meta_keywords_translation__field`, Areas_meta_keywords_translation.content AS `Areas_meta_keywords_translation__content`, Areas_meta_descriptions_translation.id AS `Areas_meta_descriptions_translation__id`, Areas_meta_descriptions_translation.locale AS `Areas_meta_descriptions_translation__locale`, Areas_meta_descriptions_translation.model AS `Areas_meta_descriptions_translation__model`, Areas_meta_descriptions_translation.foreign_key AS `Areas_meta_descriptions_translation__foreign_key`, Areas_meta_descriptions_translation.field AS `Areas_meta_descriptions_translation__field`, Areas_meta_descriptions_translation.content AS `Areas_meta_descriptions_translation__content`, Areas_og_title_translation.id AS `Areas_og_title_translation__id`, Areas_og_title_translation.locale AS `Areas_og_title_translation__locale`, Areas_og_title_translation.model AS `Areas_og_title_translation__model`, Areas_og_title_translation.foreign_key AS `Areas_og_title_translation__foreign_key`, Areas_og_title_translation.field AS `Areas_og_title_translation__field`, Areas_og_title_translation.content AS `Areas_og_title_translation__content`, Areas_og_type_translation.id AS `Areas_og_type_translation__id`, Areas_og_type_translation.locale AS `Areas_og_type_translation__locale`, Areas_og_type_translation.model AS `Areas_og_type_translation__model`, Areas_og_type_translation.foreign_key AS `Areas_og_type_translation__foreign_key`, Areas_og_type_translation.field AS `Areas_og_type_translation__field`, Areas_og_type_translation.content AS `Areas_og_type_translation__content`, Countries_name_translation.id AS `Countries_name_translation__id`, Countries_name_translation.locale AS `Countries_name_translation__locale`, Countries_name_translation.model AS `Countries_name_translation__model`, Countries_name_translation.foreign_key AS `Countries_name_translation__foreign_key`, Countries_name_translation.field AS `Countries_name_translation__field`, Countries_name_translation.content AS `Countries_name_translation__content`, Countries_meta_title_translation.id AS `Countries_meta_title_translation__id`, Countries_meta_title_translation.locale AS `Countries_meta_title_translation__locale`, Countries_meta_title_translation.model AS `Countries_meta_title_translation__model`, Countries_meta_title_translation.foreign_key AS `Countries_meta_title_translation__foreign_key`, Countries_meta_title_translation.field AS `Countries_meta_title_translation__field`, Countries_meta_title_translation.content AS `Countries_meta_title_translation__content`, Countries_meta_keywords_translation.id AS `Countries_meta_keywords_translation__id`, Countries_meta_keywords_translation.locale AS `Countries_meta_keywords_translation__locale`, Countries_meta_keywords_translation.model AS `Countries_meta_keywords_translation__model`, Countries_meta_keywords_translation.foreign_key AS `Countries_meta_keywords_translation__foreign_key`, Countries_meta_keywords_translation.field AS `Countries_meta_keywords_translation__field`, Countries_meta_keywords_translation.content AS `Countries_meta_keywords_translation__content`, Countries_meta_descriptions_translation.id AS `Countries_meta_descriptions_translation__id`, Countries_meta_descriptions_translation.locale AS `Countries_meta_descriptions_translation__locale`, Countries_meta_descriptions_translation.model AS `Countries_meta_descriptions_translation__model`, Countries_meta_descriptions_translation.foreign_key AS `Countries_meta_descriptions_translation__foreign_key`, Countries_meta_descriptions_translation.field AS `Countries_meta_descriptions_translation__field`, Countries_meta_descriptions_translation.content AS `Countries_meta_descriptions_translation__content`, Countries_og_title_translation.id AS `Countries_og_title_translation__id`, Countries_og_title_translation.locale AS `Countries_og_title_translation__locale`, Countries_og_title_translation.model AS `Countries_og_title_translation__model`, Countries_og_title_translation.foreign_key AS `Countries_og_title_translation__foreign_key`, Countries_og_title_translation.field AS `Countries_og_title_translation__field`, Countries_og_title_translation.content AS `Countries_og_title_translation__content`, Countries_og_type_translation.id AS `Countries_og_type_translation__id`, Countries_og_type_translation.locale AS `Countries_og_type_translation__locale`, Countries_og_type_translation.model AS `Countries_og_type_translation__model`, Countries_og_type_translation.foreign_key AS `Countries_og_type_translation__foreign_key`, Countries_og_type_translation.field AS `Countries_og_type_translation__field`, Countries_og_type_translation.content AS `Countries_og_type_translation__content` FROM leases Leases INNER JOIN prices Prices ON (Prices.lease_id = Leases.id AND Prices.price_type_id = 3) INNER JOIN offices Offices ON Offices.id = (Leases.office_type) INNER JOIN areas Areas ON Areas.id = (Leases.area_id) INNER JOIN countries Countries ON Countries.id = (Leases.country_id) LEFT JOIN i18n Leases_name_translation ON (Leases_name_translation.model = :c0 AND Leases_name_translation.field = :c1 AND Leases_name_translation.content != :c2 AND Leases_name_translation.locale = :c3 AND Leases.id = (Leases_name_translation.foreign_key)) LEFT JOIN i18n Leases_prefix_translation ON (Leases_prefix_translation.model = :c4 AND Leases_prefix_translation.field = :c5 AND Leases_prefix_translation.content != :c6 AND Leases_prefix_translation.locale = :c7 AND Leases.id = (Leases_prefix_translation.foreign_key)) LEFT JOIN i18n Leases_suffix_translation ON (Leases_suffix_translation.model = :c8 AND Leases_suffix_translation.field = :c9 AND Leases_suffix_translation.content != :c10 AND Leases_suffix_translation.locale = :c11 AND Leases.id = (Leases_suffix_translation.foreign_key)) LEFT JOIN i18n Leases_address_translation ON (Leases_address_translation.model = :c12 AND Leases_address_translation.field = :c13 AND Leases_address_translation.content != :c14 AND Leases_address_translation.locale = :c15 AND Leases.id = (Leases_address_translation.foreign_key)) LEFT JOIN i18n Leases_descriptions_translation ON (Leases_descriptions_translation.model = :c16 AND Leases_descriptions_translation.field = :c17 AND Leases_descriptions_translation.content != :c18 AND Leases_descriptions_translation.locale = :c19 AND Leases.id = (Leases_descriptions_translation.foreign_key)) LEFT JOIN i18n Leases_meta_title_translation ON (Leases_meta_title_translation.model = :c20 AND Leases_meta_title_translation.field = :c21 AND Leases_meta_title_translation.content != :c22 AND Leases_meta_title_translation.locale = :c23 AND Leases.id = (Leases_meta_title_translation.foreign_key)) LEFT JOIN i18n Leases_meta_keywords_translation ON (Leases_meta_keywords_translation.model = :c24 AND Leases_meta_keywords_translation.field = :c25 AND Leases_meta_keywords_translation.content != :c26 AND Leases_meta_keywords_translation.locale = :c27 AND Leases.id = (Leases_meta_keywords_translation.foreign_key)) LEFT JOIN i18n Leases_meta_descriptions_translation ON (Leases_meta_descriptions_translation.model = :c28 AND Leases_meta_descriptions_translation.field = :c29 AND Leases_meta_descriptions_translation.content != :c30 AND Leases_meta_descriptions_translation.locale = :c31 AND Leases.id = (Leases_meta_descriptions_translation.foreign_key)) LEFT JOIN i18n Leases_og_title_translation ON (Leases_og_title_translation.model = :c32 AND Leases_og_title_translation.field = :c33 AND Leases_og_title_translation.content != :c34 AND Leases_og_title_translation.locale = :c35 AND Leases.id = (Leases_og_title_translation.foreign_key)) LEFT JOIN i18n Leases_og_type_translation ON (Leases_og_type_translation.model = :c36 AND Leases_og_type_translation.field = :c37 AND Leases_og_type_translation.content != :c38 AND Leases_og_type_translation.locale = :c39 AND Leases.id = (Leases_og_type_translation.foreign_key)) LEFT JOIN i18n Leases_top_features_translation ON (Leases_top_features_translation.model = :c40 AND Leases_top_features_translation.field = :c41 AND Leases_top_features_translation.content != :c42 AND Leases_top_features_translation.locale = :c43 AND Leases.id = (Leases_top_features_translation.foreign_key)) LEFT JOIN i18n Leases_current_availability_translation ON (Leases_current_availability_translation.model = :c44 AND Leases_current_availability_translation.field = :c45 AND Leases_current_availability_translation.content != :c46 AND Leases_current_availability_translation.locale = :c47 AND Leases.id = (Leases_current_availability_translation.foreign_key)) LEFT JOIN i18n Leases_walking_distance_translation ON (Leases_walking_distance_translation.model = :c48 AND Leases_walking_distance_translation.field = :c49 AND Leases_walking_distance_translation.content != :c50 AND Leases_walking_distance_translation.locale = :c51 AND Leases.id = (Leases_walking_distance_translation.foreign_key)) LEFT JOIN i18n Offices_name_translation ON (Offices_name_translation.model = :c52 AND Offices_name_translation.field = :c53 AND Offices_name_translation.content != :c54 AND Offices_name_translation.locale = :c55 AND Offices.id = (Offices_name_translation.foreign_key)) LEFT JOIN i18n Areas_name_translation ON (Areas_name_translation.model = :c56 AND Areas_name_translation.field = :c57 AND Areas_name_translation.content != :c58 AND Areas_name_translation.locale = :c59 AND Areas.id = (Areas_name_translation.foreign_key)) LEFT JOIN i18n Areas_meta_title_translation ON (Areas_meta_title_translation.model = :c60 AND Areas_meta_title_translation.field = :c61 AND Areas_meta_title_translation.content != :c62 AND Areas_meta_title_translation.locale = :c63 AND Areas.id = (Areas_meta_title_translation.foreign_key)) LEFT JOIN i18n Areas_meta_keywords_translation ON (Areas_meta_keywords_translation.model = :c64 AND Areas_meta_keywords_translation.field = :c65 AND Areas_meta_keywords_translation.content != :c66 AND Areas_meta_keywords_translation.locale = :c67 AND Areas.id = (Areas_meta_keywords_translation.foreign_key)) LEFT JOIN i18n Areas_meta_descriptions_translation ON (Areas_meta_descriptions_translation.model = :c68 AND Areas_meta_descriptions_translation.field = :c69 AND Areas_meta_descriptions_translation.content != :c70 AND Areas_meta_descriptions_translation.locale = :c71 AND Areas.id = (Areas_meta_descriptions_translation.foreign_key)) LEFT JOIN i18n Areas_og_title_translation ON (Areas_og_title_translation.model = :c72 AND Areas_og_title_translation.field = :c73 AND Areas_og_title_translation.content != :c74 AND Areas_og_title_translation.locale = :c75 AND Areas.id = (Areas_og_title_translation.foreign_key)) LEFT JOIN i18n Areas_og_type_translation ON (Areas_og_type_translation.model = :c76 AND Areas_og_type_translation.field = :c77 AND Areas_og_type_translation.content != :c78 AND Areas_og_type_translation.locale = :c79 AND Areas.id = (Areas_og_type_translation.foreign_key)) LEFT JOIN i18n Countries_name_translation ON (Countries_name_translation.model = :c80 AND Countries_name_translation.field = :c81 AND Countries_name_translation.content != :c82 AND Countries_name_translation.locale = :c83 AND Countries.id = (Countries_name_translation.foreign_key)) LEFT JOIN i18n Countries_meta_title_translation ON (Countries_meta_title_translation.model = :c84 AND Countries_meta_title_translation.field = :c85 AND Countries_meta_title_translation.content != :c86 AND Countries_meta_title_translation.locale = :c87 AND Countries.id = (Countries_meta_title_translation.foreign_key)) LEFT JOIN i18n Countries_meta_keywords_translation ON (Countries_meta_keywords_translation.model = :c88 AND Countries_meta_keywords_translation.field = :c89 AND Countries_meta_keywords_translation.content != :c90 AND Countries_meta_keywords_translation.locale = :c91 AND Countries.id = (Countries_meta_keywords_translation.foreign_key)) LEFT JOIN i18n Countries_meta_descriptions_translation ON (Countries_meta_descriptions_translation.model = :c92 AND Countries_meta_descriptions_translation.field = :c93 AND Countries_meta_descriptions_translation.content != :c94 AND Countries_meta_descriptions_translation.locale = :c95 AND Countries.id = (Countries_meta_descriptions_translation.foreign_key)) LEFT JOIN i18n Countries_og_title_translation ON (Countries_og_title_translation.model = :c96 AND Countries_og_title_translation.field = :c97 AND Countries_og_title_translation.content != :c98 AND Countries_og_title_translation.locale = :c99 AND Countries.id = (Countries_og_title_translation.foreign_key)) LEFT JOIN i18n Countries_og_type_translation ON (Countries_og_type_translation.model = :c100 AND Countries_og_type_translation.field = :c101 AND Countries_og_type_translation.content != :c102 AND Countries_og_type_translation.locale = :c103 AND Countries.id = (Countries_og_type_translation.foreign_key)) WHERE (Leases.country_id = :c104 AND Leases.area_id = :c105 AND Leases.id != :c106 AND Leases.status = :c107) GROUP BY Leases.id ', 'params' => [ [maximum depth reached] ], 'defaultTypes' => [ [maximum depth reached] ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 4, 'mapReducers' => (int) 0, 'contain' => [ [maximum depth reached] ], 'matching' => [[maximum depth reached]], 'extraOptions' => [[maximum depth reached]], 'repository' => object(App\Model\Table\LeasesTable) {} }, 'countries' => object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Countries.id AS `Countries__id`, Countries.name AS `Countries__name`, Countries.slug AS `Countries__slug`, Countries.parent_country AS `Countries__parent_country`, Countries.active AS `Countries__active`, Countries.country_order AS `Countries__country_order`, Countries.meta_title AS `Countries__meta_title`, Countries.meta_keywords AS `Countries__meta_keywords`, Countries.meta_descriptions AS `Countries__meta_descriptions`, Countries.og_title AS `Countries__og_title`, Countries.og_type AS `Countries__og_type`, Countries.og_image AS `Countries__og_image`, Countries.modified AS `Countries__modified`, Countries_name_translation.id AS `Countries_name_translation__id`, Countries_name_translation.locale AS `Countries_name_translation__locale`, Countries_name_translation.model AS `Countries_name_translation__model`, Countries_name_translation.foreign_key AS `Countries_name_translation__foreign_key`, Countries_name_translation.field AS `Countries_name_translation__field`, Countries_name_translation.content AS `Countries_name_translation__content`, Countries_meta_title_translation.id AS `Countries_meta_title_translation__id`, Countries_meta_title_translation.locale AS `Countries_meta_title_translation__locale`, Countries_meta_title_translation.model AS `Countries_meta_title_translation__model`, Countries_meta_title_translation.foreign_key AS `Countries_meta_title_translation__foreign_key`, Countries_meta_title_translation.field AS `Countries_meta_title_translation__field`, Countries_meta_title_translation.content AS `Countries_meta_title_translation__content`, Countries_meta_keywords_translation.id AS `Countries_meta_keywords_translation__id`, Countries_meta_keywords_translation.locale AS `Countries_meta_keywords_translation__locale`, Countries_meta_keywords_translation.model AS `Countries_meta_keywords_translation__model`, Countries_meta_keywords_translation.foreign_key AS `Countries_meta_keywords_translation__foreign_key`, Countries_meta_keywords_translation.field AS `Countries_meta_keywords_translation__field`, Countries_meta_keywords_translation.content AS `Countries_meta_keywords_translation__content`, Countries_meta_descriptions_translation.id AS `Countries_meta_descriptions_translation__id`, Countries_meta_descriptions_translation.locale AS `Countries_meta_descriptions_translation__locale`, Countries_meta_descriptions_translation.model AS `Countries_meta_descriptions_translation__model`, Countries_meta_descriptions_translation.foreign_key AS `Countries_meta_descriptions_translation__foreign_key`, Countries_meta_descriptions_translation.field AS `Countries_meta_descriptions_translation__field`, Countries_meta_descriptions_translation.content AS `Countries_meta_descriptions_translation__content`, Countries_og_title_translation.id AS `Countries_og_title_translation__id`, Countries_og_title_translation.locale AS `Countries_og_title_translation__locale`, Countries_og_title_translation.model AS `Countries_og_title_translation__model`, Countries_og_title_translation.foreign_key AS `Countries_og_title_translation__foreign_key`, Countries_og_title_translation.field AS `Countries_og_title_translation__field`, Countries_og_title_translation.content AS `Countries_og_title_translation__content`, Countries_og_type_translation.id AS `Countries_og_type_translation__id`, Countries_og_type_translation.locale AS `Countries_og_type_translation__locale`, Countries_og_type_translation.model AS `Countries_og_type_translation__model`, Countries_og_type_translation.foreign_key AS `Countries_og_type_translation__foreign_key`, Countries_og_type_translation.field AS `Countries_og_type_translation__field`, Countries_og_type_translation.content AS `Countries_og_type_translation__content` FROM countries Countries LEFT JOIN i18n Countries_name_translation ON (Countries_name_translation.model = :c0 AND Countries_name_translation.field = :c1 AND Countries_name_translation.content != :c2 AND Countries_name_translation.locale = :c3 AND Countries.id = (Countries_name_translation.foreign_key)) LEFT JOIN i18n Countries_meta_title_translation ON (Countries_meta_title_translation.model = :c4 AND Countries_meta_title_translation.field = :c5 AND Countries_meta_title_translation.content != :c6 AND Countries_meta_title_translation.locale = :c7 AND Countries.id = (Countries_meta_title_translation.foreign_key)) LEFT JOIN i18n Countries_meta_keywords_translation ON (Countries_meta_keywords_translation.model = :c8 AND Countries_meta_keywords_translation.field = :c9 AND Countries_meta_keywords_translation.content != :c10 AND Countries_meta_keywords_translation.locale = :c11 AND Countries.id = (Countries_meta_keywords_translation.foreign_key)) LEFT JOIN i18n Countries_meta_descriptions_translation ON (Countries_meta_descriptions_translation.model = :c12 AND Countries_meta_descriptions_translation.field = :c13 AND Countries_meta_descriptions_translation.content != :c14 AND Countries_meta_descriptions_translation.locale = :c15 AND Countries.id = (Countries_meta_descriptions_translation.foreign_key)) LEFT JOIN i18n Countries_og_title_translation ON (Countries_og_title_translation.model = :c16 AND Countries_og_title_translation.field = :c17 AND Countries_og_title_translation.content != :c18 AND Countries_og_title_translation.locale = :c19 AND Countries.id = (Countries_og_title_translation.foreign_key)) LEFT JOIN i18n Countries_og_type_translation ON (Countries_og_type_translation.model = :c20 AND Countries_og_type_translation.field = :c21 AND Countries_og_type_translation.content != :c22 AND Countries_og_type_translation.locale = :c23 AND Countries.id = (Countries_og_type_translation.foreign_key)) WHERE Countries.active = :c24 ORDER BY Countries.country_order ASC, Countries.modified DESC', 'params' => [ [maximum depth reached] ], 'defaultTypes' => [ [maximum depth reached] ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 1, 'mapReducers' => (int) 0, 'contain' => [ [maximum depth reached] ], 'matching' => [[maximum depth reached]], 'extraOptions' => [[maximum depth reached]], 'repository' => object(App\Model\Table\CountriesTable) {} }, 'offices' => object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Offices.id AS `Offices__id`, Offices.name AS `Offices__name`, Offices_name_translation.id AS `Offices_name_translation__id`, Offices_name_translation.content AS `Offices_name_translation__content` FROM offices Offices LEFT JOIN i18n Offices_name_translation ON (Offices_name_translation.model = :c0 AND Offices_name_translation.field = :c1 AND Offices_name_translation.content != :c2 AND Offices_name_translation.locale = :c3 AND Offices.id = (Offices_name_translation.foreign_key)) WHERE Offices.status = :c4', 'params' => [ [maximum depth reached] ], 'defaultTypes' => [ [maximum depth reached] ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 2, 'mapReducers' => (int) 0, 'contain' => [ [maximum depth reached] ], 'matching' => [[maximum depth reached]], 'extraOptions' => [[maximum depth reached]], 'repository' => object(App\Model\Table\OfficesTable) {} }, 'areas' => object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT States.id AS `States__id`, States.country_id AS `States__country_id`, States.name AS `States__name`, States.slug AS `States__slug`, States.status AS `States__status`, States.state_order AS `States__state_order`, States.meta_title AS `States__meta_title`, States.meta_keywords AS `States__meta_keywords`, States.meta_descriptions AS `States__meta_descriptions`, States.og_title AS `States__og_title`, States.og_type AS `States__og_type`, States.og_image AS `States__og_image`, States.modified AS `States__modified`, States_name_translation.id AS `States_name_translation__id`, States_name_translation.locale AS `States_name_translation__locale`, States_name_translation.model AS `States_name_translation__model`, States_name_translation.foreign_key AS `States_name_translation__foreign_key`, States_name_translation.field AS `States_name_translation__field`, States_name_translation.content AS `States_name_translation__content`, States_meta_title_translation.id AS `States_meta_title_translation__id`, States_meta_title_translation.locale AS `States_meta_title_translation__locale`, States_meta_title_translation.model AS `States_meta_title_translation__model`, States_meta_title_translation.foreign_key AS `States_meta_title_translation__foreign_key`, States_meta_title_translation.field AS `States_meta_title_translation__field`, States_meta_title_translation.content AS `States_meta_title_translation__content`, States_meta_keywords_translation.id AS `States_meta_keywords_translation__id`, States_meta_keywords_translation.locale AS `States_meta_keywords_translation__locale`, States_meta_keywords_translation.model AS `States_meta_keywords_translation__model`, States_meta_keywords_translation.foreign_key AS `States_meta_keywords_translation__foreign_key`, States_meta_keywords_translation.field AS `States_meta_keywords_translation__field`, States_meta_keywords_translation.content AS `States_meta_keywords_translation__content`, States_meta_descriptions_translation.id AS `States_meta_descriptions_translation__id`, States_meta_descriptions_translation.locale AS `States_meta_descriptions_translation__locale`, States_meta_descriptions_translation.model AS `States_meta_descriptions_translation__model`, States_meta_descriptions_translation.foreign_key AS `States_meta_descriptions_translation__foreign_key`, States_meta_descriptions_translation.field AS `States_meta_descriptions_translation__field`, States_meta_descriptions_translation.content AS `States_meta_descriptions_translation__content`, States_og_title_translation.id AS `States_og_title_translation__id`, States_og_title_translation.locale AS `States_og_title_translation__locale`, States_og_title_translation.model AS `States_og_title_translation__model`, States_og_title_translation.foreign_key AS `States_og_title_translation__foreign_key`, States_og_title_translation.field AS `States_og_title_translation__field`, States_og_title_translation.content AS `States_og_title_translation__content`, States_og_type_translation.id AS `States_og_type_translation__id`, States_og_type_translation.locale AS `States_og_type_translation__locale`, States_og_type_translation.model AS `States_og_type_translation__model`, States_og_type_translation.foreign_key AS `States_og_type_translation__foreign_key`, States_og_type_translation.field AS `States_og_type_translation__field`, States_og_type_translation.content AS `States_og_type_translation__content` FROM states States LEFT JOIN i18n States_name_translation ON (States_name_translation.model = :c0 AND States_name_translation.field = :c1 AND States_name_translation.content != :c2 AND States_name_translation.locale = :c3 AND States.id = (States_name_translation.foreign_key)) LEFT JOIN i18n States_meta_title_translation ON (States_meta_title_translation.model = :c4 AND States_meta_title_translation.field = :c5 AND States_meta_title_translation.content != :c6 AND States_meta_title_translation.locale = :c7 AND States.id = (States_meta_title_translation.foreign_key)) LEFT JOIN i18n States_meta_keywords_translation ON (States_meta_keywords_translation.model = :c8 AND States_meta_keywords_translation.field = :c9 AND States_meta_keywords_translation.content != :c10 AND States_meta_keywords_translation.locale = :c11 AND States.id = (States_meta_keywords_translation.foreign_key)) LEFT JOIN i18n States_meta_descriptions_translation ON (States_meta_descriptions_translation.model = :c12 AND States_meta_descriptions_translation.field = :c13 AND States_meta_descriptions_translation.content != :c14 AND States_meta_descriptions_translation.locale = :c15 AND States.id = (States_meta_descriptions_translation.foreign_key)) LEFT JOIN i18n States_og_title_translation ON (States_og_title_translation.model = :c16 AND States_og_title_translation.field = :c17 AND States_og_title_translation.content != :c18 AND States_og_title_translation.locale = :c19 AND States.id = (States_og_title_translation.foreign_key)) LEFT JOIN i18n States_og_type_translation ON (States_og_type_translation.model = :c20 AND States_og_type_translation.field = :c21 AND States_og_type_translation.content != :c22 AND States_og_type_translation.locale = :c23 AND States.id = (States_og_type_translation.foreign_key)) WHERE (States.status = :c24 AND States.country_id = :c25) ORDER BY States.state_order ASC, States.modified DESC', 'params' => [ [maximum depth reached] ], 'defaultTypes' => [ [maximum depth reached] ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 1, 'mapReducers' => (int) 0, 'contain' => [ [maximum depth reached] ], 'matching' => [[maximum depth reached]], 'extraOptions' => [[maximum depth reached]], 'repository' => object(App\Model\Table\StatesTable) {} }, 'building' => null, 'leases_availability' => object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT LeasesAvailability.id AS `LeasesAvailability__id`, LeasesAvailability.leases_id AS `LeasesAvailability__leases_id`, LeasesAvailability.office_id AS `LeasesAvailability__office_id`, LeasesAvailability.office_type AS `LeasesAvailability__office_type`, LeasesAvailability.price_type_id AS `LeasesAvailability__price_type_id`, LeasesAvailability.currency_id AS `LeasesAvailability__currency_id`, LeasesAvailability.currency_code AS `LeasesAvailability__currency_code`, LeasesAvailability.price AS `LeasesAvailability__price`, LeasesAvailability.price_from AS `LeasesAvailability__price_from`, LeasesAvailability.number_of_pax AS `LeasesAvailability__number_of_pax`, LeasesAvailability.number_of_pax_max AS `LeasesAvailability__number_of_pax_max`, LeasesAvailability.availability AS `LeasesAvailability__availability`, LeasesAvailability.deleted AS `LeasesAvailability__deleted`, PriceTypes.id AS `PriceTypes__id`, PriceTypes.type AS `PriceTypes__type`, Currencies.id AS `Currencies__id`, Currencies.country_id AS `Currencies__country_id`, Currencies.name AS `Currencies__name`, Currencies.code AS `Currencies__code`, Currencies.symbol AS `Currencies__symbol`, Currencies.show_after AS `Currencies__show_after`, Currencies.status AS `Currencies__status`, LeasesAvailability_office_type_translation.id AS `LeasesAvailability_office_type_translation__id`, LeasesAvailability_office_type_translation.locale AS `LeasesAvailability_office_type_translation__locale`, LeasesAvailability_office_type_translation.model AS `LeasesAvailability_office_type_translation__model`, LeasesAvailability_office_type_translation.foreign_key AS `LeasesAvailability_office_type_translation__foreign_key`, LeasesAvailability_office_type_translation.field AS `LeasesAvailability_office_type_translation__field`, LeasesAvailability_office_type_translation.content AS `LeasesAvailability_office_type_translation__content` FROM leases_availability LeasesAvailability INNER JOIN price_types PriceTypes ON PriceTypes.id = (LeasesAvailability.price_type_id) INNER JOIN currencies Currencies ON Currencies.id = (LeasesAvailability.currency_id) LEFT JOIN i18n LeasesAvailability_office_type_translation ON (LeasesAvailability_office_type_translation.model = :c0 AND LeasesAvailability_office_type_translation.field = :c1 AND LeasesAvailability_office_type_translation.content != :c2 AND LeasesAvailability_office_type_translation.locale = :c3 AND LeasesAvailability.id = (LeasesAvailability_office_type_translation.foreign_key)) WHERE LeasesAvailability.leases_id = :c4', 'params' => [ [maximum depth reached] ], 'defaultTypes' => [ [maximum depth reached] ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 2, 'mapReducers' => (int) 0, 'contain' => [ [maximum depth reached] ], 'matching' => [[maximum depth reached]], 'extraOptions' => [[maximum depth reached]], 'repository' => object(App\Model\Table\LeasesAvailabilityTable) {} }, 'languages' => null, 'locale_lang' => 'zh', 'countryName' => 'US' ] $fb_login_url = 'https://www.facebook.com/v2.3/dialog/oauth?client_id=764495967085455&redirect_uri=http%3A%2F%2Fworkspaceasia.com%2Flogin&state=99509c62e73c6ea70418dfb858766e41&sdk=php-sdk-4.0.23&scope=email%2Cpublic_profile' $property = object(App\Model\Entity\Lease) { 'id' => (int) 114, 'name' => '鐵路大廈', 'prefix' => '', 'suffix' => '', 'slug' => 'railway-plaza', 'country_id' => (int) 98, 'area_id' => (int) 16, 'address' => '尖沙咀 漆咸道南39號', 'office_type' => (int) 2, 'featured_image' => null, 'images' => '', 'descriptions' => '位於尖東區核心地段的鐵路大廈是一棟高規格的標準大樓,地處優越,五分鐘即可至地鐵尖東站,從國內坐東鐵到公司只需半小時及港島區坐過海巴士到公司只需十五分鐘。享有便利的交通網。此商務中心價錢實惠,環境寧靜,為您提供齊全的設施和優良的品質, 致力於提供現代化及高科技之服務式辦公室、虛擬辦公室、會議室及其他專業服務。', 'meta_title' => null, 'meta_keywords' => null, 'meta_descriptions' => null, 'og_title' => null, 'og_type' => null, 'og_image' => null, 'amenities' => '["7","18","19","20","26","29","32","33","34"]', 'other_amenities' => null, 'space_verified' => (int) 0, 'featured' => (int) 0, 'guest_minimum' => null, 'guest_maximum' => null, 'payment_cancellation_policy' => null, 'air_con_hours' => null, 'top_features' => null, 'current_availability' => null, 'lat' => '22.298362', 'lng' => '114.175491', 'walking_distance' => null, 'status' => (int) 0, 'explore_space' => false, 'lease_order' => (int) 9999, 'created' => object(Cake\I18n\FrozenTime) {}, 'modified' => object(Cake\I18n\Time) {}, 'prices' => [ (int) 0 => object(App\Model\Entity\Price) {} ], 'area' => object(App\Model\Entity\Area) {}, 'country' => object(App\Model\Entity\Country) {}, 'office' => object(App\Model\Entity\Office) {}, '_locale' => 'zh_TW', '[new]' => false, '[accessible]' => [ '*' => true, 'id' => false ], '[dirty]' => [], '[original]' => [], '[virtual]' => [], '[errors]' => [], '[invalid]' => [], '[repository]' => 'Leases' } $amenities = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Amenities.id AS `Amenities__id`, Amenities.name AS `Amenities__name`, Amenities.fa_icon AS `Amenities__fa_icon`, Amenities.icon_image AS `Amenities__icon_image`, Amenities.custom_icon AS `Amenities__custom_icon`, Amenities_name_translation.id AS `Amenities_name_translation__id`, Amenities_name_translation.locale AS `Amenities_name_translation__locale`, Amenities_name_translation.model AS `Amenities_name_translation__model`, Amenities_name_translation.foreign_key AS `Amenities_name_translation__foreign_key`, Amenities_name_translation.field AS `Amenities_name_translation__field`, Amenities_name_translation.content AS `Amenities_name_translation__content` FROM amenities Amenities LEFT JOIN i18n Amenities_name_translation ON (Amenities_name_translation.model = :c0 AND Amenities_name_translation.field = :c1 AND Amenities_name_translation.content != :c2 AND Amenities_name_translation.locale = :c3 AND Amenities.id = (Amenities_name_translation.foreign_key))', 'params' => [ ':c0' => [ [maximum depth reached] ], ':c1' => [ [maximum depth reached] ], ':c2' => [ [maximum depth reached] ], ':c3' => [ [maximum depth reached] ] ], 'defaultTypes' => [ 'Amenities__id' => 'integer', 'Amenities.id' => 'integer', 'id' => 'integer', 'Amenities__name' => 'string', 'Amenities.name' => 'string', 'name' => 'string', 'Amenities__fa_icon' => 'string', 'Amenities.fa_icon' => 'string', 'fa_icon' => 'string', 'Amenities__icon_image' => 'text', 'Amenities.icon_image' => 'text', 'icon_image' => 'text', 'Amenities__custom_icon' => 'boolean', 'Amenities.custom_icon' => 'boolean', 'custom_icon' => 'boolean', 'Amenities_name_translation__id' => 'integer', 'Amenities_name_translation.id' => 'integer', 'Amenities_name_translation__locale' => 'string', 'Amenities_name_translation.locale' => 'string', 'locale' => 'string', 'Amenities_name_translation__model' => 'string', 'Amenities_name_translation.model' => 'string', 'model' => 'string', 'Amenities_name_translation__foreign_key' => 'integer', 'Amenities_name_translation.foreign_key' => 'integer', 'foreign_key' => 'integer', 'Amenities_name_translation__field' => 'string', 'Amenities_name_translation.field' => 'string', 'field' => 'string', 'Amenities_name_translation__content' => 'text', 'Amenities_name_translation.content' => 'text', 'content' => 'text' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 1, 'mapReducers' => (int) 0, 'contain' => [ 'Amenities_name_translation' => [ [maximum depth reached] ] ], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\AmenitiesTable) {} } $properties = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Leases.id AS `Leases__id`, Leases.name AS `Leases__name`, Leases.prefix AS `Leases__prefix`, Leases.suffix AS `Leases__suffix`, Leases.slug AS `Leases__slug`, Leases.country_id AS `Leases__country_id`, Leases.area_id AS `Leases__area_id`, Leases.address AS `Leases__address`, Leases.office_type AS `Leases__office_type`, Leases.featured_image AS `Leases__featured_image`, Leases.images AS `Leases__images`, Leases.descriptions AS `Leases__descriptions`, Leases.meta_title AS `Leases__meta_title`, Leases.meta_keywords AS `Leases__meta_keywords`, Leases.meta_descriptions AS `Leases__meta_descriptions`, Leases.og_title AS `Leases__og_title`, Leases.og_type AS `Leases__og_type`, Leases.og_image AS `Leases__og_image`, Leases.amenities AS `Leases__amenities`, Leases.other_amenities AS `Leases__other_amenities`, Leases.space_verified AS `Leases__space_verified`, Leases.featured AS `Leases__featured`, Leases.guest_minimum AS `Leases__guest_minimum`, Leases.guest_maximum AS `Leases__guest_maximum`, Leases.payment_cancellation_policy AS `Leases__payment_cancellation_policy`, Leases.air_con_hours AS `Leases__air_con_hours`, Leases.top_features AS `Leases__top_features`, Leases.current_availability AS `Leases__current_availability`, Leases.lat AS `Leases__lat`, Leases.lng AS `Leases__lng`, Leases.walking_distance AS `Leases__walking_distance`, Leases.status AS `Leases__status`, Leases.explore_space AS `Leases__explore_space`, Leases.lease_order AS `Leases__lease_order`, Leases.created AS `Leases__created`, Leases.modified AS `Leases__modified`, Offices.id AS `Offices__id`, Offices.name AS `Offices__name`, Offices.slug AS `Offices__slug`, Offices.status AS `Offices__status`, Offices.created AS `Offices__created`, Offices.modified AS `Offices__modified`, Areas.id AS `Areas__id`, Areas.name AS `Areas__name`, Areas.slug AS `Areas__slug`, Areas.country_id AS `Areas__country_id`, Areas.state_id AS `Areas__state_id`, Areas.status AS `Areas__status`, Areas.area_order AS `Areas__area_order`, Areas.popular_location AS `Areas__popular_location`, Areas.meta_title AS `Areas__meta_title`, Areas.meta_keywords AS `Areas__meta_keywords`, Areas.meta_descriptions AS `Areas__meta_descriptions`, Areas.og_title AS `Areas__og_title`, Areas.og_type AS `Areas__og_type`, Areas.og_image AS `Areas__og_image`, Areas.modified AS `Areas__modified`, Countries.id AS `Countries__id`, Countries.name AS `Countries__name`, Countries.slug AS `Countries__slug`, Countries.parent_country AS `Countries__parent_country`, Countries.active AS `Countries__active`, Countries.country_order AS `Countries__country_order`, Countries.meta_title AS `Countries__meta_title`, Countries.meta_keywords AS `Countries__meta_keywords`, Countries.meta_descriptions AS `Countries__meta_descriptions`, Countries.og_title AS `Countries__og_title`, Countries.og_type AS `Countries__og_type`, Countries.og_image AS `Countries__og_image`, Countries.modified AS `Countries__modified`, Leases_name_translation.id AS `Leases_name_translation__id`, Leases_name_translation.locale AS `Leases_name_translation__locale`, Leases_name_translation.model AS `Leases_name_translation__model`, Leases_name_translation.foreign_key AS `Leases_name_translation__foreign_key`, Leases_name_translation.field AS `Leases_name_translation__field`, Leases_name_translation.content AS `Leases_name_translation__content`, Leases_prefix_translation.id AS `Leases_prefix_translation__id`, Leases_prefix_translation.locale AS `Leases_prefix_translation__locale`, Leases_prefix_translation.model AS `Leases_prefix_translation__model`, Leases_prefix_translation.foreign_key AS `Leases_prefix_translation__foreign_key`, Leases_prefix_translation.field AS `Leases_prefix_translation__field`, Leases_prefix_translation.content AS `Leases_prefix_translation__content`, Leases_suffix_translation.id AS `Leases_suffix_translation__id`, Leases_suffix_translation.locale AS `Leases_suffix_translation__locale`, Leases_suffix_translation.model AS `Leases_suffix_translation__model`, Leases_suffix_translation.foreign_key AS `Leases_suffix_translation__foreign_key`, Leases_suffix_translation.field AS `Leases_suffix_translation__field`, Leases_suffix_translation.content AS `Leases_suffix_translation__content`, Leases_address_translation.id AS `Leases_address_translation__id`, Leases_address_translation.locale AS `Leases_address_translation__locale`, Leases_address_translation.model AS `Leases_address_translation__model`, Leases_address_translation.foreign_key AS `Leases_address_translation__foreign_key`, Leases_address_translation.field AS `Leases_address_translation__field`, Leases_address_translation.content AS `Leases_address_translation__content`, Leases_descriptions_translation.id AS `Leases_descriptions_translation__id`, Leases_descriptions_translation.locale AS `Leases_descriptions_translation__locale`, Leases_descriptions_translation.model AS `Leases_descriptions_translation__model`, Leases_descriptions_translation.foreign_key AS `Leases_descriptions_translation__foreign_key`, Leases_descriptions_translation.field AS `Leases_descriptions_translation__field`, Leases_descriptions_translation.content AS `Leases_descriptions_translation__content`, Leases_meta_title_translation.id AS `Leases_meta_title_translation__id`, Leases_meta_title_translation.locale AS `Leases_meta_title_translation__locale`, Leases_meta_title_translation.model AS `Leases_meta_title_translation__model`, Leases_meta_title_translation.foreign_key AS `Leases_meta_title_translation__foreign_key`, Leases_meta_title_translation.field AS `Leases_meta_title_translation__field`, Leases_meta_title_translation.content AS `Leases_meta_title_translation__content`, Leases_meta_keywords_translation.id AS `Leases_meta_keywords_translation__id`, Leases_meta_keywords_translation.locale AS `Leases_meta_keywords_translation__locale`, Leases_meta_keywords_translation.model AS `Leases_meta_keywords_translation__model`, Leases_meta_keywords_translation.foreign_key AS `Leases_meta_keywords_translation__foreign_key`, Leases_meta_keywords_translation.field AS `Leases_meta_keywords_translation__field`, Leases_meta_keywords_translation.content AS `Leases_meta_keywords_translation__content`, Leases_meta_descriptions_translation.id AS `Leases_meta_descriptions_translation__id`, Leases_meta_descriptions_translation.locale AS `Leases_meta_descriptions_translation__locale`, Leases_meta_descriptions_translation.model AS `Leases_meta_descriptions_translation__model`, Leases_meta_descriptions_translation.foreign_key AS `Leases_meta_descriptions_translation__foreign_key`, Leases_meta_descriptions_translation.field AS `Leases_meta_descriptions_translation__field`, Leases_meta_descriptions_translation.content AS `Leases_meta_descriptions_translation__content`, Leases_og_title_translation.id AS `Leases_og_title_translation__id`, Leases_og_title_translation.locale AS `Leases_og_title_translation__locale`, Leases_og_title_translation.model AS `Leases_og_title_translation__model`, Leases_og_title_translation.foreign_key AS `Leases_og_title_translation__foreign_key`, Leases_og_title_translation.field AS `Leases_og_title_translation__field`, Leases_og_title_translation.content AS `Leases_og_title_translation__content`, Leases_og_type_translation.id AS `Leases_og_type_translation__id`, Leases_og_type_translation.locale AS `Leases_og_type_translation__locale`, Leases_og_type_translation.model AS `Leases_og_type_translation__model`, Leases_og_type_translation.foreign_key AS `Leases_og_type_translation__foreign_key`, Leases_og_type_translation.field AS `Leases_og_type_translation__field`, Leases_og_type_translation.content AS `Leases_og_type_translation__content`, Leases_top_features_translation.id AS `Leases_top_features_translation__id`, Leases_top_features_translation.locale AS `Leases_top_features_translation__locale`, Leases_top_features_translation.model AS `Leases_top_features_translation__model`, Leases_top_features_translation.foreign_key AS `Leases_top_features_translation__foreign_key`, Leases_top_features_translation.field AS `Leases_top_features_translation__field`, Leases_top_features_translation.content AS `Leases_top_features_translation__content`, Leases_current_availability_translation.id AS `Leases_current_availability_translation__id`, Leases_current_availability_translation.locale AS `Leases_current_availability_translation__locale`, Leases_current_availability_translation.model AS `Leases_current_availability_translation__model`, Leases_current_availability_translation.foreign_key AS `Leases_current_availability_translation__foreign_key`, Leases_current_availability_translation.field AS `Leases_current_availability_translation__field`, Leases_current_availability_translation.content AS `Leases_current_availability_translation__content`, Leases_walking_distance_translation.id AS `Leases_walking_distance_translation__id`, Leases_walking_distance_translation.locale AS `Leases_walking_distance_translation__locale`, Leases_walking_distance_translation.model AS `Leases_walking_distance_translation__model`, Leases_walking_distance_translation.foreign_key AS `Leases_walking_distance_translation__foreign_key`, Leases_walking_distance_translation.field AS `Leases_walking_distance_translation__field`, Leases_walking_distance_translation.content AS `Leases_walking_distance_translation__content`, Offices_name_translation.id AS `Offices_name_translation__id`, Offices_name_translation.locale AS `Offices_name_translation__locale`, Offices_name_translation.model AS `Offices_name_translation__model`, Offices_name_translation.foreign_key AS `Offices_name_translation__foreign_key`, Offices_name_translation.field AS `Offices_name_translation__field`, Offices_name_translation.content AS `Offices_name_translation__content`, Areas_name_translation.id AS `Areas_name_translation__id`, Areas_name_translation.locale AS `Areas_name_translation__locale`, Areas_name_translation.model AS `Areas_name_translation__model`, Areas_name_translation.foreign_key AS `Areas_name_translation__foreign_key`, Areas_name_translation.field AS `Areas_name_translation__field`, Areas_name_translation.content AS `Areas_name_translation__content`, Areas_meta_title_translation.id AS `Areas_meta_title_translation__id`, Areas_meta_title_translation.locale AS `Areas_meta_title_translation__locale`, Areas_meta_title_translation.model AS `Areas_meta_title_translation__model`, Areas_meta_title_translation.foreign_key AS `Areas_meta_title_translation__foreign_key`, Areas_meta_title_translation.field AS `Areas_meta_title_translation__field`, Areas_meta_title_translation.content AS `Areas_meta_title_translation__content`, Areas_meta_keywords_translation.id AS `Areas_meta_keywords_translation__id`, Areas_meta_keywords_translation.locale AS `Areas_meta_keywords_translation__locale`, Areas_meta_keywords_translation.model AS `Areas_meta_keywords_translation__model`, Areas_meta_keywords_translation.foreign_key AS `Areas_meta_keywords_translation__foreign_key`, Areas_meta_keywords_translation.field AS `Areas_meta_keywords_translation__field`, Areas_meta_keywords_translation.content AS `Areas_meta_keywords_translation__content`, Areas_meta_descriptions_translation.id AS `Areas_meta_descriptions_translation__id`, Areas_meta_descriptions_translation.locale AS `Areas_meta_descriptions_translation__locale`, Areas_meta_descriptions_translation.model AS `Areas_meta_descriptions_translation__model`, Areas_meta_descriptions_translation.foreign_key AS `Areas_meta_descriptions_translation__foreign_key`, Areas_meta_descriptions_translation.field AS `Areas_meta_descriptions_translation__field`, Areas_meta_descriptions_translation.content AS `Areas_meta_descriptions_translation__content`, Areas_og_title_translation.id AS `Areas_og_title_translation__id`, Areas_og_title_translation.locale AS `Areas_og_title_translation__locale`, Areas_og_title_translation.model AS `Areas_og_title_translation__model`, Areas_og_title_translation.foreign_key AS `Areas_og_title_translation__foreign_key`, Areas_og_title_translation.field AS `Areas_og_title_translation__field`, Areas_og_title_translation.content AS `Areas_og_title_translation__content`, Areas_og_type_translation.id AS `Areas_og_type_translation__id`, Areas_og_type_translation.locale AS `Areas_og_type_translation__locale`, Areas_og_type_translation.model AS `Areas_og_type_translation__model`, Areas_og_type_translation.foreign_key AS `Areas_og_type_translation__foreign_key`, Areas_og_type_translation.field AS `Areas_og_type_translation__field`, Areas_og_type_translation.content AS `Areas_og_type_translation__content`, Countries_name_translation.id AS `Countries_name_translation__id`, Countries_name_translation.locale AS `Countries_name_translation__locale`, Countries_name_translation.model AS `Countries_name_translation__model`, Countries_name_translation.foreign_key AS `Countries_name_translation__foreign_key`, Countries_name_translation.field AS `Countries_name_translation__field`, Countries_name_translation.content AS `Countries_name_translation__content`, Countries_meta_title_translation.id AS `Countries_meta_title_translation__id`, Countries_meta_title_translation.locale AS `Countries_meta_title_translation__locale`, Countries_meta_title_translation.model AS `Countries_meta_title_translation__model`, Countries_meta_title_translation.foreign_key AS `Countries_meta_title_translation__foreign_key`, Countries_meta_title_translation.field AS `Countries_meta_title_translation__field`, Countries_meta_title_translation.content AS `Countries_meta_title_translation__content`, Countries_meta_keywords_translation.id AS `Countries_meta_keywords_translation__id`, Countries_meta_keywords_translation.locale AS `Countries_meta_keywords_translation__locale`, Countries_meta_keywords_translation.model AS `Countries_meta_keywords_translation__model`, Countries_meta_keywords_translation.foreign_key AS `Countries_meta_keywords_translation__foreign_key`, Countries_meta_keywords_translation.field AS `Countries_meta_keywords_translation__field`, Countries_meta_keywords_translation.content AS `Countries_meta_keywords_translation__content`, Countries_meta_descriptions_translation.id AS `Countries_meta_descriptions_translation__id`, Countries_meta_descriptions_translation.locale AS `Countries_meta_descriptions_translation__locale`, Countries_meta_descriptions_translation.model AS `Countries_meta_descriptions_translation__model`, Countries_meta_descriptions_translation.foreign_key AS `Countries_meta_descriptions_translation__foreign_key`, Countries_meta_descriptions_translation.field AS `Countries_meta_descriptions_translation__field`, Countries_meta_descriptions_translation.content AS `Countries_meta_descriptions_translation__content`, Countries_og_title_translation.id AS `Countries_og_title_translation__id`, Countries_og_title_translation.locale AS `Countries_og_title_translation__locale`, Countries_og_title_translation.model AS `Countries_og_title_translation__model`, Countries_og_title_translation.foreign_key AS `Countries_og_title_translation__foreign_key`, Countries_og_title_translation.field AS `Countries_og_title_translation__field`, Countries_og_title_translation.content AS `Countries_og_title_translation__content`, Countries_og_type_translation.id AS `Countries_og_type_translation__id`, Countries_og_type_translation.locale AS `Countries_og_type_translation__locale`, Countries_og_type_translation.model AS `Countries_og_type_translation__model`, Countries_og_type_translation.foreign_key AS `Countries_og_type_translation__foreign_key`, Countries_og_type_translation.field AS `Countries_og_type_translation__field`, Countries_og_type_translation.content AS `Countries_og_type_translation__content` FROM leases Leases INNER JOIN prices Prices ON (Prices.lease_id = Leases.id AND Prices.price_type_id = 3) INNER JOIN offices Offices ON Offices.id = (Leases.office_type) INNER JOIN areas Areas ON Areas.id = (Leases.area_id) INNER JOIN countries Countries ON Countries.id = (Leases.country_id) LEFT JOIN i18n Leases_name_translation ON (Leases_name_translation.model = :c0 AND Leases_name_translation.field = :c1 AND Leases_name_translation.content != :c2 AND Leases_name_translation.locale = :c3 AND Leases.id = (Leases_name_translation.foreign_key)) LEFT JOIN i18n Leases_prefix_translation ON (Leases_prefix_translation.model = :c4 AND Leases_prefix_translation.field = :c5 AND Leases_prefix_translation.content != :c6 AND Leases_prefix_translation.locale = :c7 AND Leases.id = (Leases_prefix_translation.foreign_key)) LEFT JOIN i18n Leases_suffix_translation ON (Leases_suffix_translation.model = :c8 AND Leases_suffix_translation.field = :c9 AND Leases_suffix_translation.content != :c10 AND Leases_suffix_translation.locale = :c11 AND Leases.id = (Leases_suffix_translation.foreign_key)) LEFT JOIN i18n Leases_address_translation ON (Leases_address_translation.model = :c12 AND Leases_address_translation.field = :c13 AND Leases_address_translation.content != :c14 AND Leases_address_translation.locale = :c15 AND Leases.id = (Leases_address_translation.foreign_key)) LEFT JOIN i18n Leases_descriptions_translation ON (Leases_descriptions_translation.model = :c16 AND Leases_descriptions_translation.field = :c17 AND Leases_descriptions_translation.content != :c18 AND Leases_descriptions_translation.locale = :c19 AND Leases.id = (Leases_descriptions_translation.foreign_key)) LEFT JOIN i18n Leases_meta_title_translation ON (Leases_meta_title_translation.model = :c20 AND Leases_meta_title_translation.field = :c21 AND Leases_meta_title_translation.content != :c22 AND Leases_meta_title_translation.locale = :c23 AND Leases.id = (Leases_meta_title_translation.foreign_key)) LEFT JOIN i18n Leases_meta_keywords_translation ON (Leases_meta_keywords_translation.model = :c24 AND Leases_meta_keywords_translation.field = :c25 AND Leases_meta_keywords_translation.content != :c26 AND Leases_meta_keywords_translation.locale = :c27 AND Leases.id = (Leases_meta_keywords_translation.foreign_key)) LEFT JOIN i18n Leases_meta_descriptions_translation ON (Leases_meta_descriptions_translation.model = :c28 AND Leases_meta_descriptions_translation.field = :c29 AND Leases_meta_descriptions_translation.content != :c30 AND Leases_meta_descriptions_translation.locale = :c31 AND Leases.id = (Leases_meta_descriptions_translation.foreign_key)) LEFT JOIN i18n Leases_og_title_translation ON (Leases_og_title_translation.model = :c32 AND Leases_og_title_translation.field = :c33 AND Leases_og_title_translation.content != :c34 AND Leases_og_title_translation.locale = :c35 AND Leases.id = (Leases_og_title_translation.foreign_key)) LEFT JOIN i18n Leases_og_type_translation ON (Leases_og_type_translation.model = :c36 AND Leases_og_type_translation.field = :c37 AND Leases_og_type_translation.content != :c38 AND Leases_og_type_translation.locale = :c39 AND Leases.id = (Leases_og_type_translation.foreign_key)) LEFT JOIN i18n Leases_top_features_translation ON (Leases_top_features_translation.model = :c40 AND Leases_top_features_translation.field = :c41 AND Leases_top_features_translation.content != :c42 AND Leases_top_features_translation.locale = :c43 AND Leases.id = (Leases_top_features_translation.foreign_key)) LEFT JOIN i18n Leases_current_availability_translation ON (Leases_current_availability_translation.model = :c44 AND Leases_current_availability_translation.field = :c45 AND Leases_current_availability_translation.content != :c46 AND Leases_current_availability_translation.locale = :c47 AND Leases.id = (Leases_current_availability_translation.foreign_key)) LEFT JOIN i18n Leases_walking_distance_translation ON (Leases_walking_distance_translation.model = :c48 AND Leases_walking_distance_translation.field = :c49 AND Leases_walking_distance_translation.content != :c50 AND Leases_walking_distance_translation.locale = :c51 AND Leases.id = (Leases_walking_distance_translation.foreign_key)) LEFT JOIN i18n Offices_name_translation ON (Offices_name_translation.model = :c52 AND Offices_name_translation.field = :c53 AND Offices_name_translation.content != :c54 AND Offices_name_translation.locale = :c55 AND Offices.id = (Offices_name_translation.foreign_key)) LEFT JOIN i18n Areas_name_translation ON (Areas_name_translation.model = :c56 AND Areas_name_translation.field = :c57 AND Areas_name_translation.content != :c58 AND Areas_name_translation.locale = :c59 AND Areas.id = (Areas_name_translation.foreign_key)) LEFT JOIN i18n Areas_meta_title_translation ON (Areas_meta_title_translation.model = :c60 AND Areas_meta_title_translation.field = :c61 AND Areas_meta_title_translation.content != :c62 AND Areas_meta_title_translation.locale = :c63 AND Areas.id = (Areas_meta_title_translation.foreign_key)) LEFT JOIN i18n Areas_meta_keywords_translation ON (Areas_meta_keywords_translation.model = :c64 AND Areas_meta_keywords_translation.field = :c65 AND Areas_meta_keywords_translation.content != :c66 AND Areas_meta_keywords_translation.locale = :c67 AND Areas.id = (Areas_meta_keywords_translation.foreign_key)) LEFT JOIN i18n Areas_meta_descriptions_translation ON (Areas_meta_descriptions_translation.model = :c68 AND Areas_meta_descriptions_translation.field = :c69 AND Areas_meta_descriptions_translation.content != :c70 AND Areas_meta_descriptions_translation.locale = :c71 AND Areas.id = (Areas_meta_descriptions_translation.foreign_key)) LEFT JOIN i18n Areas_og_title_translation ON (Areas_og_title_translation.model = :c72 AND Areas_og_title_translation.field = :c73 AND Areas_og_title_translation.content != :c74 AND Areas_og_title_translation.locale = :c75 AND Areas.id = (Areas_og_title_translation.foreign_key)) LEFT JOIN i18n Areas_og_type_translation ON (Areas_og_type_translation.model = :c76 AND Areas_og_type_translation.field = :c77 AND Areas_og_type_translation.content != :c78 AND Areas_og_type_translation.locale = :c79 AND Areas.id = (Areas_og_type_translation.foreign_key)) LEFT JOIN i18n Countries_name_translation ON (Countries_name_translation.model = :c80 AND Countries_name_translation.field = :c81 AND Countries_name_translation.content != :c82 AND Countries_name_translation.locale = :c83 AND Countries.id = (Countries_name_translation.foreign_key)) LEFT JOIN i18n Countries_meta_title_translation ON (Countries_meta_title_translation.model = :c84 AND Countries_meta_title_translation.field = :c85 AND Countries_meta_title_translation.content != :c86 AND Countries_meta_title_translation.locale = :c87 AND Countries.id = (Countries_meta_title_translation.foreign_key)) LEFT JOIN i18n Countries_meta_keywords_translation ON (Countries_meta_keywords_translation.model = :c88 AND Countries_meta_keywords_translation.field = :c89 AND Countries_meta_keywords_translation.content != :c90 AND Countries_meta_keywords_translation.locale = :c91 AND Countries.id = (Countries_meta_keywords_translation.foreign_key)) LEFT JOIN i18n Countries_meta_descriptions_translation ON (Countries_meta_descriptions_translation.model = :c92 AND Countries_meta_descriptions_translation.field = :c93 AND Countries_meta_descriptions_translation.content != :c94 AND Countries_meta_descriptions_translation.locale = :c95 AND Countries.id = (Countries_meta_descriptions_translation.foreign_key)) LEFT JOIN i18n Countries_og_title_translation ON (Countries_og_title_translation.model = :c96 AND Countries_og_title_translation.field = :c97 AND Countries_og_title_translation.content != :c98 AND Countries_og_title_translation.locale = :c99 AND Countries.id = (Countries_og_title_translation.foreign_key)) LEFT JOIN i18n Countries_og_type_translation ON (Countries_og_type_translation.model = :c100 AND Countries_og_type_translation.field = :c101 AND Countries_og_type_translation.content != :c102 AND Countries_og_type_translation.locale = :c103 AND Countries.id = (Countries_og_type_translation.foreign_key)) WHERE (Leases.country_id = :c104 AND Leases.area_id = :c105 AND Leases.id != :c106 AND Leases.status = :c107) GROUP BY Leases.id ', 'params' => [ ':c0' => [ [maximum depth reached] ], ':c1' => [ [maximum depth reached] ], ':c2' => [ [maximum depth reached] ], ':c3' => [ [maximum depth reached] ], ':c4' => [ [maximum depth reached] ], ':c5' => [ [maximum depth reached] ], ':c6' => [ [maximum depth reached] ], ':c7' => [ [maximum depth reached] ], ':c8' => [ [maximum depth reached] ], ':c9' => [ [maximum depth reached] ], ':c10' => [ [maximum depth reached] ], ':c11' => [ [maximum depth reached] ], ':c12' => [ [maximum depth reached] ], ':c13' => [ [maximum depth reached] ], ':c14' => [ [maximum depth reached] ], ':c15' => [ [maximum depth reached] ], ':c16' => [ [maximum depth reached] ], ':c17' => [ [maximum depth reached] ], ':c18' => [ [maximum depth reached] ], ':c19' => [ [maximum depth reached] ], ':c20' => [ [maximum depth reached] ], ':c21' => [ [maximum depth reached] ], ':c22' => [ [maximum depth reached] ], ':c23' => [ [maximum depth reached] ], ':c24' => [ [maximum depth reached] ], ':c25' => [ [maximum depth reached] ], ':c26' => [ [maximum depth reached] ], ':c27' => [ [maximum depth reached] ], ':c28' => [ [maximum depth reached] ], ':c29' => [ [maximum depth reached] ], ':c30' => [ [maximum depth reached] ], ':c31' => [ [maximum depth reached] ], ':c32' => [ [maximum depth reached] ], ':c33' => [ [maximum depth reached] ], ':c34' => [ [maximum depth reached] ], ':c35' => [ [maximum depth reached] ], ':c36' => [ [maximum depth reached] ], ':c37' => [ [maximum depth reached] ], ':c38' => [ [maximum depth reached] ], ':c39' => [ [maximum depth reached] ], ':c40' => [ [maximum depth reached] ], ':c41' => [ [maximum depth reached] ], ':c42' => [ [maximum depth reached] ], ':c43' => [ [maximum depth reached] ], ':c44' => [ [maximum depth reached] ], ':c45' => [ [maximum depth reached] ], ':c46' => [ [maximum depth reached] ], ':c47' => [ [maximum depth reached] ], ':c48' => [ [maximum depth reached] ], ':c49' => [ [maximum depth reached] ], ':c50' => [ [maximum depth reached] ], ':c51' => [ [maximum depth reached] ], ':c52' => [ [maximum depth reached] ], ':c53' => [ [maximum depth reached] ], ':c54' => [ [maximum depth reached] ], ':c55' => [ [maximum depth reached] ], ':c56' => [ [maximum depth reached] ], ':c57' => [ [maximum depth reached] ], ':c58' => [ [maximum depth reached] ], ':c59' => [ [maximum depth reached] ], ':c60' => [ [maximum depth reached] ], ':c61' => [ [maximum depth reached] ], ':c62' => [ [maximum depth reached] ], ':c63' => [ [maximum depth reached] ], ':c64' => [ [maximum depth reached] ], ':c65' => [ [maximum depth reached] ], ':c66' => [ [maximum depth reached] ], ':c67' => [ [maximum depth reached] ], ':c68' => [ [maximum depth reached] ], ':c69' => [ [maximum depth reached] ], ':c70' => [ [maximum depth reached] ], ':c71' => [ [maximum depth reached] ], ':c72' => [ [maximum depth reached] ], ':c73' => [ [maximum depth reached] ], ':c74' => [ [maximum depth reached] ], ':c75' => [ [maximum depth reached] ], ':c76' => [ [maximum depth reached] ], ':c77' => [ [maximum depth reached] ], ':c78' => [ [maximum depth reached] ], ':c79' => [ [maximum depth reached] ], ':c80' => [ [maximum depth reached] ], ':c81' => [ [maximum depth reached] ], ':c82' => [ [maximum depth reached] ], ':c83' => [ [maximum depth reached] ], ':c84' => [ [maximum depth reached] ], ':c85' => [ [maximum depth reached] ], ':c86' => [ [maximum depth reached] ], ':c87' => [ [maximum depth reached] ], ':c88' => [ [maximum depth reached] ], ':c89' => [ [maximum depth reached] ], ':c90' => [ [maximum depth reached] ], ':c91' => [ [maximum depth reached] ], ':c92' => [ [maximum depth reached] ], ':c93' => [ [maximum depth reached] ], ':c94' => [ [maximum depth reached] ], ':c95' => [ [maximum depth reached] ], ':c96' => [ [maximum depth reached] ], ':c97' => [ [maximum depth reached] ], ':c98' => [ [maximum depth reached] ], ':c99' => [ [maximum depth reached] ], ':c100' => [ [maximum depth reached] ], ':c101' => [ [maximum depth reached] ], ':c102' => [ [maximum depth reached] ], ':c103' => [ [maximum depth reached] ], ':c104' => [ [maximum depth reached] ], ':c105' => [ [maximum depth reached] ], ':c106' => [ [maximum depth reached] ], ':c107' => [ [maximum depth reached] ] ], 'defaultTypes' => [ 'Leases__id' => 'integer', 'Leases.id' => 'integer', 'id' => 'integer', 'Leases__name' => 'string', 'Leases.name' => 'string', 'name' => 'string', 'Leases__prefix' => 'string', 'Leases.prefix' => 'string', 'prefix' => 'string', 'Leases__suffix' => 'string', 'Leases.suffix' => 'string', 'suffix' => 'string', 'Leases__slug' => 'string', 'Leases.slug' => 'string', 'slug' => 'string', 'Leases__country_id' => 'integer', 'Leases.country_id' => 'integer', 'country_id' => 'integer', 'Leases__area_id' => 'integer', 'Leases.area_id' => 'integer', 'area_id' => 'integer', 'Leases__address' => 'text', 'Leases.address' => 'text', 'address' => 'text', 'Leases__office_type' => 'integer', 'Leases.office_type' => 'integer', 'office_type' => 'integer', 'Leases__featured_image' => 'text', 'Leases.featured_image' => 'text', 'featured_image' => 'text', 'Leases__images' => 'text', 'Leases.images' => 'text', 'images' => 'text', 'Leases__descriptions' => 'text', 'Leases.descriptions' => 'text', 'descriptions' => 'text', 'Leases__meta_title' => 'string', 'Leases.meta_title' => 'string', 'meta_title' => 'string', 'Leases__meta_keywords' => 'string', 'Leases.meta_keywords' => 'string', 'meta_keywords' => 'string', 'Leases__meta_descriptions' => 'text', 'Leases.meta_descriptions' => 'text', 'meta_descriptions' => 'text', 'Leases__og_title' => 'string', 'Leases.og_title' => 'string', 'og_title' => 'string', 'Leases__og_type' => 'string', 'Leases.og_type' => 'string', 'og_type' => 'string', 'Leases__og_image' => 'string', 'Leases.og_image' => 'string', 'og_image' => 'string', 'Leases__amenities' => 'text', 'Leases.amenities' => 'text', 'amenities' => 'text', 'Leases__other_amenities' => 'text', 'Leases.other_amenities' => 'text', 'other_amenities' => 'text', 'Leases__space_verified' => 'integer', 'Leases.space_verified' => 'integer', 'space_verified' => 'integer', 'Leases__featured' => 'integer', 'Leases.featured' => 'integer', 'featured' => 'integer', 'Leases__guest_minimum' => 'integer', 'Leases.guest_minimum' => 'integer', 'guest_minimum' => 'integer', 'Leases__guest_maximum' => 'integer', 'Leases.guest_maximum' => 'integer', 'guest_maximum' => 'integer', 'Leases__payment_cancellation_policy' => 'text', 'Leases.payment_cancellation_policy' => 'text', 'payment_cancellation_policy' => 'text', 'Leases__air_con_hours' => 'text', 'Leases.air_con_hours' => 'text', 'air_con_hours' => 'text', 'Leases__top_features' => 'text', 'Leases.top_features' => 'text', 'top_features' => 'text', 'Leases__current_availability' => 'text', 'Leases.current_availability' => 'text', 'current_availability' => 'text', 'Leases__lat' => 'string', 'Leases.lat' => 'string', 'lat' => 'string', 'Leases__lng' => 'string', 'Leases.lng' => 'string', 'lng' => 'string', 'Leases__walking_distance' => 'string', 'Leases.walking_distance' => 'string', 'walking_distance' => 'string', 'Leases__status' => 'integer', 'Leases.status' => 'integer', 'status' => 'integer', 'Leases__explore_space' => 'boolean', 'Leases.explore_space' => 'boolean', 'explore_space' => 'boolean', 'Leases__lease_order' => 'integer', 'Leases.lease_order' => 'integer', 'lease_order' => 'integer', 'Leases__created' => 'datetime', 'Leases.created' => 'datetime', 'created' => 'datetime', 'Leases__modified' => 'timestamp', 'Leases.modified' => 'timestamp', 'modified' => 'timestamp', 'Prices__id' => 'integer', 'Prices.id' => 'integer', 'Prices__price_type_id' => 'integer', 'Prices.price_type_id' => 'integer', 'price_type_id' => 'integer', 'Prices__currency_type' => 'integer', 'Prices.currency_type' => 'integer', 'currency_type' => 'integer', 'Prices__lease_id' => 'integer', 'Prices.lease_id' => 'integer', 'lease_id' => 'integer', 'Prices__price' => 'integer', 'Prices.price' => 'integer', 'price' => 'integer', 'Prices__modified' => 'timestamp', 'Prices.modified' => 'timestamp', 'Currencies__id' => 'integer', 'Currencies.id' => 'integer', 'Currencies__country_id' => 'integer', 'Currencies.country_id' => 'integer', 'Currencies__name' => 'string', 'Currencies.name' => 'string', 'Currencies__code' => 'string', 'Currencies.code' => 'string', 'code' => 'string', 'Currencies__symbol' => 'string', 'Currencies.symbol' => 'string', 'symbol' => 'string', 'Currencies__show_after' => 'integer', 'Currencies.show_after' => 'integer', 'show_after' => 'integer', 'Currencies__status' => 'boolean', 'Currencies.status' => 'boolean', 'Offices__id' => 'integer', 'Offices.id' => 'integer', 'Offices__name' => 'string', 'Offices.name' => 'string', 'Offices__slug' => 'string', 'Offices.slug' => 'string', 'Offices__status' => 'integer', 'Offices.status' => 'integer', 'Offices__created' => 'datetime', 'Offices.created' => 'datetime', 'Offices__modified' => 'timestamp', 'Offices.modified' => 'timestamp', 'Areas__id' => 'integer', 'Areas.id' => 'integer', 'Areas__name' => 'string', 'Areas.name' => 'string', 'Areas__slug' => 'string', 'Areas.slug' => 'string', 'Areas__country_id' => 'integer', 'Areas.country_id' => 'integer', 'Areas__state_id' => 'integer', 'Areas.state_id' => 'integer', 'state_id' => 'integer', 'Areas__status' => 'integer', 'Areas.status' => 'integer', 'Areas__area_order' => 'integer', 'Areas.area_order' => 'integer', 'area_order' => 'integer', 'Areas__popular_location' => 'integer', 'Areas.popular_location' => 'integer', 'popular_location' => 'integer', 'Areas__meta_title' => 'string', 'Areas.meta_title' => 'string', 'Areas__meta_keywords' => 'string', 'Areas.meta_keywords' => 'string', 'Areas__meta_descriptions' => 'text', 'Areas.meta_descriptions' => 'text', 'Areas__og_title' => 'string', 'Areas.og_title' => 'string', 'Areas__og_type' => 'string', 'Areas.og_type' => 'string', 'Areas__og_image' => 'text', 'Areas.og_image' => 'text', 'Areas__modified' => 'timestamp', 'Areas.modified' => 'timestamp', 'Countries__id' => 'integer', 'Countries.id' => 'integer', 'Countries__name' => 'string', 'Countries.name' => 'string', 'Countries__slug' => 'string', 'Countries.slug' => 'string', 'Countries__parent_country' => 'integer', 'Countries.parent_country' => 'integer', 'parent_country' => 'integer', 'Countries__active' => 'integer', 'Countries.active' => 'integer', 'active' => 'integer', 'Countries__country_order' => 'integer', 'Countries.country_order' => 'integer', 'country_order' => 'integer', 'Countries__meta_title' => 'string', 'Countries.meta_title' => 'string', 'Countries__meta_keywords' => 'string', 'Countries.meta_keywords' => 'string', 'Countries__meta_descriptions' => 'text', 'Countries.meta_descriptions' => 'text', 'Countries__og_title' => 'string', 'Countries.og_title' => 'string', 'Countries__og_type' => 'string', 'Countries.og_type' => 'string', 'Countries__og_image' => 'text', 'Countries.og_image' => 'text', 'Countries__modified' => 'timestamp', 'Countries.modified' => 'timestamp', 'Leases_name_translation__id' => 'integer', 'Leases_name_translation.id' => 'integer', 'Leases_name_translation__locale' => 'string', 'Leases_name_translation.locale' => 'string', 'locale' => 'string', 'Leases_name_translation__model' => 'string', 'Leases_name_translation.model' => 'string', 'model' => 'string', 'Leases_name_translation__foreign_key' => 'integer', 'Leases_name_translation.foreign_key' => 'integer', 'foreign_key' => 'integer', 'Leases_name_translation__field' => 'string', 'Leases_name_translation.field' => 'string', 'field' => 'string', 'Leases_name_translation__content' => 'text', 'Leases_name_translation.content' => 'text', 'content' => 'text', 'Leases_prefix_translation__id' => 'integer', 'Leases_prefix_translation.id' => 'integer', 'Leases_prefix_translation__locale' => 'string', 'Leases_prefix_translation.locale' => 'string', 'Leases_prefix_translation__model' => 'string', 'Leases_prefix_translation.model' => 'string', 'Leases_prefix_translation__foreign_key' => 'integer', 'Leases_prefix_translation.foreign_key' => 'integer', 'Leases_prefix_translation__field' => 'string', 'Leases_prefix_translation.field' => 'string', 'Leases_prefix_translation__content' => 'text', 'Leases_prefix_translation.content' => 'text', 'Leases_suffix_translation__id' => 'integer', 'Leases_suffix_translation.id' => 'integer', 'Leases_suffix_translation__locale' => 'string', 'Leases_suffix_translation.locale' => 'string', 'Leases_suffix_translation__model' => 'string', 'Leases_suffix_translation.model' => 'string', 'Leases_suffix_translation__foreign_key' => 'integer', 'Leases_suffix_translation.foreign_key' => 'integer', 'Leases_suffix_translation__field' => 'string', 'Leases_suffix_translation.field' => 'string', 'Leases_suffix_translation__content' => 'text', 'Leases_suffix_translation.content' => 'text', 'Leases_address_translation__id' => 'integer', 'Leases_address_translation.id' => 'integer', 'Leases_address_translation__locale' => 'string', 'Leases_address_translation.locale' => 'string', 'Leases_address_translation__model' => 'string', 'Leases_address_translation.model' => 'string', 'Leases_address_translation__foreign_key' => 'integer', 'Leases_address_translation.foreign_key' => 'integer', 'Leases_address_translation__field' => 'string', 'Leases_address_translation.field' => 'string', 'Leases_address_translation__content' => 'text', 'Leases_address_translation.content' => 'text', 'Leases_descriptions_translation__id' => 'integer', 'Leases_descriptions_translation.id' => 'integer', 'Leases_descriptions_translation__locale' => 'string', 'Leases_descriptions_translation.locale' => 'string', 'Leases_descriptions_translation__model' => 'string', 'Leases_descriptions_translation.model' => 'string', 'Leases_descriptions_translation__foreign_key' => 'integer', 'Leases_descriptions_translation.foreign_key' => 'integer', 'Leases_descriptions_translation__field' => 'string', 'Leases_descriptions_translation.field' => 'string', 'Leases_descriptions_translation__content' => 'text', 'Leases_descriptions_translation.content' => 'text', 'Leases_meta_title_translation__id' => 'integer', 'Leases_meta_title_translation.id' => 'integer', 'Leases_meta_title_translation__locale' => 'string', 'Leases_meta_title_translation.locale' => 'string', 'Leases_meta_title_translation__model' => 'string', 'Leases_meta_title_translation.model' => 'string', 'Leases_meta_title_translation__foreign_key' => 'integer', 'Leases_meta_title_translation.foreign_key' => 'integer', 'Leases_meta_title_translation__field' => 'string', 'Leases_meta_title_translation.field' => 'string', 'Leases_meta_title_translation__content' => 'text', 'Leases_meta_title_translation.content' => 'text', 'Leases_meta_keywords_translation__id' => 'integer', 'Leases_meta_keywords_translation.id' => 'integer', 'Leases_meta_keywords_translation__locale' => 'string', 'Leases_meta_keywords_translation.locale' => 'string', 'Leases_meta_keywords_translation__model' => 'string', 'Leases_meta_keywords_translation.model' => 'string', 'Leases_meta_keywords_translation__foreign_key' => 'integer', 'Leases_meta_keywords_translation.foreign_key' => 'integer', 'Leases_meta_keywords_translation__field' => 'string', 'Leases_meta_keywords_translation.field' => 'string', 'Leases_meta_keywords_translation__content' => 'text', 'Leases_meta_keywords_translation.content' => 'text', 'Leases_meta_descriptions_translation__id' => 'integer', 'Leases_meta_descriptions_translation.id' => 'integer', 'Leases_meta_descriptions_translation__locale' => 'string', 'Leases_meta_descriptions_translation.locale' => 'string', 'Leases_meta_descriptions_translation__model' => 'string', 'Leases_meta_descriptions_translation.model' => 'string', 'Leases_meta_descriptions_translation__foreign_key' => 'integer', 'Leases_meta_descriptions_translation.foreign_key' => 'integer', 'Leases_meta_descriptions_translation__field' => 'string', 'Leases_meta_descriptions_translation.field' => 'string', 'Leases_meta_descriptions_translation__content' => 'text', 'Leases_meta_descriptions_translation.content' => 'text', 'Leases_og_title_translation__id' => 'integer', 'Leases_og_title_translation.id' => 'integer', 'Leases_og_title_translation__locale' => 'string', 'Leases_og_title_translation.locale' => 'string', 'Leases_og_title_translation__model' => 'string', 'Leases_og_title_translation.model' => 'string', 'Leases_og_title_translation__foreign_key' => 'integer', 'Leases_og_title_translation.foreign_key' => 'integer', 'Leases_og_title_translation__field' => 'string', 'Leases_og_title_translation.field' => 'string', 'Leases_og_title_translation__content' => 'text', 'Leases_og_title_translation.content' => 'text', 'Leases_og_type_translation__id' => 'integer', 'Leases_og_type_translation.id' => 'integer', 'Leases_og_type_translation__locale' => 'string', 'Leases_og_type_translation.locale' => 'string', 'Leases_og_type_translation__model' => 'string', 'Leases_og_type_translation.model' => 'string', 'Leases_og_type_translation__foreign_key' => 'integer', 'Leases_og_type_translation.foreign_key' => 'integer', 'Leases_og_type_translation__field' => 'string', 'Leases_og_type_translation.field' => 'string', 'Leases_og_type_translation__content' => 'text', 'Leases_og_type_translation.content' => 'text', 'Leases_top_features_translation__id' => 'integer', 'Leases_top_features_translation.id' => 'integer', 'Leases_top_features_translation__locale' => 'string', 'Leases_top_features_translation.locale' => 'string', 'Leases_top_features_translation__model' => 'string', 'Leases_top_features_translation.model' => 'string', 'Leases_top_features_translation__foreign_key' => 'integer', 'Leases_top_features_translation.foreign_key' => 'integer', 'Leases_top_features_translation__field' => 'string', 'Leases_top_features_translation.field' => 'string', 'Leases_top_features_translation__content' => 'text', 'Leases_top_features_translation.content' => 'text', 'Leases_current_availability_translation__id' => 'integer', 'Leases_current_availability_translation.id' => 'integer', 'Leases_current_availability_translation__locale' => 'string', 'Leases_current_availability_translation.locale' => 'string', 'Leases_current_availability_translation__model' => 'string', 'Leases_current_availability_translation.model' => 'string', 'Leases_current_availability_translation__foreign_key' => 'integer', 'Leases_current_availability_translation.foreign_key' => 'integer', 'Leases_current_availability_translation__field' => 'string', 'Leases_current_availability_translation.field' => 'string', 'Leases_current_availability_translation__content' => 'text', 'Leases_current_availability_translation.content' => 'text', 'Leases_walking_distance_translation__id' => 'integer', 'Leases_walking_distance_translation.id' => 'integer', 'Leases_walking_distance_translation__locale' => 'string', 'Leases_walking_distance_translation.locale' => 'string', 'Leases_walking_distance_translation__model' => 'string', 'Leases_walking_distance_translation.model' => 'string', 'Leases_walking_distance_translation__foreign_key' => 'integer', 'Leases_walking_distance_translation.foreign_key' => 'integer', 'Leases_walking_distance_translation__field' => 'string', 'Leases_walking_distance_translation.field' => 'string', 'Leases_walking_distance_translation__content' => 'text', 'Leases_walking_distance_translation.content' => 'text', 'Offices_name_translation__id' => 'integer', 'Offices_name_translation.id' => 'integer', 'Offices_name_translation__locale' => 'string', 'Offices_name_translation.locale' => 'string', 'Offices_name_translation__model' => 'string', 'Offices_name_translation.model' => 'string', 'Offices_name_translation__foreign_key' => 'integer', 'Offices_name_translation.foreign_key' => 'integer', 'Offices_name_translation__field' => 'string', 'Offices_name_translation.field' => 'string', 'Offices_name_translation__content' => 'text', 'Offices_name_translation.content' => 'text', 'Areas_name_translation__id' => 'integer', 'Areas_name_translation.id' => 'integer', 'Areas_name_translation__locale' => 'string', 'Areas_name_translation.locale' => 'string', 'Areas_name_translation__model' => 'string', 'Areas_name_translation.model' => 'string', 'Areas_name_translation__foreign_key' => 'integer', 'Areas_name_translation.foreign_key' => 'integer', 'Areas_name_translation__field' => 'string', 'Areas_name_translation.field' => 'string', 'Areas_name_translation__content' => 'text', 'Areas_name_translation.content' => 'text', 'Areas_meta_title_translation__id' => 'integer', 'Areas_meta_title_translation.id' => 'integer', 'Areas_meta_title_translation__locale' => 'string', 'Areas_meta_title_translation.locale' => 'string', 'Areas_meta_title_translation__model' => 'string', 'Areas_meta_title_translation.model' => 'string', 'Areas_meta_title_translation__foreign_key' => 'integer', 'Areas_meta_title_translation.foreign_key' => 'integer', 'Areas_meta_title_translation__field' => 'string', 'Areas_meta_title_translation.field' => 'string', 'Areas_meta_title_translation__content' => 'text', 'Areas_meta_title_translation.content' => 'text', 'Areas_meta_keywords_translation__id' => 'integer', 'Areas_meta_keywords_translation.id' => 'integer', 'Areas_meta_keywords_translation__locale' => 'string', 'Areas_meta_keywords_translation.locale' => 'string', 'Areas_meta_keywords_translation__model' => 'string', 'Areas_meta_keywords_translation.model' => 'string', 'Areas_meta_keywords_translation__foreign_key' => 'integer', 'Areas_meta_keywords_translation.foreign_key' => 'integer', 'Areas_meta_keywords_translation__field' => 'string', 'Areas_meta_keywords_translation.field' => 'string', 'Areas_meta_keywords_translation__content' => 'text', 'Areas_meta_keywords_translation.content' => 'text', 'Areas_meta_descriptions_translation__id' => 'integer', 'Areas_meta_descriptions_translation.id' => 'integer', 'Areas_meta_descriptions_translation__locale' => 'string', 'Areas_meta_descriptions_translation.locale' => 'string', 'Areas_meta_descriptions_translation__model' => 'string', 'Areas_meta_descriptions_translation.model' => 'string', 'Areas_meta_descriptions_translation__foreign_key' => 'integer', 'Areas_meta_descriptions_translation.foreign_key' => 'integer', 'Areas_meta_descriptions_translation__field' => 'string', 'Areas_meta_descriptions_translation.field' => 'string', 'Areas_meta_descriptions_translation__content' => 'text', 'Areas_meta_descriptions_translation.content' => 'text', 'Areas_og_title_translation__id' => 'integer', 'Areas_og_title_translation.id' => 'integer', 'Areas_og_title_translation__locale' => 'string', 'Areas_og_title_translation.locale' => 'string', 'Areas_og_title_translation__model' => 'string', 'Areas_og_title_translation.model' => 'string', 'Areas_og_title_translation__foreign_key' => 'integer', 'Areas_og_title_translation.foreign_key' => 'integer', 'Areas_og_title_translation__field' => 'string', 'Areas_og_title_translation.field' => 'string', 'Areas_og_title_translation__content' => 'text', 'Areas_og_title_translation.content' => 'text', 'Areas_og_type_translation__id' => 'integer', 'Areas_og_type_translation.id' => 'integer', 'Areas_og_type_translation__locale' => 'string', 'Areas_og_type_translation.locale' => 'string', 'Areas_og_type_translation__model' => 'string', 'Areas_og_type_translation.model' => 'string', 'Areas_og_type_translation__foreign_key' => 'integer', 'Areas_og_type_translation.foreign_key' => 'integer', 'Areas_og_type_translation__field' => 'string', 'Areas_og_type_translation.field' => 'string', 'Areas_og_type_translation__content' => 'text', 'Areas_og_type_translation.content' => 'text', 'Countries_name_translation__id' => 'integer', 'Countries_name_translation.id' => 'integer', 'Countries_name_translation__locale' => 'string', 'Countries_name_translation.locale' => 'string', 'Countries_name_translation__model' => 'string', 'Countries_name_translation.model' => 'string', 'Countries_name_translation__foreign_key' => 'integer', 'Countries_name_translation.foreign_key' => 'integer', 'Countries_name_translation__field' => 'string', 'Countries_name_translation.field' => 'string', 'Countries_name_translation__content' => 'text', 'Countries_name_translation.content' => 'text', 'Countries_meta_title_translation__id' => 'integer', 'Countries_meta_title_translation.id' => 'integer', 'Countries_meta_title_translation__locale' => 'string', 'Countries_meta_title_translation.locale' => 'string', 'Countries_meta_title_translation__model' => 'string', 'Countries_meta_title_translation.model' => 'string', 'Countries_meta_title_translation__foreign_key' => 'integer', 'Countries_meta_title_translation.foreign_key' => 'integer', 'Countries_meta_title_translation__field' => 'string', 'Countries_meta_title_translation.field' => 'string', 'Countries_meta_title_translation__content' => 'text', 'Countries_meta_title_translation.content' => 'text', 'Countries_meta_keywords_translation__id' => 'integer', 'Countries_meta_keywords_translation.id' => 'integer', 'Countries_meta_keywords_translation__locale' => 'string', 'Countries_meta_keywords_translation.locale' => 'string', 'Countries_meta_keywords_translation__model' => 'string', 'Countries_meta_keywords_translation.model' => 'string', 'Countries_meta_keywords_translation__foreign_key' => 'integer', 'Countries_meta_keywords_translation.foreign_key' => 'integer', 'Countries_meta_keywords_translation__field' => 'string', 'Countries_meta_keywords_translation.field' => 'string', 'Countries_meta_keywords_translation__content' => 'text', 'Countries_meta_keywords_translation.content' => 'text', 'Countries_meta_descriptions_translation__id' => 'integer', 'Countries_meta_descriptions_translation.id' => 'integer', 'Countries_meta_descriptions_translation__locale' => 'string', 'Countries_meta_descriptions_translation.locale' => 'string', 'Countries_meta_descriptions_translation__model' => 'string', 'Countries_meta_descriptions_translation.model' => 'string', 'Countries_meta_descriptions_translation__foreign_key' => 'integer', 'Countries_meta_descriptions_translation.foreign_key' => 'integer', 'Countries_meta_descriptions_translation__field' => 'string', 'Countries_meta_descriptions_translation.field' => 'string', 'Countries_meta_descriptions_translation__content' => 'text', 'Countries_meta_descriptions_translation.content' => 'text', 'Countries_og_title_translation__id' => 'integer', 'Countries_og_title_translation.id' => 'integer', 'Countries_og_title_translation__locale' => 'string', 'Countries_og_title_translation.locale' => 'string', 'Countries_og_title_translation__model' => 'string', 'Countries_og_title_translation.model' => 'string', 'Countries_og_title_translation__foreign_key' => 'integer', 'Countries_og_title_translation.foreign_key' => 'integer', 'Countries_og_title_translation__field' => 'string', 'Countries_og_title_translation.field' => 'string', 'Countries_og_title_translation__content' => 'text', 'Countries_og_title_translation.content' => 'text', 'Countries_og_type_translation__id' => 'integer', 'Countries_og_type_translation.id' => 'integer', 'Countries_og_type_translation__locale' => 'string', 'Countries_og_type_translation.locale' => 'string', 'Countries_og_type_translation__model' => 'string', 'Countries_og_type_translation.model' => 'string', 'Countries_og_type_translation__foreign_key' => 'integer', 'Countries_og_type_translation.foreign_key' => 'integer', 'Countries_og_type_translation__field' => 'string', 'Countries_og_type_translation.field' => 'string', 'Countries_og_type_translation__content' => 'text', 'Countries_og_type_translation.content' => 'text' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 7, 'mapReducers' => (int) 0, 'contain' => [ 'Prices' => [ [maximum depth reached] ], 'Offices' => [ [maximum depth reached] ], 'Areas' => [ [maximum depth reached] ], 'Countries' => [ [maximum depth reached] ], 'Leases_name_translation' => [ [maximum depth reached] ], 'Leases_prefix_translation' => [ [maximum depth reached] ], 'Leases_suffix_translation' => [ [maximum depth reached] ], 'Leases_address_translation' => [ [maximum depth reached] ], 'Leases_descriptions_translation' => [ [maximum depth reached] ], 'Leases_meta_title_translation' => [ [maximum depth reached] ], 'Leases_meta_keywords_translation' => [ [maximum depth reached] ], 'Leases_meta_descriptions_translation' => [ [maximum depth reached] ], 'Leases_og_title_translation' => [ [maximum depth reached] ], 'Leases_og_type_translation' => [ [maximum depth reached] ], 'Leases_top_features_translation' => [ [maximum depth reached] ], 'Leases_current_availability_translation' => [ [maximum depth reached] ], 'Leases_walking_distance_translation' => [ [maximum depth reached] ] ], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\LeasesTable) {} } $countries = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Countries.id AS `Countries__id`, Countries.name AS `Countries__name`, Countries.slug AS `Countries__slug`, Countries.parent_country AS `Countries__parent_country`, Countries.active AS `Countries__active`, Countries.country_order AS `Countries__country_order`, Countries.meta_title AS `Countries__meta_title`, Countries.meta_keywords AS `Countries__meta_keywords`, Countries.meta_descriptions AS `Countries__meta_descriptions`, Countries.og_title AS `Countries__og_title`, Countries.og_type AS `Countries__og_type`, Countries.og_image AS `Countries__og_image`, Countries.modified AS `Countries__modified`, Countries_name_translation.id AS `Countries_name_translation__id`, Countries_name_translation.locale AS `Countries_name_translation__locale`, Countries_name_translation.model AS `Countries_name_translation__model`, Countries_name_translation.foreign_key AS `Countries_name_translation__foreign_key`, Countries_name_translation.field AS `Countries_name_translation__field`, Countries_name_translation.content AS `Countries_name_translation__content`, Countries_meta_title_translation.id AS `Countries_meta_title_translation__id`, Countries_meta_title_translation.locale AS `Countries_meta_title_translation__locale`, Countries_meta_title_translation.model AS `Countries_meta_title_translation__model`, Countries_meta_title_translation.foreign_key AS `Countries_meta_title_translation__foreign_key`, Countries_meta_title_translation.field AS `Countries_meta_title_translation__field`, Countries_meta_title_translation.content AS `Countries_meta_title_translation__content`, Countries_meta_keywords_translation.id AS `Countries_meta_keywords_translation__id`, Countries_meta_keywords_translation.locale AS `Countries_meta_keywords_translation__locale`, Countries_meta_keywords_translation.model AS `Countries_meta_keywords_translation__model`, Countries_meta_keywords_translation.foreign_key AS `Countries_meta_keywords_translation__foreign_key`, Countries_meta_keywords_translation.field AS `Countries_meta_keywords_translation__field`, Countries_meta_keywords_translation.content AS `Countries_meta_keywords_translation__content`, Countries_meta_descriptions_translation.id AS `Countries_meta_descriptions_translation__id`, Countries_meta_descriptions_translation.locale AS `Countries_meta_descriptions_translation__locale`, Countries_meta_descriptions_translation.model AS `Countries_meta_descriptions_translation__model`, Countries_meta_descriptions_translation.foreign_key AS `Countries_meta_descriptions_translation__foreign_key`, Countries_meta_descriptions_translation.field AS `Countries_meta_descriptions_translation__field`, Countries_meta_descriptions_translation.content AS `Countries_meta_descriptions_translation__content`, Countries_og_title_translation.id AS `Countries_og_title_translation__id`, Countries_og_title_translation.locale AS `Countries_og_title_translation__locale`, Countries_og_title_translation.model AS `Countries_og_title_translation__model`, Countries_og_title_translation.foreign_key AS `Countries_og_title_translation__foreign_key`, Countries_og_title_translation.field AS `Countries_og_title_translation__field`, Countries_og_title_translation.content AS `Countries_og_title_translation__content`, Countries_og_type_translation.id AS `Countries_og_type_translation__id`, Countries_og_type_translation.locale AS `Countries_og_type_translation__locale`, Countries_og_type_translation.model AS `Countries_og_type_translation__model`, Countries_og_type_translation.foreign_key AS `Countries_og_type_translation__foreign_key`, Countries_og_type_translation.field AS `Countries_og_type_translation__field`, Countries_og_type_translation.content AS `Countries_og_type_translation__content` FROM countries Countries LEFT JOIN i18n Countries_name_translation ON (Countries_name_translation.model = :c0 AND Countries_name_translation.field = :c1 AND Countries_name_translation.content != :c2 AND Countries_name_translation.locale = :c3 AND Countries.id = (Countries_name_translation.foreign_key)) LEFT JOIN i18n Countries_meta_title_translation ON (Countries_meta_title_translation.model = :c4 AND Countries_meta_title_translation.field = :c5 AND Countries_meta_title_translation.content != :c6 AND Countries_meta_title_translation.locale = :c7 AND Countries.id = (Countries_meta_title_translation.foreign_key)) LEFT JOIN i18n Countries_meta_keywords_translation ON (Countries_meta_keywords_translation.model = :c8 AND Countries_meta_keywords_translation.field = :c9 AND Countries_meta_keywords_translation.content != :c10 AND Countries_meta_keywords_translation.locale = :c11 AND Countries.id = (Countries_meta_keywords_translation.foreign_key)) LEFT JOIN i18n Countries_meta_descriptions_translation ON (Countries_meta_descriptions_translation.model = :c12 AND Countries_meta_descriptions_translation.field = :c13 AND Countries_meta_descriptions_translation.content != :c14 AND Countries_meta_descriptions_translation.locale = :c15 AND Countries.id = (Countries_meta_descriptions_translation.foreign_key)) LEFT JOIN i18n Countries_og_title_translation ON (Countries_og_title_translation.model = :c16 AND Countries_og_title_translation.field = :c17 AND Countries_og_title_translation.content != :c18 AND Countries_og_title_translation.locale = :c19 AND Countries.id = (Countries_og_title_translation.foreign_key)) LEFT JOIN i18n Countries_og_type_translation ON (Countries_og_type_translation.model = :c20 AND Countries_og_type_translation.field = :c21 AND Countries_og_type_translation.content != :c22 AND Countries_og_type_translation.locale = :c23 AND Countries.id = (Countries_og_type_translation.foreign_key)) WHERE Countries.active = :c24 ORDER BY Countries.country_order ASC, Countries.modified DESC', 'params' => [ ':c0' => [ [maximum depth reached] ], ':c1' => [ [maximum depth reached] ], ':c2' => [ [maximum depth reached] ], ':c3' => [ [maximum depth reached] ], ':c4' => [ [maximum depth reached] ], ':c5' => [ [maximum depth reached] ], ':c6' => [ [maximum depth reached] ], ':c7' => [ [maximum depth reached] ], ':c8' => [ [maximum depth reached] ], ':c9' => [ [maximum depth reached] ], ':c10' => [ [maximum depth reached] ], ':c11' => [ [maximum depth reached] ], ':c12' => [ [maximum depth reached] ], ':c13' => [ [maximum depth reached] ], ':c14' => [ [maximum depth reached] ], ':c15' => [ [maximum depth reached] ], ':c16' => [ [maximum depth reached] ], ':c17' => [ [maximum depth reached] ], ':c18' => [ [maximum depth reached] ], ':c19' => [ [maximum depth reached] ], ':c20' => [ [maximum depth reached] ], ':c21' => [ [maximum depth reached] ], ':c22' => [ [maximum depth reached] ], ':c23' => [ [maximum depth reached] ], ':c24' => [ [maximum depth reached] ] ], 'defaultTypes' => [ 'Countries__id' => 'integer', 'Countries.id' => 'integer', 'id' => 'integer', 'Countries__name' => 'string', 'Countries.name' => 'string', 'name' => 'string', 'Countries__slug' => 'string', 'Countries.slug' => 'string', 'slug' => 'string', 'Countries__parent_country' => 'integer', 'Countries.parent_country' => 'integer', 'parent_country' => 'integer', 'Countries__active' => 'integer', 'Countries.active' => 'integer', 'active' => 'integer', 'Countries__country_order' => 'integer', 'Countries.country_order' => 'integer', 'country_order' => 'integer', 'Countries__meta_title' => 'string', 'Countries.meta_title' => 'string', 'meta_title' => 'string', 'Countries__meta_keywords' => 'string', 'Countries.meta_keywords' => 'string', 'meta_keywords' => 'string', 'Countries__meta_descriptions' => 'text', 'Countries.meta_descriptions' => 'text', 'meta_descriptions' => 'text', 'Countries__og_title' => 'string', 'Countries.og_title' => 'string', 'og_title' => 'string', 'Countries__og_type' => 'string', 'Countries.og_type' => 'string', 'og_type' => 'string', 'Countries__og_image' => 'text', 'Countries.og_image' => 'text', 'og_image' => 'text', 'Countries__modified' => 'timestamp', 'Countries.modified' => 'timestamp', 'modified' => 'timestamp', 'Countries_name_translation__id' => 'integer', 'Countries_name_translation.id' => 'integer', 'Countries_name_translation__locale' => 'string', 'Countries_name_translation.locale' => 'string', 'locale' => 'string', 'Countries_name_translation__model' => 'string', 'Countries_name_translation.model' => 'string', 'model' => 'string', 'Countries_name_translation__foreign_key' => 'integer', 'Countries_name_translation.foreign_key' => 'integer', 'foreign_key' => 'integer', 'Countries_name_translation__field' => 'string', 'Countries_name_translation.field' => 'string', 'field' => 'string', 'Countries_name_translation__content' => 'text', 'Countries_name_translation.content' => 'text', 'content' => 'text', 'Countries_meta_title_translation__id' => 'integer', 'Countries_meta_title_translation.id' => 'integer', 'Countries_meta_title_translation__locale' => 'string', 'Countries_meta_title_translation.locale' => 'string', 'Countries_meta_title_translation__model' => 'string', 'Countries_meta_title_translation.model' => 'string', 'Countries_meta_title_translation__foreign_key' => 'integer', 'Countries_meta_title_translation.foreign_key' => 'integer', 'Countries_meta_title_translation__field' => 'string', 'Countries_meta_title_translation.field' => 'string', 'Countries_meta_title_translation__content' => 'text', 'Countries_meta_title_translation.content' => 'text', 'Countries_meta_keywords_translation__id' => 'integer', 'Countries_meta_keywords_translation.id' => 'integer', 'Countries_meta_keywords_translation__locale' => 'string', 'Countries_meta_keywords_translation.locale' => 'string', 'Countries_meta_keywords_translation__model' => 'string', 'Countries_meta_keywords_translation.model' => 'string', 'Countries_meta_keywords_translation__foreign_key' => 'integer', 'Countries_meta_keywords_translation.foreign_key' => 'integer', 'Countries_meta_keywords_translation__field' => 'string', 'Countries_meta_keywords_translation.field' => 'string', 'Countries_meta_keywords_translation__content' => 'text', 'Countries_meta_keywords_translation.content' => 'text', 'Countries_meta_descriptions_translation__id' => 'integer', 'Countries_meta_descriptions_translation.id' => 'integer', 'Countries_meta_descriptions_translation__locale' => 'string', 'Countries_meta_descriptions_translation.locale' => 'string', 'Countries_meta_descriptions_translation__model' => 'string', 'Countries_meta_descriptions_translation.model' => 'string', 'Countries_meta_descriptions_translation__foreign_key' => 'integer', 'Countries_meta_descriptions_translation.foreign_key' => 'integer', 'Countries_meta_descriptions_translation__field' => 'string', 'Countries_meta_descriptions_translation.field' => 'string', 'Countries_meta_descriptions_translation__content' => 'text', 'Countries_meta_descriptions_translation.content' => 'text', 'Countries_og_title_translation__id' => 'integer', 'Countries_og_title_translation.id' => 'integer', 'Countries_og_title_translation__locale' => 'string', 'Countries_og_title_translation.locale' => 'string', 'Countries_og_title_translation__model' => 'string', 'Countries_og_title_translation.model' => 'string', 'Countries_og_title_translation__foreign_key' => 'integer', 'Countries_og_title_translation.foreign_key' => 'integer', 'Countries_og_title_translation__field' => 'string', 'Countries_og_title_translation.field' => 'string', 'Countries_og_title_translation__content' => 'text', 'Countries_og_title_translation.content' => 'text', 'Countries_og_type_translation__id' => 'integer', 'Countries_og_type_translation.id' => 'integer', 'Countries_og_type_translation__locale' => 'string', 'Countries_og_type_translation.locale' => 'string', 'Countries_og_type_translation__model' => 'string', 'Countries_og_type_translation.model' => 'string', 'Countries_og_type_translation__foreign_key' => 'integer', 'Countries_og_type_translation.foreign_key' => 'integer', 'Countries_og_type_translation__field' => 'string', 'Countries_og_type_translation.field' => 'string', 'Countries_og_type_translation__content' => 'text', 'Countries_og_type_translation.content' => 'text' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 1, 'mapReducers' => (int) 0, 'contain' => [ 'Countries_name_translation' => [ [maximum depth reached] ], 'Countries_meta_title_translation' => [ [maximum depth reached] ], 'Countries_meta_keywords_translation' => [ [maximum depth reached] ], 'Countries_meta_descriptions_translation' => [ [maximum depth reached] ], 'Countries_og_title_translation' => [ [maximum depth reached] ], 'Countries_og_type_translation' => [ [maximum depth reached] ] ], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\CountriesTable) {} } $offices = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Offices.id AS `Offices__id`, Offices.name AS `Offices__name`, Offices_name_translation.id AS `Offices_name_translation__id`, Offices_name_translation.content AS `Offices_name_translation__content` FROM offices Offices LEFT JOIN i18n Offices_name_translation ON (Offices_name_translation.model = :c0 AND Offices_name_translation.field = :c1 AND Offices_name_translation.content != :c2 AND Offices_name_translation.locale = :c3 AND Offices.id = (Offices_name_translation.foreign_key)) WHERE Offices.status = :c4', 'params' => [ ':c0' => [ [maximum depth reached] ], ':c1' => [ [maximum depth reached] ], ':c2' => [ [maximum depth reached] ], ':c3' => [ [maximum depth reached] ], ':c4' => [ [maximum depth reached] ] ], 'defaultTypes' => [ 'Offices__id' => 'integer', 'Offices.id' => 'integer', 'id' => 'integer', 'Offices__name' => 'string', 'Offices.name' => 'string', 'name' => 'string', 'Offices__slug' => 'string', 'Offices.slug' => 'string', 'slug' => 'string', 'Offices__status' => 'integer', 'Offices.status' => 'integer', 'status' => 'integer', 'Offices__created' => 'datetime', 'Offices.created' => 'datetime', 'created' => 'datetime', 'Offices__modified' => 'timestamp', 'Offices.modified' => 'timestamp', 'modified' => 'timestamp', 'Offices_name_translation__id' => 'integer', 'Offices_name_translation.id' => 'integer', 'Offices_name_translation__locale' => 'string', 'Offices_name_translation.locale' => 'string', 'locale' => 'string', 'Offices_name_translation__model' => 'string', 'Offices_name_translation.model' => 'string', 'model' => 'string', 'Offices_name_translation__foreign_key' => 'integer', 'Offices_name_translation.foreign_key' => 'integer', 'foreign_key' => 'integer', 'Offices_name_translation__field' => 'string', 'Offices_name_translation.field' => 'string', 'field' => 'string', 'Offices_name_translation__content' => 'text', 'Offices_name_translation.content' => 'text', 'content' => 'text' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 2, 'mapReducers' => (int) 0, 'contain' => [ 'Offices_name_translation' => [ [maximum depth reached] ] ], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\OfficesTable) {} } $areas = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT States.id AS `States__id`, States.country_id AS `States__country_id`, States.name AS `States__name`, States.slug AS `States__slug`, States.status AS `States__status`, States.state_order AS `States__state_order`, States.meta_title AS `States__meta_title`, States.meta_keywords AS `States__meta_keywords`, States.meta_descriptions AS `States__meta_descriptions`, States.og_title AS `States__og_title`, States.og_type AS `States__og_type`, States.og_image AS `States__og_image`, States.modified AS `States__modified`, States_name_translation.id AS `States_name_translation__id`, States_name_translation.locale AS `States_name_translation__locale`, States_name_translation.model AS `States_name_translation__model`, States_name_translation.foreign_key AS `States_name_translation__foreign_key`, States_name_translation.field AS `States_name_translation__field`, States_name_translation.content AS `States_name_translation__content`, States_meta_title_translation.id AS `States_meta_title_translation__id`, States_meta_title_translation.locale AS `States_meta_title_translation__locale`, States_meta_title_translation.model AS `States_meta_title_translation__model`, States_meta_title_translation.foreign_key AS `States_meta_title_translation__foreign_key`, States_meta_title_translation.field AS `States_meta_title_translation__field`, States_meta_title_translation.content AS `States_meta_title_translation__content`, States_meta_keywords_translation.id AS `States_meta_keywords_translation__id`, States_meta_keywords_translation.locale AS `States_meta_keywords_translation__locale`, States_meta_keywords_translation.model AS `States_meta_keywords_translation__model`, States_meta_keywords_translation.foreign_key AS `States_meta_keywords_translation__foreign_key`, States_meta_keywords_translation.field AS `States_meta_keywords_translation__field`, States_meta_keywords_translation.content AS `States_meta_keywords_translation__content`, States_meta_descriptions_translation.id AS `States_meta_descriptions_translation__id`, States_meta_descriptions_translation.locale AS `States_meta_descriptions_translation__locale`, States_meta_descriptions_translation.model AS `States_meta_descriptions_translation__model`, States_meta_descriptions_translation.foreign_key AS `States_meta_descriptions_translation__foreign_key`, States_meta_descriptions_translation.field AS `States_meta_descriptions_translation__field`, States_meta_descriptions_translation.content AS `States_meta_descriptions_translation__content`, States_og_title_translation.id AS `States_og_title_translation__id`, States_og_title_translation.locale AS `States_og_title_translation__locale`, States_og_title_translation.model AS `States_og_title_translation__model`, States_og_title_translation.foreign_key AS `States_og_title_translation__foreign_key`, States_og_title_translation.field AS `States_og_title_translation__field`, States_og_title_translation.content AS `States_og_title_translation__content`, States_og_type_translation.id AS `States_og_type_translation__id`, States_og_type_translation.locale AS `States_og_type_translation__locale`, States_og_type_translation.model AS `States_og_type_translation__model`, States_og_type_translation.foreign_key AS `States_og_type_translation__foreign_key`, States_og_type_translation.field AS `States_og_type_translation__field`, States_og_type_translation.content AS `States_og_type_translation__content` FROM states States LEFT JOIN i18n States_name_translation ON (States_name_translation.model = :c0 AND States_name_translation.field = :c1 AND States_name_translation.content != :c2 AND States_name_translation.locale = :c3 AND States.id = (States_name_translation.foreign_key)) LEFT JOIN i18n States_meta_title_translation ON (States_meta_title_translation.model = :c4 AND States_meta_title_translation.field = :c5 AND States_meta_title_translation.content != :c6 AND States_meta_title_translation.locale = :c7 AND States.id = (States_meta_title_translation.foreign_key)) LEFT JOIN i18n States_meta_keywords_translation ON (States_meta_keywords_translation.model = :c8 AND States_meta_keywords_translation.field = :c9 AND States_meta_keywords_translation.content != :c10 AND States_meta_keywords_translation.locale = :c11 AND States.id = (States_meta_keywords_translation.foreign_key)) LEFT JOIN i18n States_meta_descriptions_translation ON (States_meta_descriptions_translation.model = :c12 AND States_meta_descriptions_translation.field = :c13 AND States_meta_descriptions_translation.content != :c14 AND States_meta_descriptions_translation.locale = :c15 AND States.id = (States_meta_descriptions_translation.foreign_key)) LEFT JOIN i18n States_og_title_translation ON (States_og_title_translation.model = :c16 AND States_og_title_translation.field = :c17 AND States_og_title_translation.content != :c18 AND States_og_title_translation.locale = :c19 AND States.id = (States_og_title_translation.foreign_key)) LEFT JOIN i18n States_og_type_translation ON (States_og_type_translation.model = :c20 AND States_og_type_translation.field = :c21 AND States_og_type_translation.content != :c22 AND States_og_type_translation.locale = :c23 AND States.id = (States_og_type_translation.foreign_key)) WHERE (States.status = :c24 AND States.country_id = :c25) ORDER BY States.state_order ASC, States.modified DESC', 'params' => [ ':c0' => [ [maximum depth reached] ], ':c1' => [ [maximum depth reached] ], ':c2' => [ [maximum depth reached] ], ':c3' => [ [maximum depth reached] ], ':c4' => [ [maximum depth reached] ], ':c5' => [ [maximum depth reached] ], ':c6' => [ [maximum depth reached] ], ':c7' => [ [maximum depth reached] ], ':c8' => [ [maximum depth reached] ], ':c9' => [ [maximum depth reached] ], ':c10' => [ [maximum depth reached] ], ':c11' => [ [maximum depth reached] ], ':c12' => [ [maximum depth reached] ], ':c13' => [ [maximum depth reached] ], ':c14' => [ [maximum depth reached] ], ':c15' => [ [maximum depth reached] ], ':c16' => [ [maximum depth reached] ], ':c17' => [ [maximum depth reached] ], ':c18' => [ [maximum depth reached] ], ':c19' => [ [maximum depth reached] ], ':c20' => [ [maximum depth reached] ], ':c21' => [ [maximum depth reached] ], ':c22' => [ [maximum depth reached] ], ':c23' => [ [maximum depth reached] ], ':c24' => [ [maximum depth reached] ], ':c25' => [ [maximum depth reached] ] ], 'defaultTypes' => [ 'States__id' => 'integer', 'States.id' => 'integer', 'id' => 'integer', 'States__country_id' => 'integer', 'States.country_id' => 'integer', 'country_id' => 'integer', 'States__name' => 'string', 'States.name' => 'string', 'name' => 'string', 'States__slug' => 'string', 'States.slug' => 'string', 'slug' => 'string', 'States__status' => 'boolean', 'States.status' => 'boolean', 'status' => 'boolean', 'States__state_order' => 'integer', 'States.state_order' => 'integer', 'state_order' => 'integer', 'States__meta_title' => 'string', 'States.meta_title' => 'string', 'meta_title' => 'string', 'States__meta_keywords' => 'string', 'States.meta_keywords' => 'string', 'meta_keywords' => 'string', 'States__meta_descriptions' => 'string', 'States.meta_descriptions' => 'string', 'meta_descriptions' => 'string', 'States__og_title' => 'string', 'States.og_title' => 'string', 'og_title' => 'string', 'States__og_type' => 'string', 'States.og_type' => 'string', 'og_type' => 'string', 'States__og_image' => 'text', 'States.og_image' => 'text', 'og_image' => 'text', 'States__modified' => 'timestamp', 'States.modified' => 'timestamp', 'modified' => 'timestamp', 'Areas__id' => 'integer', 'Areas.id' => 'integer', 'Areas__name' => 'string', 'Areas.name' => 'string', 'Areas__slug' => 'string', 'Areas.slug' => 'string', 'Areas__country_id' => 'integer', 'Areas.country_id' => 'integer', 'Areas__state_id' => 'integer', 'Areas.state_id' => 'integer', 'state_id' => 'integer', 'Areas__status' => 'integer', 'Areas.status' => 'integer', 'Areas__area_order' => 'integer', 'Areas.area_order' => 'integer', 'area_order' => 'integer', 'Areas__popular_location' => 'integer', 'Areas.popular_location' => 'integer', 'popular_location' => 'integer', 'Areas__meta_title' => 'string', 'Areas.meta_title' => 'string', 'Areas__meta_keywords' => 'string', 'Areas.meta_keywords' => 'string', 'Areas__meta_descriptions' => 'text', 'Areas.meta_descriptions' => 'text', 'Areas__og_title' => 'string', 'Areas.og_title' => 'string', 'Areas__og_type' => 'string', 'Areas.og_type' => 'string', 'Areas__og_image' => 'text', 'Areas.og_image' => 'text', 'Areas__modified' => 'timestamp', 'Areas.modified' => 'timestamp', 'States_name_translation__id' => 'integer', 'States_name_translation.id' => 'integer', 'States_name_translation__locale' => 'string', 'States_name_translation.locale' => 'string', 'locale' => 'string', 'States_name_translation__model' => 'string', 'States_name_translation.model' => 'string', 'model' => 'string', 'States_name_translation__foreign_key' => 'integer', 'States_name_translation.foreign_key' => 'integer', 'foreign_key' => 'integer', 'States_name_translation__field' => 'string', 'States_name_translation.field' => 'string', 'field' => 'string', 'States_name_translation__content' => 'text', 'States_name_translation.content' => 'text', 'content' => 'text', 'States_meta_title_translation__id' => 'integer', 'States_meta_title_translation.id' => 'integer', 'States_meta_title_translation__locale' => 'string', 'States_meta_title_translation.locale' => 'string', 'States_meta_title_translation__model' => 'string', 'States_meta_title_translation.model' => 'string', 'States_meta_title_translation__foreign_key' => 'integer', 'States_meta_title_translation.foreign_key' => 'integer', 'States_meta_title_translation__field' => 'string', 'States_meta_title_translation.field' => 'string', 'States_meta_title_translation__content' => 'text', 'States_meta_title_translation.content' => 'text', 'States_meta_keywords_translation__id' => 'integer', 'States_meta_keywords_translation.id' => 'integer', 'States_meta_keywords_translation__locale' => 'string', 'States_meta_keywords_translation.locale' => 'string', 'States_meta_keywords_translation__model' => 'string', 'States_meta_keywords_translation.model' => 'string', 'States_meta_keywords_translation__foreign_key' => 'integer', 'States_meta_keywords_translation.foreign_key' => 'integer', 'States_meta_keywords_translation__field' => 'string', 'States_meta_keywords_translation.field' => 'string', 'States_meta_keywords_translation__content' => 'text', 'States_meta_keywords_translation.content' => 'text', 'States_meta_descriptions_translation__id' => 'integer', 'States_meta_descriptions_translation.id' => 'integer', 'States_meta_descriptions_translation__locale' => 'string', 'States_meta_descriptions_translation.locale' => 'string', 'States_meta_descriptions_translation__model' => 'string', 'States_meta_descriptions_translation.model' => 'string', 'States_meta_descriptions_translation__foreign_key' => 'integer', 'States_meta_descriptions_translation.foreign_key' => 'integer', 'States_meta_descriptions_translation__field' => 'string', 'States_meta_descriptions_translation.field' => 'string', 'States_meta_descriptions_translation__content' => 'text', 'States_meta_descriptions_translation.content' => 'text', 'States_og_title_translation__id' => 'integer', 'States_og_title_translation.id' => 'integer', 'States_og_title_translation__locale' => 'string', 'States_og_title_translation.locale' => 'string', 'States_og_title_translation__model' => 'string', 'States_og_title_translation.model' => 'string', 'States_og_title_translation__foreign_key' => 'integer', 'States_og_title_translation.foreign_key' => 'integer', 'States_og_title_translation__field' => 'string', 'States_og_title_translation.field' => 'string', 'States_og_title_translation__content' => 'text', 'States_og_title_translation.content' => 'text', 'States_og_type_translation__id' => 'integer', 'States_og_type_translation.id' => 'integer', 'States_og_type_translation__locale' => 'string', 'States_og_type_translation.locale' => 'string', 'States_og_type_translation__model' => 'string', 'States_og_type_translation.model' => 'string', 'States_og_type_translation__foreign_key' => 'integer', 'States_og_type_translation.foreign_key' => 'integer', 'States_og_type_translation__field' => 'string', 'States_og_type_translation.field' => 'string', 'States_og_type_translation__content' => 'text', 'States_og_type_translation.content' => 'text' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 1, 'mapReducers' => (int) 0, 'contain' => [ 'Areas' => [ [maximum depth reached] ], 'States_name_translation' => [ [maximum depth reached] ], 'States_meta_title_translation' => [ [maximum depth reached] ], 'States_meta_keywords_translation' => [ [maximum depth reached] ], 'States_meta_descriptions_translation' => [ [maximum depth reached] ], 'States_og_title_translation' => [ [maximum depth reached] ], 'States_og_type_translation' => [ [maximum depth reached] ] ], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\StatesTable) {} } $building = null $leases_availability = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT LeasesAvailability.id AS `LeasesAvailability__id`, LeasesAvailability.leases_id AS `LeasesAvailability__leases_id`, LeasesAvailability.office_id AS `LeasesAvailability__office_id`, LeasesAvailability.office_type AS `LeasesAvailability__office_type`, LeasesAvailability.price_type_id AS `LeasesAvailability__price_type_id`, LeasesAvailability.currency_id AS `LeasesAvailability__currency_id`, LeasesAvailability.currency_code AS `LeasesAvailability__currency_code`, LeasesAvailability.price AS `LeasesAvailability__price`, LeasesAvailability.price_from AS `LeasesAvailability__price_from`, LeasesAvailability.number_of_pax AS `LeasesAvailability__number_of_pax`, LeasesAvailability.number_of_pax_max AS `LeasesAvailability__number_of_pax_max`, LeasesAvailability.availability AS `LeasesAvailability__availability`, LeasesAvailability.deleted AS `LeasesAvailability__deleted`, PriceTypes.id AS `PriceTypes__id`, PriceTypes.type AS `PriceTypes__type`, Currencies.id AS `Currencies__id`, Currencies.country_id AS `Currencies__country_id`, Currencies.name AS `Currencies__name`, Currencies.code AS `Currencies__code`, Currencies.symbol AS `Currencies__symbol`, Currencies.show_after AS `Currencies__show_after`, Currencies.status AS `Currencies__status`, LeasesAvailability_office_type_translation.id AS `LeasesAvailability_office_type_translation__id`, LeasesAvailability_office_type_translation.locale AS `LeasesAvailability_office_type_translation__locale`, LeasesAvailability_office_type_translation.model AS `LeasesAvailability_office_type_translation__model`, LeasesAvailability_office_type_translation.foreign_key AS `LeasesAvailability_office_type_translation__foreign_key`, LeasesAvailability_office_type_translation.field AS `LeasesAvailability_office_type_translation__field`, LeasesAvailability_office_type_translation.content AS `LeasesAvailability_office_type_translation__content` FROM leases_availability LeasesAvailability INNER JOIN price_types PriceTypes ON PriceTypes.id = (LeasesAvailability.price_type_id) INNER JOIN currencies Currencies ON Currencies.id = (LeasesAvailability.currency_id) LEFT JOIN i18n LeasesAvailability_office_type_translation ON (LeasesAvailability_office_type_translation.model = :c0 AND LeasesAvailability_office_type_translation.field = :c1 AND LeasesAvailability_office_type_translation.content != :c2 AND LeasesAvailability_office_type_translation.locale = :c3 AND LeasesAvailability.id = (LeasesAvailability_office_type_translation.foreign_key)) WHERE LeasesAvailability.leases_id = :c4', 'params' => [ ':c0' => [ [maximum depth reached] ], ':c1' => [ [maximum depth reached] ], ':c2' => [ [maximum depth reached] ], ':c3' => [ [maximum depth reached] ], ':c4' => [ [maximum depth reached] ] ], 'defaultTypes' => [ 'LeasesAvailability__id' => 'integer', 'LeasesAvailability.id' => 'integer', 'id' => 'integer', 'LeasesAvailability__leases_id' => 'integer', 'LeasesAvailability.leases_id' => 'integer', 'leases_id' => 'integer', 'LeasesAvailability__office_id' => 'integer', 'LeasesAvailability.office_id' => 'integer', 'office_id' => 'integer', 'LeasesAvailability__office_type' => 'string', 'LeasesAvailability.office_type' => 'string', 'office_type' => 'string', 'LeasesAvailability__price_type_id' => 'integer', 'LeasesAvailability.price_type_id' => 'integer', 'price_type_id' => 'integer', 'LeasesAvailability__currency_id' => 'integer', 'LeasesAvailability.currency_id' => 'integer', 'currency_id' => 'integer', 'LeasesAvailability__currency_code' => 'string', 'LeasesAvailability.currency_code' => 'string', 'currency_code' => 'string', 'LeasesAvailability__price' => 'decimal', 'LeasesAvailability.price' => 'decimal', 'price' => 'decimal', 'LeasesAvailability__price_from' => 'integer', 'LeasesAvailability.price_from' => 'integer', 'price_from' => 'integer', 'LeasesAvailability__number_of_pax' => 'integer', 'LeasesAvailability.number_of_pax' => 'integer', 'number_of_pax' => 'integer', 'LeasesAvailability__number_of_pax_max' => 'integer', 'LeasesAvailability.number_of_pax_max' => 'integer', 'number_of_pax_max' => 'integer', 'LeasesAvailability__availability' => 'integer', 'LeasesAvailability.availability' => 'integer', 'availability' => 'integer', 'LeasesAvailability__deleted' => 'datetime', 'LeasesAvailability.deleted' => 'datetime', 'deleted' => 'datetime', 'I18n__id' => 'integer', 'I18n.id' => 'integer', 'I18n__locale' => 'string', 'I18n.locale' => 'string', 'locale' => 'string', 'I18n__model' => 'string', 'I18n.model' => 'string', 'model' => 'string', 'I18n__foreign_key' => 'integer', 'I18n.foreign_key' => 'integer', 'foreign_key' => 'integer', 'I18n__field' => 'string', 'I18n.field' => 'string', 'field' => 'string', 'I18n__content' => 'text', 'I18n.content' => 'text', 'content' => 'text', 'PriceTypes__id' => 'integer', 'PriceTypes.id' => 'integer', 'PriceTypes__type' => 'string', 'PriceTypes.type' => 'string', 'type' => 'string', 'Currencies__id' => 'integer', 'Currencies.id' => 'integer', 'Currencies__country_id' => 'integer', 'Currencies.country_id' => 'integer', 'country_id' => 'integer', 'Currencies__name' => 'string', 'Currencies.name' => 'string', 'name' => 'string', 'Currencies__code' => 'string', 'Currencies.code' => 'string', 'code' => 'string', 'Currencies__symbol' => 'string', 'Currencies.symbol' => 'string', 'symbol' => 'string', 'Currencies__show_after' => 'integer', 'Currencies.show_after' => 'integer', 'show_after' => 'integer', 'Currencies__status' => 'boolean', 'Currencies.status' => 'boolean', 'status' => 'boolean', 'LeasesAvailability_office_type_translation__id' => 'integer', 'LeasesAvailability_office_type_translation.id' => 'integer', 'LeasesAvailability_office_type_translation__locale' => 'string', 'LeasesAvailability_office_type_translation.locale' => 'string', 'LeasesAvailability_office_type_translation__model' => 'string', 'LeasesAvailability_office_type_translation.model' => 'string', 'LeasesAvailability_office_type_translation__foreign_key' => 'integer', 'LeasesAvailability_office_type_translation.foreign_key' => 'integer', 'LeasesAvailability_office_type_translation__field' => 'string', 'LeasesAvailability_office_type_translation.field' => 'string', 'LeasesAvailability_office_type_translation__content' => 'text', 'LeasesAvailability_office_type_translation.content' => 'text' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 2, 'mapReducers' => (int) 0, 'contain' => [ 'I18n' => [ [maximum depth reached] ], 'PriceTypes' => [[maximum depth reached]], 'Currencies' => [[maximum depth reached]], 'LeasesAvailability_office_type_translation' => [ [maximum depth reached] ] ], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\LeasesAvailabilityTable) {} } $languages = null $locale_lang = 'zh' $countryName = 'US' $images = [ (int) 0 => '' ] $image = ''
include - APP/Template/Pages/lease_detail.ctp, line 91 Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1025 Cake\View\View::_render() - CORE/src/View/View.php, line 986 Cake\View\View::render() - CORE/src/View/View.php, line 610 Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 623 Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 125 Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 93 Cake\Routing\Dispatcher::dispatch() - CORE/src/Routing/Dispatcher.php, line 60 [main] - ROOT/webroot/index.php, line 50
位於尖東區核心地段的鐵路大廈是一棟高規格的標準大樓,地處優越,五分鐘即可至地鐵尖東站,從國內坐東鐵到公司只需半小時及港島區坐過海巴士到公司只需十五分鐘。享有便利的交通網。此商務中心價錢實惠,環境寧靜,為您提供齊全的設施和優良的品質, 致力於提供現代化及高科技之服務式辦公室、虛擬辦公室、會議室及其他專業服務。
鐵路大廈-尖沙咀, 香港
訂閱我們的電子報,您便能收到我們最新的優惠及筍盤消息。
Successfully added to wishlists.
Thank you! This email has been successfully subscribed to our newsletter.
發生錯誤。請再試一次。
這電郵已經訂閱了電子報。