香港九龍灣服務式辦公室/商務中心指南

Warning (2): count(): Parameter must be an array or an object that implements Countable [APP/Template/Element/header.ctp, line 85]Code Context                                        </a>
                                        <ul class="dropdown-menu submenu-box">
                                            <?php if(count($languages)) : ?>
$viewFile = '/home/workspaceasia/public_html/src/Template/Element/header.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=047c3d25dcdf5c7c32206dbde0a943ba&sdk=php-sdk-4.0.23&scope=email%2Cpublic_profile',
	'properties' => object(Cake\Datasource\ResultSetDecorator) {

		'count' => (int) 5
	
	},
	'all_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.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_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_address_translation ON (Leases_address_translation.model = :c4 AND Leases_address_translation.field = :c5 AND Leases_address_translation.content != :c6 AND Leases_address_translation.locale = :c7 AND Leases.id = (Leases_address_translation.foreign_key)) LEFT JOIN i18n Leases_descriptions_translation ON (Leases_descriptions_translation.model = :c8 AND Leases_descriptions_translation.field = :c9 AND Leases_descriptions_translation.content != :c10 AND Leases_descriptions_translation.locale = :c11 AND Leases.id = (Leases_descriptions_translation.foreign_key)) LEFT JOIN i18n Leases_meta_title_translation ON (Leases_meta_title_translation.model = :c12 AND Leases_meta_title_translation.field = :c13 AND Leases_meta_title_translation.content != :c14 AND Leases_meta_title_translation.locale = :c15 AND Leases.id = (Leases_meta_title_translation.foreign_key)) LEFT JOIN i18n Leases_meta_keywords_translation ON (Leases_meta_keywords_translation.model = :c16 AND Leases_meta_keywords_translation.field = :c17 AND Leases_meta_keywords_translation.content != :c18 AND Leases_meta_keywords_translation.locale = :c19 AND Leases.id = (Leases_meta_keywords_translation.foreign_key)) LEFT JOIN i18n Leases_meta_descriptions_translation ON (Leases_meta_descriptions_translation.model = :c20 AND Leases_meta_descriptions_translation.field = :c21 AND Leases_meta_descriptions_translation.content != :c22 AND Leases_meta_descriptions_translation.locale = :c23 AND Leases.id = (Leases_meta_descriptions_translation.foreign_key)) LEFT JOIN i18n Leases_og_title_translation ON (Leases_og_title_translation.model = :c24 AND Leases_og_title_translation.field = :c25 AND Leases_og_title_translation.content != :c26 AND Leases_og_title_translation.locale = :c27 AND Leases.id = (Leases_og_title_translation.foreign_key)) LEFT JOIN i18n Leases_og_type_translation ON (Leases_og_type_translation.model = :c28 AND Leases_og_type_translation.field = :c29 AND Leases_og_type_translation.content != :c30 AND Leases_og_type_translation.locale = :c31 AND Leases.id = (Leases_og_type_translation.foreign_key)) LEFT JOIN i18n Leases_top_features_translation ON (Leases_top_features_translation.model = :c32 AND Leases_top_features_translation.field = :c33 AND Leases_top_features_translation.content != :c34 AND Leases_top_features_translation.locale = :c35 AND Leases.id = (Leases_top_features_translation.foreign_key)) LEFT JOIN i18n Leases_current_availability_translation ON (Leases_current_availability_translation.model = :c36 AND Leases_current_availability_translation.field = :c37 AND Leases_current_availability_translation.content != :c38 AND Leases_current_availability_translation.locale = :c39 AND Leases.id = (Leases_current_availability_translation.foreign_key)) LEFT JOIN i18n Leases_walking_distance_translation ON (Leases_walking_distance_translation.model = :c40 AND Leases_walking_distance_translation.field = :c41 AND Leases_walking_distance_translation.content != :c42 AND Leases_walking_distance_translation.locale = :c43 AND Leases.id = (Leases_walking_distance_translation.foreign_key)) LEFT JOIN i18n Offices_name_translation ON (Offices_name_translation.model = :c44 AND Offices_name_translation.field = :c45 AND Offices_name_translation.content != :c46 AND Offices_name_translation.locale = :c47 AND Offices.id = (Offices_name_translation.foreign_key)) LEFT JOIN i18n Areas_name_translation ON (Areas_name_translation.model = :c48 AND Areas_name_translation.field = :c49 AND Areas_name_translation.content != :c50 AND Areas_name_translation.locale = :c51 AND Areas.id = (Areas_name_translation.foreign_key)) LEFT JOIN i18n Areas_meta_title_translation ON (Areas_meta_title_translation.model = :c52 AND Areas_meta_title_translation.field = :c53 AND Areas_meta_title_translation.content != :c54 AND Areas_meta_title_translation.locale = :c55 AND Areas.id = (Areas_meta_title_translation.foreign_key)) LEFT JOIN i18n Areas_meta_keywords_translation ON (Areas_meta_keywords_translation.model = :c56 AND Areas_meta_keywords_translation.field = :c57 AND Areas_meta_keywords_translation.content != :c58 AND Areas_meta_keywords_translation.locale = :c59 AND Areas.id = (Areas_meta_keywords_translation.foreign_key)) LEFT JOIN i18n Areas_meta_descriptions_translation ON (Areas_meta_descriptions_translation.model = :c60 AND Areas_meta_descriptions_translation.field = :c61 AND Areas_meta_descriptions_translation.content != :c62 AND Areas_meta_descriptions_translation.locale = :c63 AND Areas.id = (Areas_meta_descriptions_translation.foreign_key)) LEFT JOIN i18n Areas_og_title_translation ON (Areas_og_title_translation.model = :c64 AND Areas_og_title_translation.field = :c65 AND Areas_og_title_translation.content != :c66 AND Areas_og_title_translation.locale = :c67 AND Areas.id = (Areas_og_title_translation.foreign_key)) LEFT JOIN i18n Areas_og_type_translation ON (Areas_og_type_translation.model = :c68 AND Areas_og_type_translation.field = :c69 AND Areas_og_type_translation.content != :c70 AND Areas_og_type_translation.locale = :c71 AND Areas.id = (Areas_og_type_translation.foreign_key)) LEFT JOIN i18n Countries_name_translation ON (Countries_name_translation.model = :c72 AND Countries_name_translation.field = :c73 AND Countries_name_translation.content != :c74 AND Countries_name_translation.locale = :c75 AND Countries.id = (Countries_name_translation.foreign_key)) LEFT JOIN i18n Countries_meta_title_translation ON (Countries_meta_title_translation.model = :c76 AND Countries_meta_title_translation.field = :c77 AND Countries_meta_title_translation.content != :c78 AND Countries_meta_title_translation.locale = :c79 AND Countries.id = (Countries_meta_title_translation.foreign_key)) LEFT JOIN i18n Countries_meta_keywords_translation ON (Countries_meta_keywords_translation.model = :c80 AND Countries_meta_keywords_translation.field = :c81 AND Countries_meta_keywords_translation.content != :c82 AND Countries_meta_keywords_translation.locale = :c83 AND Countries.id = (Countries_meta_keywords_translation.foreign_key)) LEFT JOIN i18n Countries_meta_descriptions_translation ON (Countries_meta_descriptions_translation.model = :c84 AND Countries_meta_descriptions_translation.field = :c85 AND Countries_meta_descriptions_translation.content != :c86 AND Countries_meta_descriptions_translation.locale = :c87 AND Countries.id = (Countries_meta_descriptions_translation.foreign_key)) LEFT JOIN i18n Countries_og_title_translation ON (Countries_og_title_translation.model = :c88 AND Countries_og_title_translation.field = :c89 AND Countries_og_title_translation.content != :c90 AND Countries_og_title_translation.locale = :c91 AND Countries.id = (Countries_og_title_translation.foreign_key)) LEFT JOIN i18n Countries_og_type_translation ON (Countries_og_type_translation.model = :c92 AND Countries_og_type_translation.field = :c93 AND Countries_og_type_translation.content != :c94 AND Countries_og_type_translation.locale = :c95 AND Countries.id = (Countries_og_type_translation.foreign_key)) WHERE (Leases.country_id = :c96 AND Leases.area_id = :c97 AND Leases.status = :c98) GROUP BY Leases.id  ORDER BY Leases.lease_order ASC, Leases.modified DESC',
		'params' => [
			[maximum depth reached]
		],
		'defaultTypes' => [
			[maximum depth reached]
		],
		'decorators' => (int) 1,
		'executed' => true,
		'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) {}
	
	},
	'properties_list' => 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_name_translation.id AS `Leases_name_translation__id`, Leases_name_translation.content AS `Leases_name_translation__content` FROM leases Leases 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_address_translation ON (Leases_address_translation.model = :c4 AND Leases_address_translation.field = :c5 AND Leases_address_translation.content != :c6 AND Leases_address_translation.locale = :c7 AND Leases.id = (Leases_address_translation.foreign_key)) LEFT JOIN i18n Leases_descriptions_translation ON (Leases_descriptions_translation.model = :c8 AND Leases_descriptions_translation.field = :c9 AND Leases_descriptions_translation.content != :c10 AND Leases_descriptions_translation.locale = :c11 AND Leases.id = (Leases_descriptions_translation.foreign_key)) LEFT JOIN i18n Leases_meta_title_translation ON (Leases_meta_title_translation.model = :c12 AND Leases_meta_title_translation.field = :c13 AND Leases_meta_title_translation.content != :c14 AND Leases_meta_title_translation.locale = :c15 AND Leases.id = (Leases_meta_title_translation.foreign_key)) LEFT JOIN i18n Leases_meta_keywords_translation ON (Leases_meta_keywords_translation.model = :c16 AND Leases_meta_keywords_translation.field = :c17 AND Leases_meta_keywords_translation.content != :c18 AND Leases_meta_keywords_translation.locale = :c19 AND Leases.id = (Leases_meta_keywords_translation.foreign_key)) LEFT JOIN i18n Leases_meta_descriptions_translation ON (Leases_meta_descriptions_translation.model = :c20 AND Leases_meta_descriptions_translation.field = :c21 AND Leases_meta_descriptions_translation.content != :c22 AND Leases_meta_descriptions_translation.locale = :c23 AND Leases.id = (Leases_meta_descriptions_translation.foreign_key)) LEFT JOIN i18n Leases_og_title_translation ON (Leases_og_title_translation.model = :c24 AND Leases_og_title_translation.field = :c25 AND Leases_og_title_translation.content != :c26 AND Leases_og_title_translation.locale = :c27 AND Leases.id = (Leases_og_title_translation.foreign_key)) LEFT JOIN i18n Leases_og_type_translation ON (Leases_og_type_translation.model = :c28 AND Leases_og_type_translation.field = :c29 AND Leases_og_type_translation.content != :c30 AND Leases_og_type_translation.locale = :c31 AND Leases.id = (Leases_og_type_translation.foreign_key)) LEFT JOIN i18n Leases_top_features_translation ON (Leases_top_features_translation.model = :c32 AND Leases_top_features_translation.field = :c33 AND Leases_top_features_translation.content != :c34 AND Leases_top_features_translation.locale = :c35 AND Leases.id = (Leases_top_features_translation.foreign_key)) LEFT JOIN i18n Leases_current_availability_translation ON (Leases_current_availability_translation.model = :c36 AND Leases_current_availability_translation.field = :c37 AND Leases_current_availability_translation.content != :c38 AND Leases_current_availability_translation.locale = :c39 AND Leases.id = (Leases_current_availability_translation.foreign_key)) LEFT JOIN i18n Leases_walking_distance_translation ON (Leases_walking_distance_translation.model = :c40 AND Leases_walking_distance_translation.field = :c41 AND Leases_walking_distance_translation.content != :c42 AND Leases_walking_distance_translation.locale = :c43 AND Leases.id = (Leases_walking_distance_translation.foreign_key))',
		'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\LeasesTable) {}
	
	},
	'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.slug AS `Offices__slug`, Offices.status AS `Offices__status`, Offices.created AS `Offices__created`, Offices.modified AS `Offices__modified`, 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` 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) 1,
		'mapReducers' => (int) 0,
		'contain' => [
			[maximum depth reached]
		],
		'matching' => [[maximum depth reached]],
		'extraOptions' => [[maximum depth reached]],
		'repository' => object(App\Model\Table\OfficesTable) {}
	
	},
	'filter' => [],
	'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) {}
	
	},
	'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) 1,
		'executed' => true,
		'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) {}
	
	},
	'locationC' => object(App\Model\Entity\Country) {

		'id' => (int) 98,
		'name' => '香港',
		'slug' => 'hong-kong',
		'parent_country' => (int) 96,
		'active' => (int) 1,
		'country_order' => (int) 1,
		'meta_title' => '香港服務式辦公室/商務中心指南 - Workspace Asia',
		'meta_keywords' => '香港辦公室出租，服務式辦公室，商務中心，共享工作間',
		'meta_descriptions' => '想在香港租辦公室？立即上Workspace Asia尋找你的理想服務式辦公室或共享工作間。全港超過二百個地點，覆蓋整個市場，提供詳細價格及環境資料。請致電+852 3018 4832查詢！',
		'og_title' => '',
		'og_type' => null,
		'og_image' => '/uploads/hong_kong/central_building/cb_3.jpg',
		'modified' => object(Cake\I18n\Time) {},
		'_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]' => 'Countries'
	
	},
	'locationA' => object(App\Model\Entity\Area) {

		'id' => (int) 57,
		'name' => '九龍灣',
		'slug' => 'kowloon-bay',
		'country_id' => (int) 98,
		'state_id' => (int) 2,
		'status' => (int) 1,
		'area_order' => (int) 11,
		'popular_location' => (int) 0,
		'meta_title' => '香港九龍灣服務式辦公室/商務中心指南 - Workspace Asia',
		'meta_keywords' => '九龍灣辦公室出租，服務式辦公室，商務中心，共享工作間',
		'meta_descriptions' => '想在九龍灣租辦公室？立即上Workspace Asia尋找你的理想服務式辦公室或共享工作間。全港超過二百個地點，覆蓋整個市場，提供詳細價格及環境資料。請致電+852 9231 0043查詢！',
		'og_title' => '',
		'og_type' => null,
		'og_image' => '/uploads/hong_kong/mega_cube/a-1552889783965.jpg',
		'modified' => object(Cake\I18n\Time) {},
		'_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]' => 'Areas'
	
	},
	'locationO' => '',
	'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) {}
	
	},
	'pageLimit' => (int) 9,
	'area_ids' => [],
	'total_properties' => (int) 5,
	'seoText' => '想在九龍灣租辦公室？立即上Workspace Asia尋找你的理想服務式辦公室或共享工作間。全港超過二百個地點，覆蓋整個市場，提供詳細價格及環境資料。請致電+852 9231 0043查詢！',
	'buildings' => object(Cake\ORM\Query) {

		'(help)' => 'This is a Query object, to get the results execute or iterate it.',
		'sql' => 'SELECT Buildings.id AS `Buildings__id`, Buildings.name AS `Buildings__name`, Buildings.slug AS `Buildings__slug`, Buildings.country_id AS `Buildings__country_id`, Buildings.state_id AS `Buildings__state_id`, Buildings.area_id AS `Buildings__area_id`, Buildings.featured_image AS `Buildings__featured_image`, Buildings.images AS `Buildings__images`, Buildings.ownership AS `Buildings__ownership`, Buildings.completed_at AS `Buildings__completed_at`, Buildings.total_gfa AS `Buildings__total_gfa`, Buildings.floor_numbers AS `Buildings__floor_numbers`, Buildings.air_con_hours AS `Buildings__air_con_hours`, Buildings.floor_system AS `Buildings__floor_system`, Buildings.lift AS `Buildings__lift`, Buildings.ceiling_height AS `Buildings__ceiling_height`, Buildings.carpark_facilities AS `Buildings__carpark_facilities`, Buildings.transportation AS `Buildings__transportation`, Buildings.leases AS `Buildings__leases`, Buildings.floor_plan_image AS `Buildings__floor_plan_image`, Buildings.lat AS `Buildings__lat`, Buildings.lng AS `Buildings__lng`, Buildings.status AS `Buildings__status`, Buildings.address AS `Buildings__address`, Buildings.descriptions AS `Buildings__descriptions`, Buildings.meta_title AS `Buildings__meta_title`, Buildings.meta_keywords AS `Buildings__meta_keywords`, Buildings.meta_descriptions AS `Buildings__meta_descriptions`, Buildings.og_title AS `Buildings__og_title`, Buildings.og_type AS `Buildings__og_type`, Buildings.og_image AS `Buildings__og_image`, Buildings.created AS `Buildings__created`, Buildings.modified AS `Buildings__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`, 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`, 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`, Buildings_name_translation.id AS `Buildings_name_translation__id`, Buildings_name_translation.locale AS `Buildings_name_translation__locale`, Buildings_name_translation.model AS `Buildings_name_translation__model`, Buildings_name_translation.foreign_key AS `Buildings_name_translation__foreign_key`, Buildings_name_translation.field AS `Buildings_name_translation__field`, Buildings_name_translation.content AS `Buildings_name_translation__content`, Buildings_address_translation.id AS `Buildings_address_translation__id`, Buildings_address_translation.locale AS `Buildings_address_translation__locale`, Buildings_address_translation.model AS `Buildings_address_translation__model`, Buildings_address_translation.foreign_key AS `Buildings_address_translation__foreign_key`, Buildings_address_translation.field AS `Buildings_address_translation__field`, Buildings_address_translation.content AS `Buildings_address_translation__content`, Buildings_descriptions_translation.id AS `Buildings_descriptions_translation__id`, Buildings_descriptions_translation.locale AS `Buildings_descriptions_translation__locale`, Buildings_descriptions_translation.model AS `Buildings_descriptions_translation__model`, Buildings_descriptions_translation.foreign_key AS `Buildings_descriptions_translation__foreign_key`, Buildings_descriptions_translation.field AS `Buildings_descriptions_translation__field`, Buildings_descriptions_translation.content AS `Buildings_descriptions_translation__content`, Buildings_ownership_translation.id AS `Buildings_ownership_translation__id`, Buildings_ownership_translation.locale AS `Buildings_ownership_translation__locale`, Buildings_ownership_translation.model AS `Buildings_ownership_translation__model`, Buildings_ownership_translation.foreign_key AS `Buildings_ownership_translation__foreign_key`, Buildings_ownership_translation.field AS `Buildings_ownership_translation__field`, Buildings_ownership_translation.content AS `Buildings_ownership_translation__content`, Buildings_air_con_hours_translation.id AS `Buildings_air_con_hours_translation__id`, Buildings_air_con_hours_translation.locale AS `Buildings_air_con_hours_translation__locale`, Buildings_air_con_hours_translation.model AS `Buildings_air_con_hours_translation__model`, Buildings_air_con_hours_translation.foreign_key AS `Buildings_air_con_hours_translation__foreign_key`, Buildings_air_con_hours_translation.field AS `Buildings_air_con_hours_translation__field`, Buildings_air_con_hours_translation.content AS `Buildings_air_con_hours_translation__content`, Buildings_floor_system_translation.id AS `Buildings_floor_system_translation__id`, Buildings_floor_system_translation.locale AS `Buildings_floor_system_translation__locale`, Buildings_floor_system_translation.model AS `Buildings_floor_system_translation__model`, Buildings_floor_system_translation.foreign_key AS `Buildings_floor_system_translation__foreign_key`, Buildings_floor_system_translation.field AS `Buildings_floor_system_translation__field`, Buildings_floor_system_translation.content AS `Buildings_floor_system_translation__content`, Buildings_lift_translation.id AS `Buildings_lift_translation__id`, Buildings_lift_translation.locale AS `Buildings_lift_translation__locale`, Buildings_lift_translation.model AS `Buildings_lift_translation__model`, Buildings_lift_translation.foreign_key AS `Buildings_lift_translation__foreign_key`, Buildings_lift_translation.field AS `Buildings_lift_translation__field`, Buildings_lift_translation.content AS `Buildings_lift_translation__content`, Buildings_ceiling_height_translation.id AS `Buildings_ceiling_height_translation__id`, Buildings_ceiling_height_translation.locale AS `Buildings_ceiling_height_translation__locale`, Buildings_ceiling_height_translation.model AS `Buildings_ceiling_height_translation__model`, Buildings_ceiling_height_translation.foreign_key AS `Buildings_ceiling_height_translation__foreign_key`, Buildings_ceiling_height_translation.field AS `Buildings_ceiling_height_translation__field`, Buildings_ceiling_height_translation.content AS `Buildings_ceiling_height_translation__content`, Buildings_carpark_facilities_translation.id AS `Buildings_carpark_facilities_translation__id`, Buildings_carpark_facilities_translation.locale AS `Buildings_carpark_facilities_translation__locale`, Buildings_carpark_facilities_translation.model AS `Buildings_carpark_facilities_translation__model`, Buildings_carpark_facilities_translation.foreign_key AS `Buildings_carpark_facilities_translation__foreign_key`, Buildings_carpark_facilities_translation.field AS `Buildings_carpark_facilities_translation__field`, Buildings_carpark_facilities_translation.content AS `Buildings_carpark_facilities_translation__content`, Buildings_transportation_translation.id AS `Buildings_transportation_translation__id`, Buildings_transportation_translation.locale AS `Buildings_transportation_translation__locale`, Buildings_transportation_translation.model AS `Buildings_transportation_translation__model`, Buildings_transportation_translation.foreign_key AS `Buildings_transportation_translation__foreign_key`, Buildings_transportation_translation.field AS `Buildings_transportation_translation__field`, Buildings_transportation_translation.content AS `Buildings_transportation_translation__content`, Buildings_meta_title_translation.id AS `Buildings_meta_title_translation__id`, Buildings_meta_title_translation.locale AS `Buildings_meta_title_translation__locale`, Buildings_meta_title_translation.model AS `Buildings_meta_title_translation__model`, Buildings_meta_title_translation.foreign_key AS `Buildings_meta_title_translation__foreign_key`, Buildings_meta_title_translation.field AS `Buildings_meta_title_translation__field`, Buildings_meta_title_translation.content AS `Buildings_meta_title_translation__content`, Buildings_meta_keywords_translation.id AS `Buildings_meta_keywords_translation__id`, Buildings_meta_keywords_translation.locale AS `Buildings_meta_keywords_translation__locale`, Buildings_meta_keywords_translation.model AS `Buildings_meta_keywords_translation__model`, Buildings_meta_keywords_translation.foreign_key AS `Buildings_meta_keywords_translation__foreign_key`, Buildings_meta_keywords_translation.field AS `Buildings_meta_keywords_translation__field`, Buildings_meta_keywords_translation.content AS `Buildings_meta_keywords_translation__content`, Buildings_meta_descriptions_translation.id AS `Buildings_meta_descriptions_translation__id`, Buildings_meta_descriptions_translation.locale AS `Buildings_meta_descriptions_translation__locale`, Buildings_meta_descriptions_translation.model AS `Buildings_meta_descriptions_translation__model`, Buildings_meta_descriptions_translation.foreign_key AS `Buildings_meta_descriptions_translation__foreign_key`, Buildings_meta_descriptions_translation.field AS `Buildings_meta_descriptions_translation__field`, Buildings_meta_descriptions_translation.content AS `Buildings_meta_descriptions_translation__content`, Buildings_og_title_translation.id AS `Buildings_og_title_translation__id`, Buildings_og_title_translation.locale AS `Buildings_og_title_translation__locale`, Buildings_og_title_translation.model AS `Buildings_og_title_translation__model`, Buildings_og_title_translation.foreign_key AS `Buildings_og_title_translation__foreign_key`, Buildings_og_title_translation.field AS `Buildings_og_title_translation__field`, Buildings_og_title_translation.content AS `Buildings_og_title_translation__content`, Buildings_og_type_translation.id AS `Buildings_og_type_translation__id`, Buildings_og_type_translation.locale AS `Buildings_og_type_translation__locale`, Buildings_og_type_translation.model AS `Buildings_og_type_translation__model`, Buildings_og_type_translation.foreign_key AS `Buildings_og_type_translation__foreign_key`, Buildings_og_type_translation.field AS `Buildings_og_type_translation__field`, Buildings_og_type_translation.content AS `Buildings_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`, 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`, 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` FROM buildings Buildings INNER JOIN countries Countries ON Countries.id = (Buildings.country_id) INNER JOIN states States ON States.id = (Buildings.state_id) INNER JOIN areas Areas ON Areas.id = (Buildings.area_id) LEFT JOIN i18n Buildings_name_translation ON (Buildings_name_translation.model = :c0 AND Buildings_name_translation.field = :c1 AND Buildings_name_translation.content != :c2 AND Buildings_name_translation.locale = :c3 AND Buildings.id = (Buildings_name_translation.foreign_key)) LEFT JOIN i18n Buildings_address_translation ON (Buildings_address_translation.model = :c4 AND Buildings_address_translation.field = :c5 AND Buildings_address_translation.content != :c6 AND Buildings_address_translation.locale = :c7 AND Buildings.id = (Buildings_address_translation.foreign_key)) LEFT JOIN i18n Buildings_descriptions_translation ON (Buildings_descriptions_translation.model = :c8 AND Buildings_descriptions_translation.field = :c9 AND Buildings_descriptions_translation.content != :c10 AND Buildings_descriptions_translation.locale = :c11 AND Buildings.id = (Buildings_descriptions_translation.foreign_key)) LEFT JOIN i18n Buildings_ownership_translation ON (Buildings_ownership_translation.model = :c12 AND Buildings_ownership_translation.field = :c13 AND Buildings_ownership_translation.content != :c14 AND Buildings_ownership_translation.locale = :c15 AND Buildings.id = (Buildings_ownership_translation.foreign_key)) LEFT JOIN i18n Buildings_air_con_hours_translation ON (Buildings_air_con_hours_translation.model = :c16 AND Buildings_air_con_hours_translation.field = :c17 AND Buildings_air_con_hours_translation.content != :c18 AND Buildings_air_con_hours_translation.locale = :c19 AND Buildings.id = (Buildings_air_con_hours_translation.foreign_key)) LEFT JOIN i18n Buildings_floor_system_translation ON (Buildings_floor_system_translation.model = :c20 AND Buildings_floor_system_translation.field = :c21 AND Buildings_floor_system_translation.content != :c22 AND Buildings_floor_system_translation.locale = :c23 AND Buildings.id = (Buildings_floor_system_translation.foreign_key)) LEFT JOIN i18n Buildings_lift_translation ON (Buildings_lift_translation.model = :c24 AND Buildings_lift_translation.field = :c25 AND Buildings_lift_translation.content != :c26 AND Buildings_lift_translation.locale = :c27 AND Buildings.id = (Buildings_lift_translation.foreign_key)) LEFT JOIN i18n Buildings_ceiling_height_translation ON (Buildings_ceiling_height_translation.model = :c28 AND Buildings_ceiling_height_translation.field = :c29 AND Buildings_ceiling_height_translation.content != :c30 AND Buildings_ceiling_height_translation.locale = :c31 AND Buildings.id = (Buildings_ceiling_height_translation.foreign_key)) LEFT JOIN i18n Buildings_carpark_facilities_translation ON (Buildings_carpark_facilities_translation.model = :c32 AND Buildings_carpark_facilities_translation.field = :c33 AND Buildings_carpark_facilities_translation.content != :c34 AND Buildings_carpark_facilities_translation.locale = :c35 AND Buildings.id = (Buildings_carpark_facilities_translation.foreign_key)) LEFT JOIN i18n Buildings_transportation_translation ON (Buildings_transportation_translation.model = :c36 AND Buildings_transportation_translation.field = :c37 AND Buildings_transportation_translation.content != :c38 AND Buildings_transportation_translation.locale = :c39 AND Buildings.id = (Buildings_transportation_translation.foreign_key)) LEFT JOIN i18n Buildings_meta_title_translation ON (Buildings_meta_title_translation.model = :c40 AND Buildings_meta_title_translation.field = :c41 AND Buildings_meta_title_translation.content != :c42 AND Buildings_meta_title_translation.locale = :c43 AND Buildings.id = (Buildings_meta_title_translation.foreign_key)) LEFT JOIN i18n Buildings_meta_keywords_translation ON (Buildings_meta_keywords_translation.model = :c44 AND Buildings_meta_keywords_translation.field = :c45 AND Buildings_meta_keywords_translation.content != :c46 AND Buildings_meta_keywords_translation.locale = :c47 AND Buildings.id = (Buildings_meta_keywords_translation.foreign_key)) LEFT JOIN i18n Buildings_meta_descriptions_translation ON (Buildings_meta_descriptions_translation.model = :c48 AND Buildings_meta_descriptions_translation.field = :c49 AND Buildings_meta_descriptions_translation.content != :c50 AND Buildings_meta_descriptions_translation.locale = :c51 AND Buildings.id = (Buildings_meta_descriptions_translation.foreign_key)) LEFT JOIN i18n Buildings_og_title_translation ON (Buildings_og_title_translation.model = :c52 AND Buildings_og_title_translation.field = :c53 AND Buildings_og_title_translation.content != :c54 AND Buildings_og_title_translation.locale = :c55 AND Buildings.id = (Buildings_og_title_translation.foreign_key)) LEFT JOIN i18n Buildings_og_type_translation ON (Buildings_og_type_translation.model = :c56 AND Buildings_og_type_translation.field = :c57 AND Buildings_og_type_translation.content != :c58 AND Buildings_og_type_translation.locale = :c59 AND Buildings.id = (Buildings_og_type_translation.foreign_key)) LEFT JOIN i18n Countries_name_translation ON (Countries_name_translation.model = :c60 AND Countries_name_translation.field = :c61 AND Countries_name_translation.content != :c62 AND Countries_name_translation.locale = :c63 AND Countries.id = (Countries_name_translation.foreign_key)) LEFT JOIN i18n Countries_meta_title_translation ON (Countries_meta_title_translation.model = :c64 AND Countries_meta_title_translation.field = :c65 AND Countries_meta_title_translation.content != :c66 AND Countries_meta_title_translation.locale = :c67 AND Countries.id = (Countries_meta_title_translation.foreign_key)) LEFT JOIN i18n Countries_meta_keywords_translation ON (Countries_meta_keywords_translation.model = :c68 AND Countries_meta_keywords_translation.field = :c69 AND Countries_meta_keywords_translation.content != :c70 AND Countries_meta_keywords_translation.locale = :c71 AND Countries.id = (Countries_meta_keywords_translation.foreign_key)) LEFT JOIN i18n Countries_meta_descriptions_translation ON (Countries_meta_descriptions_translation.model = :c72 AND Countries_meta_descriptions_translation.field = :c73 AND Countries_meta_descriptions_translation.content != :c74 AND Countries_meta_descriptions_translation.locale = :c75 AND Countries.id = (Countries_meta_descriptions_translation.foreign_key)) LEFT JOIN i18n Countries_og_title_translation ON (Countries_og_title_translation.model = :c76 AND Countries_og_title_translation.field = :c77 AND Countries_og_title_translation.content != :c78 AND Countries_og_title_translation.locale = :c79 AND Countries.id = (Countries_og_title_translation.foreign_key)) LEFT JOIN i18n Countries_og_type_translation ON (Countries_og_type_translation.model = :c80 AND Countries_og_type_translation.field = :c81 AND Countries_og_type_translation.content != :c82 AND Countries_og_type_translation.locale = :c83 AND Countries.id = (Countries_og_type_translation.foreign_key)) LEFT JOIN i18n States_name_translation ON (States_name_translation.model = :c84 AND States_name_translation.field = :c85 AND States_name_translation.content != :c86 AND States_name_translation.locale = :c87 AND States.id = (States_name_translation.foreign_key)) LEFT JOIN i18n States_meta_title_translation ON (States_meta_title_translation.model = :c88 AND States_meta_title_translation.field = :c89 AND States_meta_title_translation.content != :c90 AND States_meta_title_translation.locale = :c91 AND States.id = (States_meta_title_translation.foreign_key)) LEFT JOIN i18n States_meta_keywords_translation ON (States_meta_keywords_translation.model = :c92 AND States_meta_keywords_translation.field = :c93 AND States_meta_keywords_translation.content != :c94 AND States_meta_keywords_translation.locale = :c95 AND States.id = (States_meta_keywords_translation.foreign_key)) LEFT JOIN i18n States_meta_descriptions_translation ON (States_meta_descriptions_translation.model = :c96 AND States_meta_descriptions_translation.field = :c97 AND States_meta_descriptions_translation.content != :c98 AND States_meta_descriptions_translation.locale = :c99 AND States.id = (States_meta_descriptions_translation.foreign_key)) LEFT JOIN i18n States_og_title_translation ON (States_og_title_translation.model = :c100 AND States_og_title_translation.field = :c101 AND States_og_title_translation.content != :c102 AND States_og_title_translation.locale = :c103 AND States.id = (States_og_title_translation.foreign_key)) LEFT JOIN i18n States_og_type_translation ON (States_og_type_translation.model = :c104 AND States_og_type_translation.field = :c105 AND States_og_type_translation.content != :c106 AND States_og_type_translation.locale = :c107 AND States.id = (States_og_type_translation.foreign_key)) LEFT JOIN i18n Areas_name_translation ON (Areas_name_translation.model = :c108 AND Areas_name_translation.field = :c109 AND Areas_name_translation.content != :c110 AND Areas_name_translation.locale = :c111 AND Areas.id = (Areas_name_translation.foreign_key)) LEFT JOIN i18n Areas_meta_title_translation ON (Areas_meta_title_translation.model = :c112 AND Areas_meta_title_translation.field = :c113 AND Areas_meta_title_translation.content != :c114 AND Areas_meta_title_translation.locale = :c115 AND Areas.id = (Areas_meta_title_translation.foreign_key)) LEFT JOIN i18n Areas_meta_keywords_translation ON (Areas_meta_keywords_translation.model = :c116 AND Areas_meta_keywords_translation.field = :c117 AND Areas_meta_keywords_translation.content != :c118 AND Areas_meta_keywords_translation.locale = :c119 AND Areas.id = (Areas_meta_keywords_translation.foreign_key)) LEFT JOIN i18n Areas_meta_descriptions_translation ON (Areas_meta_descriptions_translation.model = :c120 AND Areas_meta_descriptions_translation.field = :c121 AND Areas_meta_descriptions_translation.content != :c122 AND Areas_meta_descriptions_translation.locale = :c123 AND Areas.id = (Areas_meta_descriptions_translation.foreign_key)) LEFT JOIN i18n Areas_og_title_translation ON (Areas_og_title_translation.model = :c124 AND Areas_og_title_translation.field = :c125 AND Areas_og_title_translation.content != :c126 AND Areas_og_title_translation.locale = :c127 AND Areas.id = (Areas_og_title_translation.foreign_key)) LEFT JOIN i18n Areas_og_type_translation ON (Areas_og_type_translation.model = :c128 AND Areas_og_type_translation.field = :c129 AND Areas_og_type_translation.content != :c130 AND Areas_og_type_translation.locale = :c131 AND Areas.id = (Areas_og_type_translation.foreign_key)) WHERE (Buildings.status = :c132 AND Buildings.country_id = :c133 AND Buildings.area_id = :c134) ORDER BY Buildings.modified DESC',
		'params' => [
			[maximum depth reached]
		],
		'defaultTypes' => [
			[maximum depth reached]
		],
		'decorators' => (int) 1,
		'executed' => true,
		'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\BuildingsTable) {}
	
	},
	'keyword' => '',
	'total_buildings' => (int) 26,
	'states' => 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',
		'params' => [
			[maximum depth reached]
		],
		'defaultTypes' => [
			[maximum depth reached]
		],
		'decorators' => (int) 1,
		'executed' => true,
		'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) {}
	
	},
	'leases_offices' => [
		(int) 2 => [
			'id' => (int) 2,
			'slug' => 'private-offices',
			'name' => 'Private Offices',
			'translated_name' => '私人辦公室'
		],
		(int) 4 => [
			'id' => (int) 4,
			'slug' => 'hot-desks',
			'name' => 'Hot Desks',
			'translated_name' => '流動辦工桌'
		],
		(int) 5 => [
			'id' => (int) 5,
			'slug' => 'dedicated-desks',
			'name' => 'Dedicated Desks',
			'translated_name' => '固定辦公桌'
		]
	],
	'data' => object(stdClass) {
		country => 'hong-kong'
		area => 'kowloon-bay'
		inputs => [
			[maximum depth reached]
		]
		input_text => [
			[maximum depth reached]
		]
		search_input_class => [
			[maximum depth reached]
		]
	},
	'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=047c3d25dcdf5c7c32206dbde0a943ba&sdk=php-sdk-4.0.23&scope=email%2Cpublic_profile'
