香港葵涌服務式辦公室/商務中心指南

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=9ee04c41f2bf2a1fcfbbdb680c18ebb2&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) 60,
		'name' => '葵涌',
		'slug' => 'kwai-chung',
		'country_id' => (int) 98,
		'state_id' => (int) 3,
		'status' => (int) 1,
		'area_order' => (int) 14,
		'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/the_galaxy_metro/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]' => '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) 22,
	'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 => 'kwai-chung'
		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=9ee04c41f2bf2a1fcfbbdb680c18ebb2&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) 60,
	'name' => '葵涌',
	'slug' => 'kwai-chung',
	'country_id' => (int) 98,
	'state_id' => (int) 3,
	'status' => (int) 1,
	'area_order' => (int) 14,
	'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/the_galaxy_metro/3.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) 22
$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 => 'kwai-chung'
	inputs => [
		'property_office_type' => '',
		'property_max_pax' => '',
		'property_min_pax' => '',
		'property_max_price' => '',
		'property_min_price' => '',
		'property_area' => 'kwai-chung',
		'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
葵涌香港 服務式辦公室和共享工作間出租

宏達工業中心

大連排道21-33號

天際中心

青山公路葵涌段313-317號

樂聲工業中心

大連排道58-66號

達利中心

梨木道88號

世和中心

禾塘咀街55號

新華大廈

和宜合道122號

貿易之都

葵昌路54-56號

新都會廣場2座

興芳路223號

新都會廣場1座

興芳路223號

萬泰中心

葵昌路2-16號

美和工業大廈

葵昌路90-98號

葵富大廈

和宜合道230號

九龍貿易中心-2座

葵昌路51號

九龍貿易中心-1座

葵昌路51-53號

KC100

葵昌路100號

K83

大連排道83號

達利國際中心

葵喜街1-11號

永得利廣場二座

貨櫃碼頭路88號

永得利廣場一座

貨櫃碼頭路88號

EDGE

葵榮路30-34號

中信電訊大廈

葵福路93號

葵安道1號

葵安道1號

葵涌香港服務式辦公室和共享工作間出租
