Code Context
$data->input_text = [
'office_type' => $office_type_text,
$lang = 'zh'
$country = 'hong-kong'
$area = null
$filter = [
'property_office_type' => 'dedicated desk'
]
$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 = ''
$locationO = ''
$seoText = ''
$area_ids = []
$keyword = ''
$pageLimit = (int) 9
$lease_conditions = []
$leases_joins = []
$page = (int) 0
$conditions = [
(int) 0 => [
'LeasesAvailability.office_id' => 'dedicated desk'
],
(int) 1 => [
'Leases.country_id' => (int) 98
],
(int) 2 => [
'Leases.status' => (int) 1
]
]
$lease_joins = [
'Prices' => [
'table' => 'prices',
'type' => 'INNER',
'conditions' => [
(int) 0 => 'Prices.lease_id = Leases.id',
(int) 1 => 'Prices.price_type_id = 3'
]
],
'LeasesAvailability' => [
'table' => 'leases_availability',
'type' => 'INNER',
'conditions' => [
(int) 0 => 'Leases.id = LeasesAvailability.leases_id'
]
]
]
$queryC = 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.slug = :c24 LIMIT 1',
'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) 1,
'executed' => true,
'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) {}
}
$order = [
'Leases.lease_order' => 'ASC',
(int) 0 => 'Leases.modified DESC'
]
$properties = object(Cake\Datasource\ResultSetDecorator) {
'count' => (int) 0
}
$total_properties = (int) 0
$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 leases_availability LeasesAvailability ON Leases.id = LeasesAvailability.leases_id 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 (LeasesAvailability.office_id = :c96 AND Leases.country_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) 0,
'executed' => false,
'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) {}
}
$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) {}
}
$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) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 1,
'mapReducers' => (int) 0,
'contain' => [
'Areas' => [[maximum depth reached]],
'States_name_translation' => [
[maximum depth reached]
],
'States_meta_title_translation' => [
[maximum depth reached]
],
'States_meta_keywords_translation' => [
[maximum depth reached]
],
'States_meta_descriptions_translation' => [
[maximum depth reached]
],
'States_og_title_translation' => [
[maximum depth reached]
],
'States_og_type_translation' => [
[maximum depth reached]
]
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\StatesTable) {}
}
$buildingConditions = [
(int) 0 => [
'Buildings.status' => (int) 1
],
(int) 1 => [
'Buildings.country_id' => (int) 98
]
]
$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) 0,
'executed' => false,
'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) {}
}
$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) 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]
]
],
'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) 0,
'executed' => false,
'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) {}
}
$total_buildings = (int) 1361
$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 => null
inputs => [
'property_office_type' => 'dedicated desk',
'property_max_pax' => '',
'property_min_pax' => '',
'property_max_price' => '',
'property_min_price' => '',
'property_area' => null,
'property_country' => 'hong-kong',
'property_location' => '香港'
]
}
$location_text = '香港'
$number_of_pax_text = 'No. of Pax'
$price_text = 'Price'
$leases_office = [
'id' => (int) 5,
'slug' => 'dedicated-desks',
'name' => 'Dedicated Desks',
'translated_name' => '固定辦公桌'
]
$office_type = (int) 5
$office_search_class = true
App\Controller\PagesController::listing() - APP/Controller/PagesController.php, line 482
Cake\Controller\Controller::invokeAction() - CORE/src/Controller/Controller.php, line 440
Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 119
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