$properties = object(Cake\Datasource\ResultSetDecorator) {

	'count' => (int) 5

}
$all_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.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_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_address_translation ON (Leases_address_translation.model = :c4 AND Leases_address_translation.field = :c5 AND Leases_address_translation.content != :c6 AND Leases_address_translation.locale = :c7 AND Leases.id = (Leases_address_translation.foreign_key)) LEFT JOIN i18n Leases_descriptions_translation ON (Leases_descriptions_translation.model = :c8 AND Leases_descriptions_translation.field = :c9 AND Leases_descriptions_translation.content != :c10 AND Leases_descriptions_translation.locale = :c11 AND Leases.id = (Leases_descriptions_translation.foreign_key)) LEFT JOIN i18n Leases_meta_title_translation ON (Leases_meta_title_translation.model = :c12 AND Leases_meta_title_translation.field = :c13 AND Leases_meta_title_translation.content != :c14 AND Leases_meta_title_translation.locale = :c15 AND Leases.id = (Leases_meta_title_translation.foreign_key)) LEFT JOIN i18n Leases_meta_keywords_translation ON (Leases_meta_keywords_translation.model = :c16 AND Leases_meta_keywords_translation.field = :c17 AND Leases_meta_keywords_translation.content != :c18 AND Leases_meta_keywords_translation.locale = :c19 AND Leases.id = (Leases_meta_keywords_translation.foreign_key)) LEFT JOIN i18n Leases_meta_descriptions_translation ON (Leases_meta_descriptions_translation.model = :c20 AND Leases_meta_descriptions_translation.field = :c21 AND Leases_meta_descriptions_translation.content != :c22 AND Leases_meta_descriptions_translation.locale = :c23 AND Leases.id = (Leases_meta_descriptions_translation.foreign_key)) LEFT JOIN i18n Leases_og_title_translation ON (Leases_og_title_translation.model = :c24 AND Leases_og_title_translation.field = :c25 AND Leases_og_title_translation.content != :c26 AND Leases_og_title_translation.locale = :c27 AND Leases.id = (Leases_og_title_translation.foreign_key)) LEFT JOIN i18n Leases_og_type_translation ON (Leases_og_type_translation.model = :c28 AND Leases_og_type_translation.field = :c29 AND Leases_og_type_translation.content != :c30 AND Leases_og_type_translation.locale = :c31 AND Leases.id = (Leases_og_type_translation.foreign_key)) LEFT JOIN i18n Leases_top_features_translation ON (Leases_top_features_translation.model = :c32 AND Leases_top_features_translation.field = :c33 AND Leases_top_features_translation.content != :c34 AND Leases_top_features_translation.locale = :c35 AND Leases.id = (Leases_top_features_translation.foreign_key)) LEFT JOIN i18n Leases_current_availability_translation ON (Leases_current_availability_translation.model = :c36 AND Leases_current_availability_translation.field = :c37 AND Leases_current_availability_translation.content != :c38 AND Leases_current_availability_translation.locale = :c39 AND Leases.id = (Leases_current_availability_translation.foreign_key)) LEFT JOIN i18n Leases_walking_distance_translation ON (Leases_walking_distance_translation.model = :c40 AND Leases_walking_distance_translation.field = :c41 AND Leases_walking_distance_translation.content != :c42 AND Leases_walking_distance_translation.locale = :c43 AND Leases.id = (Leases_walking_distance_translation.foreign_key)) LEFT JOIN i18n Offices_name_translation ON (Offices_name_translation.model = :c44 AND Offices_name_translation.field = :c45 AND Offices_name_translation.content != :c46 AND Offices_name_translation.locale = :c47 AND Offices.id = (Offices_name_translation.foreign_key)) LEFT JOIN i18n Areas_name_translation ON (Areas_name_translation.model = :c48 AND Areas_name_translation.field = :c49 AND Areas_name_translation.content != :c50 AND Areas_name_translation.locale = :c51 AND Areas.id = (Areas_name_translation.foreign_key)) LEFT JOIN i18n Areas_meta_title_translation ON (Areas_meta_title_translation.model = :c52 AND Areas_meta_title_translation.field = :c53 AND Areas_meta_title_translation.content != :c54 AND Areas_meta_title_translation.locale = :c55 AND Areas.id = (Areas_meta_title_translation.foreign_key)) LEFT JOIN i18n Areas_meta_keywords_translation ON (Areas_meta_keywords_translation.model = :c56 AND Areas_meta_keywords_translation.field = :c57 AND Areas_meta_keywords_translation.content != :c58 AND Areas_meta_keywords_translation.locale = :c59 AND Areas.id = (Areas_meta_keywords_translation.foreign_key)) LEFT JOIN i18n Areas_meta_descriptions_translation ON (Areas_meta_descriptions_translation.model = :c60 AND Areas_meta_descriptions_translation.field = :c61 AND Areas_meta_descriptions_translation.content != :c62 AND Areas_meta_descriptions_translation.locale = :c63 AND Areas.id = (Areas_meta_descriptions_translation.foreign_key)) LEFT JOIN i18n Areas_og_title_translation ON (Areas_og_title_translation.model = :c64 AND Areas_og_title_translation.field = :c65 AND Areas_og_title_translation.content != :c66 AND Areas_og_title_translation.locale = :c67 AND Areas.id = (Areas_og_title_translation.foreign_key)) LEFT JOIN i18n Areas_og_type_translation ON (Areas_og_type_translation.model = :c68 AND Areas_og_type_translation.field = :c69 AND Areas_og_type_translation.content != :c70 AND Areas_og_type_translation.locale = :c71 AND Areas.id = (Areas_og_type_translation.foreign_key)) LEFT JOIN i18n Countries_name_translation ON (Countries_name_translation.model = :c72 AND Countries_name_translation.field = :c73 AND Countries_name_translation.content != :c74 AND Countries_name_translation.locale = :c75 AND Countries.id = (Countries_name_translation.foreign_key)) LEFT JOIN i18n Countries_meta_title_translation ON (Countries_meta_title_translation.model = :c76 AND Countries_meta_title_translation.field = :c77 AND Countries_meta_title_translation.content != :c78 AND Countries_meta_title_translation.locale = :c79 AND Countries.id = (Countries_meta_title_translation.foreign_key)) LEFT JOIN i18n Countries_meta_keywords_translation ON (Countries_meta_keywords_translation.model = :c80 AND Countries_meta_keywords_translation.field = :c81 AND Countries_meta_keywords_translation.content != :c82 AND Countries_meta_keywords_translation.locale = :c83 AND Countries.id = (Countries_meta_keywords_translation.foreign_key)) LEFT JOIN i18n Countries_meta_descriptions_translation ON (Countries_meta_descriptions_translation.model = :c84 AND Countries_meta_descriptions_translation.field = :c85 AND Countries_meta_descriptions_translation.content != :c86 AND Countries_meta_descriptions_translation.locale = :c87 AND Countries.id = (Countries_meta_descriptions_translation.foreign_key)) LEFT JOIN i18n Countries_og_title_translation ON (Countries_og_title_translation.model = :c88 AND Countries_og_title_translation.field = :c89 AND Countries_og_title_translation.content != :c90 AND Countries_og_title_translation.locale = :c91 AND Countries.id = (Countries_og_title_translation.foreign_key)) LEFT JOIN i18n Countries_og_type_translation ON (Countries_og_type_translation.model = :c92 AND Countries_og_type_translation.field = :c93 AND Countries_og_type_translation.content != :c94 AND Countries_og_type_translation.locale = :c95 AND Countries.id = (Countries_og_type_translation.foreign_key)) WHERE (Leases.country_id = :c96 AND Leases.area_id = :c97 AND Leases.status = :c98) GROUP BY Leases.id  ORDER BY Leases.lease_order ASC, Leases.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]
		],
		':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]
		]
	],
	'defaultTypes' => [
		'Leases__id' => 'integer',
		'Leases.id' => 'integer',
		'id' => 'integer',
		'Leases__name' => 'string',
		'Leases.name' => 'string',
		'name' => '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' => 'string',
		'Areas.meta_descriptions' => 'string',
		'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' => 'string',
		'Countries.meta_descriptions' => 'string',
		'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',
		'LeasesAvailability__id' => 'integer',
		'LeasesAvailability.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',
		'LeasesAvailability__price_type_id' => 'integer',
		'LeasesAvailability.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',
		'LeasesAvailability__number_of_pax' => 'integer',
		'LeasesAvailability.number_of_pax' => 'integer',
		'number_of_pax' => 'integer',
		'LeasesAvailability__availability' => 'integer',
		'LeasesAvailability.availability' => 'integer',
		'availability' => 'integer',
		'LeasesAvailability__deleted' => 'datetime',
		'LeasesAvailability.deleted' => 'datetime',
		'deleted' => 'datetime',
		'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_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) 1,
	'executed' => true,
	'hydrate' => true,
	'buffered' => true,
	'formatters' => (int) 4,
	'mapReducers' => (int) 0,
	'contain' => [
		'Prices' => [
			[maximum depth reached]
		],
		'Offices' => [
			[maximum depth reached]
		],
		'Areas' => [
			[maximum depth reached]
		],
		'Countries' => [
			[maximum depth reached]
		],
		'LeasesAvailability' => [[maximum depth reached]],
		'Leases_name_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) {}

}
$properties_list = 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_name_translation.id AS `Leases_name_translation__id`, Leases_name_translation.content AS `Leases_name_translation__content` FROM leases Leases 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_address_translation ON (Leases_address_translation.model = :c4 AND Leases_address_translation.field = :c5 AND Leases_address_translation.content != :c6 AND Leases_address_translation.locale = :c7 AND Leases.id = (Leases_address_translation.foreign_key)) LEFT JOIN i18n Leases_descriptions_translation ON (Leases_descriptions_translation.model = :c8 AND Leases_descriptions_translation.field = :c9 AND Leases_descriptions_translation.content != :c10 AND Leases_descriptions_translation.locale = :c11 AND Leases.id = (Leases_descriptions_translation.foreign_key)) LEFT JOIN i18n Leases_meta_title_translation ON (Leases_meta_title_translation.model = :c12 AND Leases_meta_title_translation.field = :c13 AND Leases_meta_title_translation.content != :c14 AND Leases_meta_title_translation.locale = :c15 AND Leases.id = (Leases_meta_title_translation.foreign_key)) LEFT JOIN i18n Leases_meta_keywords_translation ON (Leases_meta_keywords_translation.model = :c16 AND Leases_meta_keywords_translation.field = :c17 AND Leases_meta_keywords_translation.content != :c18 AND Leases_meta_keywords_translation.locale = :c19 AND Leases.id = (Leases_meta_keywords_translation.foreign_key)) LEFT JOIN i18n Leases_meta_descriptions_translation ON (Leases_meta_descriptions_translation.model = :c20 AND Leases_meta_descriptions_translation.field = :c21 AND Leases_meta_descriptions_translation.content != :c22 AND Leases_meta_descriptions_translation.locale = :c23 AND Leases.id = (Leases_meta_descriptions_translation.foreign_key)) LEFT JOIN i18n Leases_og_title_translation ON (Leases_og_title_translation.model = :c24 AND Leases_og_title_translation.field = :c25 AND Leases_og_title_translation.content != :c26 AND Leases_og_title_translation.locale = :c27 AND Leases.id = (Leases_og_title_translation.foreign_key)) LEFT JOIN i18n Leases_og_type_translation ON (Leases_og_type_translation.model = :c28 AND Leases_og_type_translation.field = :c29 AND Leases_og_type_translation.content != :c30 AND Leases_og_type_translation.locale = :c31 AND Leases.id = (Leases_og_type_translation.foreign_key)) LEFT JOIN i18n Leases_top_features_translation ON (Leases_top_features_translation.model = :c32 AND Leases_top_features_translation.field = :c33 AND Leases_top_features_translation.content != :c34 AND Leases_top_features_translation.locale = :c35 AND Leases.id = (Leases_top_features_translation.foreign_key)) LEFT JOIN i18n Leases_current_availability_translation ON (Leases_current_availability_translation.model = :c36 AND Leases_current_availability_translation.field = :c37 AND Leases_current_availability_translation.content != :c38 AND Leases_current_availability_translation.locale = :c39 AND Leases.id = (Leases_current_availability_translation.foreign_key)) LEFT JOIN i18n Leases_walking_distance_translation ON (Leases_walking_distance_translation.model = :c40 AND Leases_walking_distance_translation.field = :c41 AND Leases_walking_distance_translation.content != :c42 AND Leases_walking_distance_translation.locale = :c43 AND Leases.id = (Leases_walking_distance_translation.foreign_key))',
	'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]
		]
	],
	'defaultTypes' => [
		'Leases__id' => 'integer',
		'Leases.id' => 'integer',
		'id' => 'integer',
		'Leases__name' => 'string',
		'Leases.name' => 'string',
		'name' => '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',
		'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_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'
	],
	'decorators' => (int) 0,
	'executed' => false,
	'hydrate' => true,
	'buffered' => true,
	'formatters' => (int) 2,
	'mapReducers' => (int) 0,
	'contain' => [
		'Leases_name_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) {}

}
$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.slug AS `Offices__slug`, Offices.status AS `Offices__status`, Offices.created AS `Offices__created`, Offices.modified AS `Offices__modified`, 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` 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) 1,
	'mapReducers' => (int) 0,
	'contain' => [
		'Offices_name_translation' => [
			[maximum depth reached]
		]
	],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\OfficesTable) {}

}
$filter = []
$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' => 'string',
		'Countries.meta_descriptions' => 'string',
		'meta_descriptions' => 'string',
		'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) {}

}
$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' => 'string',
		'Areas.meta_descriptions' => 'string',
		'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) 1,
	'executed' => true,
	'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) {}

}
$locationC = object(App\Model\Entity\Country) {

	'id' => (int) 98,
	'name' => '香港',
	'slug' => 'hong-kong',
	'parent_country' => (int) 96,
	'active' => (int) 1,
	'country_order' => (int) 1,
	'meta_title' => '香港服務式辦公室/商務中心指南 - Workspace Asia',
	'meta_keywords' => '香港辦公室出租，服務式辦公室，商務中心，共享工作間',
	'meta_descriptions' => '想在香港租辦公室？立即上Workspace Asia尋找你的理想服務式辦公室或共享工作間。全港超過二百個地點，覆蓋整個市場，提供詳細價格及環境資料。請致電+852 3018 4832查詢！',
	'og_title' => '',
	'og_type' => null,
	'og_image' => '/uploads/hong_kong/central_building/cb_3.jpg',
	'modified' => object(Cake\I18n\Time) {},
	'_locale' => 'zh_TW',
	'[new]' => false,
	'[accessible]' => [
		'*' => true,
		'id' => false
	],
	'[dirty]' => [],
	'[original]' => [],
	'[virtual]' => [],
	'[errors]' => [],
	'[invalid]' => [],
	'[repository]' => 'Countries'

}
$locationA = object(App\Model\Entity\Area) {

	'id' => (int) 57,
	'name' => '九龍灣',
	'slug' => 'kowloon-bay',
	'country_id' => (int) 98,
	'state_id' => (int) 2,
	'status' => (int) 1,
	'area_order' => (int) 11,
	'popular_location' => (int) 0,
	'meta_title' => '香港九龍灣服務式辦公室/商務中心指南 - Workspace Asia',
	'meta_keywords' => '九龍灣辦公室出租，服務式辦公室，商務中心，共享工作間',
	'meta_descriptions' => '想在九龍灣租辦公室？立即上Workspace Asia尋找你的理想服務式辦公室或共享工作間。全港超過二百個地點，覆蓋整個市場，提供詳細價格及環境資料。請致電+852 9231 0043查詢！',
	'og_title' => '',
	'og_type' => null,
	'og_image' => '/uploads/hong_kong/mega_cube/a-1552889783965.jpg',
	'modified' => object(Cake\I18n\Time) {},
	'_locale' => 'zh_TW',
	'[new]' => false,
	'[accessible]' => [
		'*' => true,
		'id' => false
	],
	'[dirty]' => [],
	'[original]' => [],
	'[virtual]' => [],
	'[errors]' => [],
	'[invalid]' => [],
	'[repository]' => 'Areas'

}
$locationO = ''
$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) {}

}
$pageLimit = (int) 9
$area_ids = []
$total_properties = (int) 5
$seoText = '想在九龍灣租辦公室？立即上Workspace Asia尋找你的理想服務式辦公室或共享工作間。全港超過二百個地點，覆蓋整個市場，提供詳細價格及環境資料。請致電+852 9231 0043查詢！'
$buildings = object(Cake\ORM\Query) {

	'(help)' => 'This is a Query object, to get the results execute or iterate it.',
	'sql' => 'SELECT Buildings.id AS `Buildings__id`, Buildings.name AS `Buildings__name`, Buildings.slug AS `Buildings__slug`, Buildings.country_id AS `Buildings__country_id`, Buildings.state_id AS `Buildings__state_id`, Buildings.area_id AS `Buildings__area_id`, Buildings.featured_image AS `Buildings__featured_image`, Buildings.images AS `Buildings__images`, Buildings.ownership AS `Buildings__ownership`, Buildings.completed_at AS `Buildings__completed_at`, Buildings.total_gfa AS `Buildings__total_gfa`, Buildings.floor_numbers AS `Buildings__floor_numbers`, Buildings.air_con_hours AS `Buildings__air_con_hours`, Buildings.floor_system AS `Buildings__floor_system`, Buildings.lift AS `Buildings__lift`, Buildings.ceiling_height AS `Buildings__ceiling_height`, Buildings.carpark_facilities AS `Buildings__carpark_facilities`, Buildings.transportation AS `Buildings__transportation`, Buildings.leases AS `Buildings__leases`, Buildings.floor_plan_image AS `Buildings__floor_plan_image`, Buildings.lat AS `Buildings__lat`, Buildings.lng AS `Buildings__lng`, Buildings.status AS `Buildings__status`, Buildings.address AS `Buildings__address`, Buildings.descriptions AS `Buildings__descriptions`, Buildings.meta_title AS `Buildings__meta_title`, Buildings.meta_keywords AS `Buildings__meta_keywords`, Buildings.meta_descriptions AS `Buildings__meta_descriptions`, Buildings.og_title AS `Buildings__og_title`, Buildings.og_type AS `Buildings__og_type`, Buildings.og_image AS `Buildings__og_image`, Buildings.created AS `Buildings__created`, Buildings.modified AS `Buildings__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`, 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`, 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`, Buildings_name_translation.id AS `Buildings_name_translation__id`, Buildings_name_translation.locale AS `Buildings_name_translation__locale`, Buildings_name_translation.model AS `Buildings_name_translation__model`, Buildings_name_translation.foreign_key AS `Buildings_name_translation__foreign_key`, Buildings_name_translation.field AS `Buildings_name_translation__field`, Buildings_name_translation.content AS `Buildings_name_translation__content`, Buildings_address_translation.id AS `Buildings_address_translation__id`, Buildings_address_translation.locale AS `Buildings_address_translation__locale`, Buildings_address_translation.model AS `Buildings_address_translation__model`, Buildings_address_translation.foreign_key AS `Buildings_address_translation__foreign_key`, Buildings_address_translation.field AS `Buildings_address_translation__field`, Buildings_address_translation.content AS `Buildings_address_translation__content`, Buildings_descriptions_translation.id AS `Buildings_descriptions_translation__id`, Buildings_descriptions_translation.locale AS `Buildings_descriptions_translation__locale`, Buildings_descriptions_translation.model AS `Buildings_descriptions_translation__model`, Buildings_descriptions_translation.foreign_key AS `Buildings_descriptions_translation__foreign_key`, Buildings_descriptions_translation.field AS `Buildings_descriptions_translation__field`, Buildings_descriptions_translation.content AS `Buildings_descriptions_translation__content`, Buildings_ownership_translation.id AS `Buildings_ownership_translation__id`, Buildings_ownership_translation.locale AS `Buildings_ownership_translation__locale`, Buildings_ownership_translation.model AS `Buildings_ownership_translation__model`, Buildings_ownership_translation.foreign_key AS `Buildings_ownership_translation__foreign_key`, Buildings_ownership_translation.field AS `Buildings_ownership_translation__field`, Buildings_ownership_translation.content AS `Buildings_ownership_translation__content`, Buildings_air_con_hours_translation.id AS `Buildings_air_con_hours_translation__id`, Buildings_air_con_hours_translation.locale AS `Buildings_air_con_hours_translation__locale`, Buildings_air_con_hours_translation.model AS `Buildings_air_con_hours_translation__model`, Buildings_air_con_hours_translation.foreign_key AS `Buildings_air_con_hours_translation__foreign_key`, Buildings_air_con_hours_translation.field AS `Buildings_air_con_hours_translation__field`, Buildings_air_con_hours_translation.content AS `Buildings_air_con_hours_translation__content`, Buildings_floor_system_translation.id AS `Buildings_floor_system_translation__id`, Buildings_floor_system_translation.locale AS `Buildings_floor_system_translation__locale`, Buildings_floor_system_translation.model AS `Buildings_floor_system_translation__model`, Buildings_floor_system_translation.foreign_key AS `Buildings_floor_system_translation__foreign_key`, Buildings_floor_system_translation.field AS `Buildings_floor_system_translation__field`, Buildings_floor_system_translation.content AS `Buildings_floor_system_translation__content`, Buildings_lift_translation.id AS `Buildings_lift_translation__id`, Buildings_lift_translation.locale AS `Buildings_lift_translation__locale`, Buildings_lift_translation.model AS `Buildings_lift_translation__model`, Buildings_lift_translation.foreign_key AS `Buildings_lift_translation__foreign_key`, Buildings_lift_translation.field AS `Buildings_lift_translation__field`, Buildings_lift_translation.content AS `Buildings_lift_translation__content`, Buildings_ceiling_height_translation.id AS `Buildings_ceiling_height_translation__id`, Buildings_ceiling_height_translation.locale AS `Buildings_ceiling_height_translation__locale`, Buildings_ceiling_height_translation.model AS `Buildings_ceiling_height_translation__model`, Buildings_ceiling_height_translation.foreign_key AS `Buildings_ceiling_height_translation__foreign_key`, Buildings_ceiling_height_translation.field AS `Buildings_ceiling_height_translation__field`, Buildings_ceiling_height_translation.content AS `Buildings_ceiling_height_translation__content`, Buildings_carpark_facilities_translation.id AS `Buildings_carpark_facilities_translation__id`, Buildings_carpark_facilities_translation.locale AS `Buildings_carpark_facilities_translation__locale`, Buildings_carpark_facilities_translation.model AS `Buildings_carpark_facilities_translation__model`, Buildings_carpark_facilities_translation.foreign_key AS `Buildings_carpark_facilities_translation__foreign_key`, Buildings_carpark_facilities_translation.field AS `Buildings_carpark_facilities_translation__field`, Buildings_carpark_facilities_translation.content AS `Buildings_carpark_facilities_translation__content`, Buildings_transportation_translation.id AS `Buildings_transportation_translation__id`, Buildings_transportation_translation.locale AS `Buildings_transportation_translation__locale`, Buildings_transportation_translation.model AS `Buildings_transportation_translation__model`, Buildings_transportation_translation.foreign_key AS `Buildings_transportation_translation__foreign_key`, Buildings_transportation_translation.field AS `Buildings_transportation_translation__field`, Buildings_transportation_translation.content AS `Buildings_transportation_translation__content`, Buildings_meta_title_translation.id AS `Buildings_meta_title_translation__id`, Buildings_meta_title_translation.locale AS `Buildings_meta_title_translation__locale`, Buildings_meta_title_translation.model AS `Buildings_meta_title_translation__model`, Buildings_meta_title_translation.foreign_key AS `Buildings_meta_title_translation__foreign_key`, Buildings_meta_title_translation.field AS `Buildings_meta_title_translation__field`, Buildings_meta_title_translation.content AS `Buildings_meta_title_translation__content`, Buildings_meta_keywords_translation.id AS `Buildings_meta_keywords_translation__id`, Buildings_meta_keywords_translation.locale AS `Buildings_meta_keywords_translation__locale`, Buildings_meta_keywords_translation.model AS `Buildings_meta_keywords_translation__model`, Buildings_meta_keywords_translation.foreign_key AS `Buildings_meta_keywords_translation__foreign_key`, Buildings_meta_keywords_translation.field AS `Buildings_meta_keywords_translation__field`, Buildings_meta_keywords_translation.content AS `Buildings_meta_keywords_translation__content`, Buildings_meta_descriptions_translation.id AS `Buildings_meta_descriptions_translation__id`, Buildings_meta_descriptions_translation.locale AS `Buildings_meta_descriptions_translation__locale`, Buildings_meta_descriptions_translation.model AS `Buildings_meta_descriptions_translation__model`, Buildings_meta_descriptions_translation.foreign_key AS `Buildings_meta_descriptions_translation__foreign_key`, Buildings_meta_descriptions_translation.field AS `Buildings_meta_descriptions_translation__field`, Buildings_meta_descriptions_translation.content AS `Buildings_meta_descriptions_translation__content`, Buildings_og_title_translation.id AS `Buildings_og_title_translation__id`, Buildings_og_title_translation.locale AS `Buildings_og_title_translation__locale`, Buildings_og_title_translation.model AS `Buildings_og_title_translation__model`, Buildings_og_title_translation.foreign_key AS `Buildings_og_title_translation__foreign_key`, Buildings_og_title_translation.field AS `Buildings_og_title_translation__field`, Buildings_og_title_translation.content AS `Buildings_og_title_translation__content`, Buildings_og_type_translation.id AS `Buildings_og_type_translation__id`, Buildings_og_type_translation.locale AS `Buildings_og_type_translation__locale`, Buildings_og_type_translation.model AS `Buildings_og_type_translation__model`, Buildings_og_type_translation.foreign_key AS `Buildings_og_type_translation__foreign_key`, Buildings_og_type_translation.field AS `Buildings_og_type_translation__field`, Buildings_og_type_translation.content AS `Buildings_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`, 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`, 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` FROM buildings Buildings INNER JOIN countries Countries ON Countries.id = (Buildings.country_id) INNER JOIN states States ON States.id = (Buildings.state_id) INNER JOIN areas Areas ON Areas.id = (Buildings.area_id) LEFT JOIN i18n Buildings_name_translation ON (Buildings_name_translation.model = :c0 AND Buildings_name_translation.field = :c1 AND Buildings_name_translation.content != :c2 AND Buildings_name_translation.locale = :c3 AND Buildings.id = (Buildings_name_translation.foreign_key)) LEFT JOIN i18n Buildings_address_translation ON (Buildings_address_translation.model = :c4 AND Buildings_address_translation.field = :c5 AND Buildings_address_translation.content != :c6 AND Buildings_address_translation.locale = :c7 AND Buildings.id = (Buildings_address_translation.foreign_key)) LEFT JOIN i18n Buildings_descriptions_translation ON (Buildings_descriptions_translation.model = :c8 AND Buildings_descriptions_translation.field = :c9 AND Buildings_descriptions_translation.content != :c10 AND Buildings_descriptions_translation.locale = :c11 AND Buildings.id = (Buildings_descriptions_translation.foreign_key)) LEFT JOIN i18n Buildings_ownership_translation ON (Buildings_ownership_translation.model = :c12 AND Buildings_ownership_translation.field = :c13 AND Buildings_ownership_translation.content != :c14 AND Buildings_ownership_translation.locale = :c15 AND Buildings.id = (Buildings_ownership_translation.foreign_key)) LEFT JOIN i18n Buildings_air_con_hours_translation ON (Buildings_air_con_hours_translation.model = :c16 AND Buildings_air_con_hours_translation.field = :c17 AND Buildings_air_con_hours_translation.content != :c18 AND Buildings_air_con_hours_translation.locale = :c19 AND Buildings.id = (Buildings_air_con_hours_translation.foreign_key)) LEFT JOIN i18n Buildings_floor_system_translation ON (Buildings_floor_system_translation.model = :c20 AND Buildings_floor_system_translation.field = :c21 AND Buildings_floor_system_translation.content != :c22 AND Buildings_floor_system_translation.locale = :c23 AND Buildings.id = (Buildings_floor_system_translation.foreign_key)) LEFT JOIN i18n Buildings_lift_translation ON (Buildings_lift_translation.model = :c24 AND Buildings_lift_translation.field = :c25 AND Buildings_lift_translation.content != :c26 AND Buildings_lift_translation.locale = :c27 AND Buildings.id = (Buildings_lift_translation.foreign_key)) LEFT JOIN i18n Buildings_ceiling_height_translation ON (Buildings_ceiling_height_translation.model = :c28 AND Buildings_ceiling_height_translation.field = :c29 AND Buildings_ceiling_height_translation.content != :c30 AND Buildings_ceiling_height_translation.locale = :c31 AND Buildings.id = (Buildings_ceiling_height_translation.foreign_key)) LEFT JOIN i18n Buildings_carpark_facilities_translation ON (Buildings_carpark_facilities_translation.model = :c32 AND Buildings_carpark_facilities_translation.field = :c33 AND Buildings_carpark_facilities_translation.content != :c34 AND Buildings_carpark_facilities_translation.locale = :c35 AND Buildings.id = (Buildings_carpark_facilities_translation.foreign_key)) LEFT JOIN i18n Buildings_transportation_translation ON (Buildings_transportation_translation.model = :c36 AND Buildings_transportation_translation.field = :c37 AND Buildings_transportation_translation.content != :c38 AND Buildings_transportation_translation.locale = :c39 AND Buildings.id = (Buildings_transportation_translation.foreign_key)) LEFT JOIN i18n Buildings_meta_title_translation ON (Buildings_meta_title_translation.model = :c40 AND Buildings_meta_title_translation.field = :c41 AND Buildings_meta_title_translation.content != :c42 AND Buildings_meta_title_translation.locale = :c43 AND Buildings.id = (Buildings_meta_title_translation.foreign_key)) LEFT JOIN i18n Buildings_meta_keywords_translation ON (Buildings_meta_keywords_translation.model = :c44 AND Buildings_meta_keywords_translation.field = :c45 AND Buildings_meta_keywords_translation.content != :c46 AND Buildings_meta_keywords_translation.locale = :c47 AND Buildings.id = (Buildings_meta_keywords_translation.foreign_key)) LEFT JOIN i18n Buildings_meta_descriptions_translation ON (Buildings_meta_descriptions_translation.model = :c48 AND Buildings_meta_descriptions_translation.field = :c49 AND Buildings_meta_descriptions_translation.content != :c50 AND Buildings_meta_descriptions_translation.locale = :c51 AND Buildings.id = (Buildings_meta_descriptions_translation.foreign_key)) LEFT JOIN i18n Buildings_og_title_translation ON (Buildings_og_title_translation.model = :c52 AND Buildings_og_title_translation.field = :c53 AND Buildings_og_title_translation.content != :c54 AND Buildings_og_title_translation.locale = :c55 AND Buildings.id = (Buildings_og_title_translation.foreign_key)) LEFT JOIN i18n Buildings_og_type_translation ON (Buildings_og_type_translation.model = :c56 AND Buildings_og_type_translation.field = :c57 AND Buildings_og_type_translation.content != :c58 AND Buildings_og_type_translation.locale = :c59 AND Buildings.id = (Buildings_og_type_translation.foreign_key)) LEFT JOIN i18n Countries_name_translation ON (Countries_name_translation.model = :c60 AND Countries_name_translation.field = :c61 AND Countries_name_translation.content != :c62 AND Countries_name_translation.locale = :c63 AND Countries.id = (Countries_name_translation.foreign_key)) LEFT JOIN i18n Countries_meta_title_translation ON (Countries_meta_title_translation.model = :c64 AND Countries_meta_title_translation.field = :c65 AND Countries_meta_title_translation.content != :c66 AND Countries_meta_title_translation.locale = :c67 AND Countries.id = (Countries_meta_title_translation.foreign_key)) LEFT JOIN i18n Countries_meta_keywords_translation ON (Countries_meta_keywords_translation.model = :c68 AND Countries_meta_keywords_translation.field = :c69 AND Countries_meta_keywords_translation.content != :c70 AND Countries_meta_keywords_translation.locale = :c71 AND Countries.id = (Countries_meta_keywords_translation.foreign_key)) LEFT JOIN i18n Countries_meta_descriptions_translation ON (Countries_meta_descriptions_translation.model = :c72 AND Countries_meta_descriptions_translation.field = :c73 AND Countries_meta_descriptions_translation.content != :c74 AND Countries_meta_descriptions_translation.locale = :c75 AND Countries.id = (Countries_meta_descriptions_translation.foreign_key)) LEFT JOIN i18n Countries_og_title_translation ON (Countries_og_title_translation.model = :c76 AND Countries_og_title_translation.field = :c77 AND Countries_og_title_translation.content != :c78 AND Countries_og_title_translation.locale = :c79 AND Countries.id = (Countries_og_title_translation.foreign_key)) LEFT JOIN i18n Countries_og_type_translation ON (Countries_og_type_translation.model = :c80 AND Countries_og_type_translation.field = :c81 AND Countries_og_type_translation.content != :c82 AND Countries_og_type_translation.locale = :c83 AND Countries.id = (Countries_og_type_translation.foreign_key)) LEFT JOIN i18n States_name_translation ON (States_name_translation.model = :c84 AND States_name_translation.field = :c85 AND States_name_translation.content != :c86 AND States_name_translation.locale = :c87 AND States.id = (States_name_translation.foreign_key)) LEFT JOIN i18n States_meta_title_translation ON (States_meta_title_translation.model = :c88 AND States_meta_title_translation.field = :c89 AND States_meta_title_translation.content != :c90 AND States_meta_title_translation.locale = :c91 AND States.id = (States_meta_title_translation.foreign_key)) LEFT JOIN i18n States_meta_keywords_translation ON (States_meta_keywords_translation.model = :c92 AND States_meta_keywords_translation.field = :c93 AND States_meta_keywords_translation.content != :c94 AND States_meta_keywords_translation.locale = :c95 AND States.id = (States_meta_keywords_translation.foreign_key)) LEFT JOIN i18n States_meta_descriptions_translation ON (States_meta_descriptions_translation.model = :c96 AND States_meta_descriptions_translation.field = :c97 AND States_meta_descriptions_translation.content != :c98 AND States_meta_descriptions_translation.locale = :c99 AND States.id = (States_meta_descriptions_translation.foreign_key)) LEFT JOIN i18n States_og_title_translation ON (States_og_title_translation.model = :c100 AND States_og_title_translation.field = :c101 AND States_og_title_translation.content != :c102 AND States_og_title_translation.locale = :c103 AND States.id = (States_og_title_translation.foreign_key)) LEFT JOIN i18n States_og_type_translation ON (States_og_type_translation.model = :c104 AND States_og_type_translation.field = :c105 AND States_og_type_translation.content != :c106 AND States_og_type_translation.locale = :c107 AND States.id = (States_og_type_translation.foreign_key)) LEFT JOIN i18n Areas_name_translation ON (Areas_name_translation.model = :c108 AND Areas_name_translation.field = :c109 AND Areas_name_translation.content != :c110 AND Areas_name_translation.locale = :c111 AND Areas.id = (Areas_name_translation.foreign_key)) LEFT JOIN i18n Areas_meta_title_translation ON (Areas_meta_title_translation.model = :c112 AND Areas_meta_title_translation.field = :c113 AND Areas_meta_title_translation.content != :c114 AND Areas_meta_title_translation.locale = :c115 AND Areas.id = (Areas_meta_title_translation.foreign_key)) LEFT JOIN i18n Areas_meta_keywords_translation ON (Areas_meta_keywords_translation.model = :c116 AND Areas_meta_keywords_translation.field = :c117 AND Areas_meta_keywords_translation.content != :c118 AND Areas_meta_keywords_translation.locale = :c119 AND Areas.id = (Areas_meta_keywords_translation.foreign_key)) LEFT JOIN i18n Areas_meta_descriptions_translation ON (Areas_meta_descriptions_translation.model = :c120 AND Areas_meta_descriptions_translation.field = :c121 AND Areas_meta_descriptions_translation.content != :c122 AND Areas_meta_descriptions_translation.locale = :c123 AND Areas.id = (Areas_meta_descriptions_translation.foreign_key)) LEFT JOIN i18n Areas_og_title_translation ON (Areas_og_title_translation.model = :c124 AND Areas_og_title_translation.field = :c125 AND Areas_og_title_translation.content != :c126 AND Areas_og_title_translation.locale = :c127 AND Areas.id = (Areas_og_title_translation.foreign_key)) LEFT JOIN i18n Areas_og_type_translation ON (Areas_og_type_translation.model = :c128 AND Areas_og_type_translation.field = :c129 AND Areas_og_type_translation.content != :c130 AND Areas_og_type_translation.locale = :c131 AND Areas.id = (Areas_og_type_translation.foreign_key)) WHERE (Buildings.status = :c132 AND Buildings.country_id = :c133 AND Buildings.area_id = :c134) ORDER BY Buildings.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]
		],
		':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]
		],
		':c108' => [
			[maximum depth reached]
		],
		':c109' => [
			[maximum depth reached]
		],
		':c110' => [
			[maximum depth reached]
		],
		':c111' => [
			[maximum depth reached]
		],
		':c112' => [
			[maximum depth reached]
		],
		':c113' => [
			[maximum depth reached]
		],
		':c114' => [
			[maximum depth reached]
		],
		':c115' => [
			[maximum depth reached]
		],
		':c116' => [
			[maximum depth reached]
		],
		':c117' => [
			[maximum depth reached]
		],
		':c118' => [
			[maximum depth reached]
		],
		':c119' => [
			[maximum depth reached]
		],
		':c120' => [
			[maximum depth reached]
		],
		':c121' => [
			[maximum depth reached]
		],
		':c122' => [
			[maximum depth reached]
		],
		':c123' => [
			[maximum depth reached]
		],
		':c124' => [
			[maximum depth reached]
		],
		':c125' => [
			[maximum depth reached]
		],
		':c126' => [
			[maximum depth reached]
		],
		':c127' => [
			[maximum depth reached]
		],
		':c128' => [
			[maximum depth reached]
		],
		':c129' => [
			[maximum depth reached]
		],
		':c130' => [
			[maximum depth reached]
		],
		':c131' => [
			[maximum depth reached]
		],
		':c132' => [
			[maximum depth reached]
		],
		':c133' => [
			[maximum depth reached]
		],
		':c134' => [
			[maximum depth reached]
		]
	],
	'defaultTypes' => [
		'Buildings__id' => 'integer',
		'Buildings.id' => 'integer',
		'id' => 'integer',
		'Buildings__name' => 'string',
		'Buildings.name' => 'string',
		'name' => 'string',
		'Buildings__slug' => 'string',
		'Buildings.slug' => 'string',
		'slug' => 'string',
		'Buildings__country_id' => 'integer',
		'Buildings.country_id' => 'integer',
		'country_id' => 'integer',
		'Buildings__state_id' => 'integer',
		'Buildings.state_id' => 'integer',
		'state_id' => 'integer',
		'Buildings__area_id' => 'integer',
		'Buildings.area_id' => 'integer',
		'area_id' => 'integer',
		'Buildings__featured_image' => 'text',
		'Buildings.featured_image' => 'text',
		'featured_image' => 'text',
		'Buildings__images' => 'text',
		'Buildings.images' => 'text',
		'images' => 'text',
		'Buildings__ownership' => 'string',
		'Buildings.ownership' => 'string',
		'ownership' => 'string',
		'Buildings__completed_at' => 'string',
		'Buildings.completed_at' => 'string',
		'completed_at' => 'string',
		'Buildings__total_gfa' => 'string',
		'Buildings.total_gfa' => 'string',
		'total_gfa' => 'string',
		'Buildings__floor_numbers' => 'integer',
		'Buildings.floor_numbers' => 'integer',
		'floor_numbers' => 'integer',
		'Buildings__air_con_hours' => 'text',
		'Buildings.air_con_hours' => 'text',
		'air_con_hours' => 'text',
		'Buildings__floor_system' => 'string',
		'Buildings.floor_system' => 'string',
		'floor_system' => 'string',
		'Buildings__lift' => 'string',
		'Buildings.lift' => 'string',
		'lift' => 'string',
		'Buildings__ceiling_height' => 'string',
		'Buildings.ceiling_height' => 'string',
		'ceiling_height' => 'string',
		'Buildings__carpark_facilities' => 'text',
		'Buildings.carpark_facilities' => 'text',
		'carpark_facilities' => 'text',
		'Buildings__transportation' => 'text',
		'Buildings.transportation' => 'text',
		'transportation' => 'text',
		'Buildings__leases' => 'text',
		'Buildings.leases' => 'text',
		'leases' => 'text',
		'Buildings__floor_plan_image' => 'text',
		'Buildings.floor_plan_image' => 'text',
		'floor_plan_image' => 'text',
		'Buildings__lat' => 'string',
		'Buildings.lat' => 'string',
		'lat' => 'string',
		'Buildings__lng' => 'string',
		'Buildings.lng' => 'string',
		'lng' => 'string',
		'Buildings__status' => 'integer',
		'Buildings.status' => 'integer',
		'status' => 'integer',
		'Buildings__address' => 'string',
		'Buildings.address' => 'string',
		'address' => 'string',
		'Buildings__descriptions' => 'text',
		'Buildings.descriptions' => 'text',
		'descriptions' => 'text',
		'Buildings__meta_title' => 'string',
		'Buildings.meta_title' => 'string',
		'meta_title' => 'string',
		'Buildings__meta_keywords' => 'string',
		'Buildings.meta_keywords' => 'string',
		'meta_keywords' => 'string',
		'Buildings__meta_descriptions' => 'string',
		'Buildings.meta_descriptions' => 'string',
		'meta_descriptions' => 'string',
		'Buildings__og_title' => 'string',
		'Buildings.og_title' => 'string',
		'og_title' => 'string',
		'Buildings__og_type' => 'string',
		'Buildings.og_type' => 'string',
		'og_type' => 'string',
		'Buildings__og_image' => 'text',
		'Buildings.og_image' => 'text',
		'og_image' => 'text',
		'Buildings__created' => 'datetime',
		'Buildings.created' => 'datetime',
		'created' => 'datetime',
		'Buildings__modified' => 'timestamp',
		'Buildings.modified' => 'timestamp',
		'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' => 'string',
		'Countries.meta_descriptions' => 'string',
		'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',
		'States__id' => 'integer',
		'States.id' => 'integer',
		'States__country_id' => 'integer',
		'States.country_id' => 'integer',
		'States__name' => 'string',
		'States.name' => 'string',
		'States__slug' => 'string',
		'States.slug' => 'string',
		'States__status' => 'boolean',
		'States.status' => 'boolean',
		'States__state_order' => 'integer',
		'States.state_order' => 'integer',
		'state_order' => 'integer',
		'States__meta_title' => 'string',
		'States.meta_title' => 'string',
		'States__meta_keywords' => 'string',
		'States.meta_keywords' => 'string',
		'States__meta_descriptions' => 'string',
		'States.meta_descriptions' => 'string',
		'States__og_title' => 'string',
		'States.og_title' => 'string',
		'States__og_type' => 'string',
		'States.og_type' => 'string',
		'States__og_image' => 'text',
		'States.og_image' => 'text',
		'States__modified' => 'timestamp',
		'States.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',
		'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' => 'string',
		'Areas.meta_descriptions' => 'string',
		'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',
		'Buildings_name_translation__id' => 'integer',
		'Buildings_name_translation.id' => 'integer',
		'Buildings_name_translation__locale' => 'string',
		'Buildings_name_translation.locale' => 'string',
		'locale' => 'string',
		'Buildings_name_translation__model' => 'string',
		'Buildings_name_translation.model' => 'string',
		'model' => 'string',
		'Buildings_name_translation__foreign_key' => 'integer',
		'Buildings_name_translation.foreign_key' => 'integer',
		'foreign_key' => 'integer',
		'Buildings_name_translation__field' => 'string',
		'Buildings_name_translation.field' => 'string',
		'field' => 'string',
		'Buildings_name_translation__content' => 'text',
		'Buildings_name_translation.content' => 'text',
		'content' => 'text',
		'Buildings_address_translation__id' => 'integer',
		'Buildings_address_translation.id' => 'integer',
		'Buildings_address_translation__locale' => 'string',
		'Buildings_address_translation.locale' => 'string',
		'Buildings_address_translation__model' => 'string',
		'Buildings_address_translation.model' => 'string',
		'Buildings_address_translation__foreign_key' => 'integer',
		'Buildings_address_translation.foreign_key' => 'integer',
		'Buildings_address_translation__field' => 'string',
		'Buildings_address_translation.field' => 'string',
		'Buildings_address_translation__content' => 'text',
		'Buildings_address_translation.content' => 'text',
		'Buildings_descriptions_translation__id' => 'integer',
		'Buildings_descriptions_translation.id' => 'integer',
		'Buildings_descriptions_translation__locale' => 'string',
		'Buildings_descriptions_translation.locale' => 'string',
		'Buildings_descriptions_translation__model' => 'string',
		'Buildings_descriptions_translation.model' => 'string',
		'Buildings_descriptions_translation__foreign_key' => 'integer',
		'Buildings_descriptions_translation.foreign_key' => 'integer',
		'Buildings_descriptions_translation__field' => 'string',
		'Buildings_descriptions_translation.field' => 'string',
		'Buildings_descriptions_translation__content' => 'text',
		'Buildings_descriptions_translation.content' => 'text',
		'Buildings_ownership_translation__id' => 'integer',
		'Buildings_ownership_translation.id' => 'integer',
		'Buildings_ownership_translation__locale' => 'string',
		'Buildings_ownership_translation.locale' => 'string',
		'Buildings_ownership_translation__model' => 'string',
		'Buildings_ownership_translation.model' => 'string',
		'Buildings_ownership_translation__foreign_key' => 'integer',
		'Buildings_ownership_translation.foreign_key' => 'integer',
		'Buildings_ownership_translation__field' => 'string',
		'Buildings_ownership_translation.field' => 'string',
		'Buildings_ownership_translation__content' => 'text',
		'Buildings_ownership_translation.content' => 'text',
		'Buildings_air_con_hours_translation__id' => 'integer',
		'Buildings_air_con_hours_translation.id' => 'integer',
		'Buildings_air_con_hours_translation__locale' => 'string',
		'Buildings_air_con_hours_translation.locale' => 'string',
		'Buildings_air_con_hours_translation__model' => 'string',
		'Buildings_air_con_hours_translation.model' => 'string',
		'Buildings_air_con_hours_translation__foreign_key' => 'integer',
		'Buildings_air_con_hours_translation.foreign_key' => 'integer',
		'Buildings_air_con_hours_translation__field' => 'string',
		'Buildings_air_con_hours_translation.field' => 'string',
		'Buildings_air_con_hours_translation__content' => 'text',
		'Buildings_air_con_hours_translation.content' => 'text',
		'Buildings_floor_system_translation__id' => 'integer',
		'Buildings_floor_system_translation.id' => 'integer',
		'Buildings_floor_system_translation__locale' => 'string',
		'Buildings_floor_system_translation.locale' => 'string',
		'Buildings_floor_system_translation__model' => 'string',
		'Buildings_floor_system_translation.model' => 'string',
		'Buildings_floor_system_translation__foreign_key' => 'integer',
		'Buildings_floor_system_translation.foreign_key' => 'integer',
		'Buildings_floor_system_translation__field' => 'string',
		'Buildings_floor_system_translation.field' => 'string',
		'Buildings_floor_system_translation__content' => 'text',
		'Buildings_floor_system_translation.content' => 'text',
		'Buildings_lift_translation__id' => 'integer',
		'Buildings_lift_translation.id' => 'integer',
		'Buildings_lift_translation__locale' => 'string',
		'Buildings_lift_translation.locale' => 'string',
		'Buildings_lift_translation__model' => 'string',
		'Buildings_lift_translation.model' => 'string',
		'Buildings_lift_translation__foreign_key' => 'integer',
		'Buildings_lift_translation.foreign_key' => 'integer',
		'Buildings_lift_translation__field' => 'string',
		'Buildings_lift_translation.field' => 'string',
		'Buildings_lift_translation__content' => 'text',
		'Buildings_lift_translation.content' => 'text',
		'Buildings_ceiling_height_translation__id' => 'integer',
		'Buildings_ceiling_height_translation.id' => 'integer',
		'Buildings_ceiling_height_translation__locale' => 'string',
		'Buildings_ceiling_height_translation.locale' => 'string',
		'Buildings_ceiling_height_translation__model' => 'string',
		'Buildings_ceiling_height_translation.model' => 'string',
		'Buildings_ceiling_height_translation__foreign_key' => 'integer',
		'Buildings_ceiling_height_translation.foreign_key' => 'integer',
		'Buildings_ceiling_height_translation__field' => 'string',
		'Buildings_ceiling_height_translation.field' => 'string',
		'Buildings_ceiling_height_translation__content' => 'text',
		'Buildings_ceiling_height_translation.content' => 'text',
		'Buildings_carpark_facilities_translation__id' => 'integer',
		'Buildings_carpark_facilities_translation.id' => 'integer',
		'Buildings_carpark_facilities_translation__locale' => 'string',
		'Buildings_carpark_facilities_translation.locale' => 'string',
		'Buildings_carpark_facilities_translation__model' => 'string',
		'Buildings_carpark_facilities_translation.model' => 'string',
		'Buildings_carpark_facilities_translation__foreign_key' => 'integer',
		'Buildings_carpark_facilities_translation.foreign_key' => 'integer',
		'Buildings_carpark_facilities_translation__field' => 'string',
		'Buildings_carpark_facilities_translation.field' => 'string',
		'Buildings_carpark_facilities_translation__content' => 'text',
		'Buildings_carpark_facilities_translation.content' => 'text',
		'Buildings_transportation_translation__id' => 'integer',
		'Buildings_transportation_translation.id' => 'integer',
		'Buildings_transportation_translation__locale' => 'string',
		'Buildings_transportation_translation.locale' => 'string',
		'Buildings_transportation_translation__model' => 'string',
		'Buildings_transportation_translation.model' => 'string',
		'Buildings_transportation_translation__foreign_key' => 'integer',
		'Buildings_transportation_translation.foreign_key' => 'integer',
		'Buildings_transportation_translation__field' => 'string',
		'Buildings_transportation_translation.field' => 'string',
		'Buildings_transportation_translation__content' => 'text',
		'Buildings_transportation_translation.content' => 'text',
		'Buildings_meta_title_translation__id' => 'integer',
		'Buildings_meta_title_translation.id' => 'integer',
		'Buildings_meta_title_translation__locale' => 'string',
		'Buildings_meta_title_translation.locale' => 'string',
		'Buildings_meta_title_translation__model' => 'string',
		'Buildings_meta_title_translation.model' => 'string',
		'Buildings_meta_title_translation__foreign_key' => 'integer',
		'Buildings_meta_title_translation.foreign_key' => 'integer',
		'Buildings_meta_title_translation__field' => 'string',
		'Buildings_meta_title_translation.field' => 'string',
		'Buildings_meta_title_translation__content' => 'text',
		'Buildings_meta_title_translation.content' => 'text',
		'Buildings_meta_keywords_translation__id' => 'integer',
		'Buildings_meta_keywords_translation.id' => 'integer',
		'Buildings_meta_keywords_translation__locale' => 'string',
		'Buildings_meta_keywords_translation.locale' => 'string',
		'Buildings_meta_keywords_translation__model' => 'string',
		'Buildings_meta_keywords_translation.model' => 'string',
		'Buildings_meta_keywords_translation__foreign_key' => 'integer',
		'Buildings_meta_keywords_translation.foreign_key' => 'integer',
		'Buildings_meta_keywords_translation__field' => 'string',
		'Buildings_meta_keywords_translation.field' => 'string',
		'Buildings_meta_keywords_translation__content' => 'text',
		'Buildings_meta_keywords_translation.content' => 'text',
		'Buildings_meta_descriptions_translation__id' => 'integer',
		'Buildings_meta_descriptions_translation.id' => 'integer',
		'Buildings_meta_descriptions_translation__locale' => 'string',
		'Buildings_meta_descriptions_translation.locale' => 'string',
		'Buildings_meta_descriptions_translation__model' => 'string',
		'Buildings_meta_descriptions_translation.model' => 'string',
		'Buildings_meta_descriptions_translation__foreign_key' => 'integer',
		'Buildings_meta_descriptions_translation.foreign_key' => 'integer',
		'Buildings_meta_descriptions_translation__field' => 'string',
		'Buildings_meta_descriptions_translation.field' => 'string',
		'Buildings_meta_descriptions_translation__content' => 'text',
		'Buildings_meta_descriptions_translation.content' => 'text',
		'Buildings_og_title_translation__id' => 'integer',
		'Buildings_og_title_translation.id' => 'integer',
		'Buildings_og_title_translation__locale' => 'string',
		'Buildings_og_title_translation.locale' => 'string',
		'Buildings_og_title_translation__model' => 'string',
		'Buildings_og_title_translation.model' => 'string',
		'Buildings_og_title_translation__foreign_key' => 'integer',
		'Buildings_og_title_translation.foreign_key' => 'integer',
		'Buildings_og_title_translation__field' => 'string',
		'Buildings_og_title_translation.field' => 'string',
		'Buildings_og_title_translation__content' => 'text',
		'Buildings_og_title_translation.content' => 'text',
		'Buildings_og_type_translation__id' => 'integer',
		'Buildings_og_type_translation.id' => 'integer',
		'Buildings_og_type_translation__locale' => 'string',
		'Buildings_og_type_translation.locale' => 'string',
		'Buildings_og_type_translation__model' => 'string',
		'Buildings_og_type_translation.model' => 'string',
		'Buildings_og_type_translation__foreign_key' => 'integer',
		'Buildings_og_type_translation.foreign_key' => 'integer',
		'Buildings_og_type_translation__field' => 'string',
		'Buildings_og_type_translation.field' => 'string',
		'Buildings_og_type_translation__content' => 'text',
		'Buildings_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',
		'States_name_translation__id' => 'integer',
		'States_name_translation.id' => 'integer',
		'States_name_translation__locale' => 'string',
		'States_name_translation.locale' => 'string',
		'States_name_translation__model' => 'string',
		'States_name_translation.model' => 'string',
		'States_name_translation__foreign_key' => 'integer',
		'States_name_translation.foreign_key' => 'integer',
		'States_name_translation__field' => 'string',
		'States_name_translation.field' => 'string',
		'States_name_translation__content' => 'text',
		'States_name_translation.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',
		'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'
	],
	'decorators' => (int) 1,
	'executed' => true,
	'hydrate' => true,
	'buffered' => true,
	'formatters' => (int) 4,
	'mapReducers' => (int) 0,
	'contain' => [
		'Countries' => [
			[maximum depth reached]
		],
		'States' => [
			[maximum depth reached]
		],
		'Areas' => [
			[maximum depth reached]
		],
		'Buildings_name_translation' => [
			[maximum depth reached]
		],
		'Buildings_address_translation' => [
			[maximum depth reached]
		],
		'Buildings_descriptions_translation' => [
			[maximum depth reached]
		],
		'Buildings_ownership_translation' => [
			[maximum depth reached]
		],
		'Buildings_air_con_hours_translation' => [
			[maximum depth reached]
		],
		'Buildings_floor_system_translation' => [
			[maximum depth reached]
		],
		'Buildings_lift_translation' => [
			[maximum depth reached]
		],
		'Buildings_ceiling_height_translation' => [
			[maximum depth reached]
		],
		'Buildings_carpark_facilities_translation' => [
			[maximum depth reached]
		],
		'Buildings_transportation_translation' => [
			[maximum depth reached]
		],
		'Buildings_meta_title_translation' => [
			[maximum depth reached]
		],
		'Buildings_meta_keywords_translation' => [
			[maximum depth reached]
		],
		'Buildings_meta_descriptions_translation' => [
			[maximum depth reached]
		],
		'Buildings_og_title_translation' => [
			[maximum depth reached]
		],
		'Buildings_og_type_translation' => [
			[maximum depth reached]
		]
	],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\BuildingsTable) {}

}
$keyword = ''
$total_buildings = (int) 26
$states = 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',
	'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',
		'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) 1,
	'executed' => true,
	'hydrate' => true,
	'buffered' => true,
	'formatters' => (int) 1,
	'mapReducers' => (int) 0,
	'contain' => [
		'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) {}

}
$leases_offices = [
	(int) 2 => [
		'id' => (int) 2,
		'slug' => 'private-offices',
		'name' => 'Private Offices',
		'translated_name' => '私人辦公室'
	],
	(int) 4 => [
		'id' => (int) 4,
		'slug' => 'hot-desks',
		'name' => 'Hot Desks',
		'translated_name' => '流動辦工桌'
	],
	(int) 5 => [
		'id' => (int) 5,
		'slug' => 'dedicated-desks',
		'name' => 'Dedicated Desks',
		'translated_name' => '固定辦公桌'
	]
]
$data = object(stdClass) {
	country => 'hong-kong'
	area => 'kowloon-bay'
	inputs => [
		'property_office_type' => '',
		'property_max_pax' => '',
		'property_min_pax' => '',
		'property_max_price' => '',
		'property_min_price' => '',
		'property_area' => 'kowloon-bay',
		'property_country' => 'hong-kong',
		'property_location' => '九龍灣, 香港'
	]
	input_text => [
		'office_type' => 'Office Type',
		'number_of_pax' => 'No. of Pax',
		'price' => 'Price',
		'location' => '九龍灣, 香港'
	]
	search_input_class => [
		'office_type' => false,
		'number_of_pax' => false,
		'price' => false,
		'location' => true
	]
}
$languages = null
$locale_lang = 'zh'
$countryName = 'US'
$area = object(App\Model\Entity\State) {

	'id' => (int) 3,
	'country_id' => (int) 98,
	'name' => '新界',
	'slug' => 'new-territories',
	'status' => true,
	'state_order' => (int) 3,
	'meta_title' => '新界服務式辦公室/商務中心指南 - Workspace Asia',
	'meta_keywords' => '新界辦公室出租，服務式辦公室，商務中心，共享工作間',
	'meta_descriptions' => '想在新界租辦公室？立即上Workspace Asia尋找你的理想服務式辦公室或共享工作間。全港超過二百個地點，覆蓋整個市場，提供詳細價格及環境資料。請致電+852 3018 4832查詢！',
	'og_title' => '',
	'og_type' => null,
	'og_image' => '/uploads/hong_kong/the_rainbow_metro/2-1608439740532.jpg',
	'modified' => object(Cake\I18n\Time) {},
	'areas' => [
		(int) 0 => object(App\Model\Entity\Area) {},
		(int) 1 => object(App\Model\Entity\Area) {},
		(int) 2 => object(App\Model\Entity\Area) {},
		(int) 3 => object(App\Model\Entity\Area) {},
		(int) 4 => object(App\Model\Entity\Area) {},
		(int) 5 => object(App\Model\Entity\Area) {}
	],
	'_locale' => 'zh_TW',
	'[new]' => false,
	'[accessible]' => [
		'*' => true,
		'id' => false
	],
	'[dirty]' => [],
	'[original]' => [],
	'[virtual]' => [],
	'[errors]' => [],
	'[invalid]' => [],
	'[repository]' => 'States'

}
$value = object(App\Model\Entity\Area) {

	'id' => (int) 66,
	'name' => '沙田',
	'slug' => 'sha-tin',
	'country_id' => (int) 98,
	'state_id' => (int) 3,
	'status' => (int) 1,
	'area_order' => (int) 22,
	'popular_location' => (int) 0,
	'meta_title' => '香港沙田服務式辦公室/商務中心指南 - Workspace Asia',
	'meta_keywords' => '沙田辦公室出租，服務式辦公室，商務中心，共享工作間',
	'meta_descriptions' => '想在沙田辦公室？立即上Workspace Asia尋找你的理想服務式辦公室或共享工作間。全港超過二百個地點，覆蓋整個市場，提供詳細價格及環境資料。請致電+852 9231 0043 查詢！',
	'og_title' => '',
	'og_type' => null,
	'og_image' => '/uploads/hong_kong/tai_cheung_factory_building_the_hive/5-1610776836439.jpg',
	'modified' => object(Cake\I18n\Time) {},
	'_locale' => 'zh_TW',
	'[new]' => false,
	'[accessible]' => [
		'*' => true,
		'id' => false
	],
	'[dirty]' => [],
	'[original]' => [],
	'[virtual]' => [],
	'[errors]' => [],
	'[invalid]' => [],
	'[repository]' => 'Areas'

}
include - APP/Template/Element/header.ctp, line 85
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::_renderElement() - CORE/src/View/View.php, line 1372
Cake\View\View::element() - CORE/src/View/View.php, line 513
include - APP/Template/Layout/front.ctp, line 120
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::renderLayout() - CORE/src/View/View.php, line 657
Cake\View\View::render() - CORE/src/View/View.php, line 615
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
登錄
搜索
委託放盤
香港島
- 上環
- 銅鑼灣
- 灣仔
- 金鐘
- 中環
- 黃竹坑
- 堅尼地城
- 西營盤
- 北角
- 鰂魚涌
- 柴灣
- 香港仔
- 筲箕灣
九龍
- 旺角
- 尖沙咀
- 荔枝角
- 佐敦
- 尖東
- 觀塘
- 九龍灣
- 紅磡
- 長沙灣
- 新蒲崗
- 油麻地
- 西九龍
- 九龍城
新界
- 荃灣
- 葵涌
- 上水
- 元朗
- 西貢
- 沙田
+852 9231 0043
九龍灣香港 服務式辦公室和共享工作間出租

恩浩國際中心

常悅道1號

企業廣場一期一座

常悅道9號

創豪坊

宏光道8號

德福大廈

宏開道16號

宏天廣場

宏光道39號

一號九龍

宏遠街1號

南豐商業中心

臨樂街19號

宏泰道23

宏泰道23號

九龍灣國際展貿中心

展貿徑1號

金利豐國際中心

宏照道19號

Harbourside HQ

臨澤街8號

高銀金融國際中心

啟祥道17號

富通中心

常悅道18號

國際交易中心

宏照道33號

企業廣場二期

常悅道3號

企業廣場一期三座

常悅道9號

企業廣場一期二座

常悅道9號

企業廣場三期

宏照道39號

企業廣場五期二座

宏照道38號

企業廣場五期一座

宏照道38號

Eastmark

常悅道21號

大昌貿易行汽車服務大廈

啟祥道20號

其士商業中心

宏開道8號

新明大廈

常悅道11號

富臨中心

偉業街38號

億京中心

宏光道1號

九龍灣香港服務式辦公室和共享工作間出租
