Warning (2): count() [<a href='http://php.net/function.count'>function.count</a>]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]Code Context {
return function ($parts, $name) use (&$sql, $query, $generator) {
if (!count($parts)) {
$parts = null
$name = 'having'
$sql = 'SELECT Estates.id AS `Estates__id`, Estates.type AS `Estates__type`, Estates.invalid AS `Estates__invalid`, Estates.special_selection AS `Estates__special_selection`, Estates.new_sign AS `Estates__new_sign`, Estates.building_id AS `Estates__building_id`, Estates.address1 AS `Estates__address1`, Estates.address2 AS `Estates__address2`, Estates.name AS `Estates__name`, Estates.floor AS `Estates__floor`, Estates.floor_sequence AS `Estates__floor_sequence`, Estates.tsubo AS `Estates__tsubo`, Estates.space AS `Estates__space`, Estates.rent_category AS `Estates__rent_category`, Estates.rent_expense AS `Estates__rent_expense`, Estates.common_service_category AS `Estates__common_service_category`, Estates.common_service_expense AS `Estates__common_service_expense`, Estates.air_conditioning_category AS `Estates__air_conditioning_category`, Estates.air_conditioning_expense AS `Estates__air_conditioning_expense`, Estates.caution_money_category AS `Estates__caution_money_category`, Estates.caution_money_expense AS `Estates__caution_money_expense`, Estates.security_money_category AS `Estates__security_money_category`, Estates.security_money_expense AS `Estates__security_money_expense`, Estates.key_money_category AS `Estates__key_money_category`, Estates.key_money_expense AS `Estates__key_money_expense`, Estates.contract AS `Estates__contract`, Estates.business_category AS `Estates__business_category`, Estates.transfer AS `Estates__transfer`, Estates.area AS `Estates__area`, Estates.note1 AS `Estates__note1`, Estates.note2 AS `Estates__note2`, Estates.note3 AS `Estates__note3`, Estates.internal_note1 AS `Estates__internal_note1`, Estates.internal_note2 AS `Estates__internal_note2`, Estates.secret AS `Estates__secret`, Estates.staff AS `Estates__staff`, Estates.inputter AS `Estates__inputter`, Estates.photo_sign AS `Estates__photo_sign`, Estates.photo1 AS `Estates__photo1`, Estates.photo2 AS `Estates__photo2`, Estates.photo3 AS `Estates__photo3`, Estates.photo4 AS `Estates__photo4`, Estates.photo5 AS `Estates__photo5`, Estates.photo6 AS `Estates__photo6`, Estates.floor_plan AS `Estates__floor_plan`, Estates.created AS `Estates__created`, Estates.modified AS `Estates__modified`, Estates.deleted AS `Estates__deleted`, Buildings.id AS `Buildings__id`, Buildings.estates_category AS `Buildings__estates_category`, Buildings.owner_id AS `Buildings__owner_id`, Buildings.management_id AS `Buildings__management_id`, Buildings.name AS `Buildings__name`, Buildings.yomi AS `Buildings__yomi`, Buildings.area AS `Buildings__area`, Buildings.zip AS `Buildings__zip`, Buildings.address1 AS `Buildings__address1`, Buildings.address2 AS `Buildings__address2`, Buildings.address3 AS `Buildings__address3`, Buildings.address4 AS `Buildings__address4`, Buildings.photo AS `Buildings__photo`, Buildings.created AS `Buildings__created`, Buildings.modified AS `Buildings__modified`, Buildings.deleted AS `Buildings__deleted` FROM estates Estates LEFT JOIN buildings Buildings ON Buildings.id = (Estates.building_id) WHERE (Estates.new_sign IS NULL AND Buildings.area LIKE :c0 AND (Estates.secret IS NULL OR Estates.secret != :c1) AND (Estates.invalid IS NULL OR Estates.invalid != :c2))'
$query = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SQL could not be generated for this query as it is incomplete.',
'params' => [],
'defaultTypes' => [
'Estates__id' => 'biginteger',
'Estates.id' => 'biginteger',
'id' => 'biginteger',
'Estates__type' => 'string',
'Estates.type' => 'string',
'type' => 'string',
'Estates__invalid' => 'string',
'Estates.invalid' => 'string',
'invalid' => 'string',
'Estates__special_selection' => 'integer',
'Estates.special_selection' => 'integer',
'special_selection' => 'integer',
'Estates__new_sign' => 'integer',
'Estates.new_sign' => 'integer',
'new_sign' => 'integer',
'Estates__building_id' => 'biginteger',
'Estates.building_id' => 'biginteger',
'building_id' => 'biginteger',
'Estates__address1' => 'string',
'Estates.address1' => 'string',
'address1' => 'string',
'Estates__address2' => 'string',
'Estates.address2' => 'string',
'address2' => 'string',
'Estates__name' => 'string',
'Estates.name' => 'string',
'name' => 'string',
'Estates__floor' => 'string',
'Estates.floor' => 'string',
'floor' => 'string',
'Estates__floor_sequence' => 'integer',
'Estates.floor_sequence' => 'integer',
'floor_sequence' => 'integer',
'Estates__tsubo' => 'decimal',
'Estates.tsubo' => 'decimal',
'tsubo' => 'decimal',
'Estates__space' => 'decimal',
'Estates.space' => 'decimal',
'space' => 'decimal',
'Estates__rent_category' => 'string',
'Estates.rent_category' => 'string',
'rent_category' => 'string',
'Estates__rent_expense' => 'biginteger',
'Estates.rent_expense' => 'biginteger',
'rent_expense' => 'biginteger',
'Estates__common_service_category' => 'string',
'Estates.common_service_category' => 'string',
'common_service_category' => 'string',
'Estates__common_service_expense' => 'biginteger',
'Estates.common_service_expense' => 'biginteger',
'common_service_expense' => 'biginteger',
'Estates__air_conditioning_category' => 'string',
'Estates.air_conditioning_category' => 'string',
'air_conditioning_category' => 'string',
'Estates__air_conditioning_expense' => 'biginteger',
'Estates.air_conditioning_expense' => 'biginteger',
'air_conditioning_expense' => 'biginteger',
'Estates__caution_money_category' => 'string',
'Estates.caution_money_category' => 'string',
'caution_money_category' => 'string',
'Estates__caution_money_expense' => 'biginteger',
'Estates.caution_money_expense' => 'biginteger',
'caution_money_expense' => 'biginteger',
'Estates__security_money_category' => 'string',
'Estates.security_money_category' => 'string',
'security_money_category' => 'string',
'Estates__security_money_expense' => 'biginteger',
'Estates.security_money_expense' => 'biginteger',
'security_money_expense' => 'biginteger',
'Estates__key_money_category' => 'string',
'Estates.key_money_category' => 'string',
'key_money_category' => 'string',
'Estates__key_money_expense' => 'biginteger',
'Estates.key_money_expense' => 'biginteger',
'key_money_expense' => 'biginteger',
'Estates__contract' => 'string',
'Estates.contract' => 'string',
'contract' => 'string',
'Estates__business_category' => 'string',
'Estates.business_category' => 'string',
'business_category' => 'string',
'Estates__transfer' => 'string',
'Estates.transfer' => 'string',
'transfer' => 'string',
'Estates__area' => 'string',
'Estates.area' => 'string',
'area' => 'string',
'Estates__note1' => 'string',
'Estates.note1' => 'string',
'note1' => 'string',
'Estates__note2' => 'string',
'Estates.note2' => 'string',
'note2' => 'string',
'Estates__note3' => 'string',
'Estates.note3' => 'string',
'note3' => 'string',
'Estates__internal_note1' => 'string',
'Estates.internal_note1' => 'string',
'internal_note1' => 'string',
'Estates__internal_note2' => 'string',
'Estates.internal_note2' => 'string',
'internal_note2' => 'string',
'Estates__secret' => 'string',
'Estates.secret' => 'string',
'secret' => 'string',
'Estates__staff' => 'string',
'Estates.staff' => 'string',
'staff' => 'string',
'Estates__inputter' => 'string',
'Estates.inputter' => 'string',
'inputter' => 'string',
'Estates__photo_sign' => 'string',
'Estates.photo_sign' => 'string',
'photo_sign' => 'string',
'Estates__photo1' => 'string',
'Estates.photo1' => 'string',
'photo1' => 'string',
'Estates__photo2' => 'string',
'Estates.photo2' => 'string',
'photo2' => 'string',
'Estates__photo3' => 'string',
'Estates.photo3' => 'string',
'photo3' => 'string',
'Estates__photo4' => 'string',
'Estates.photo4' => 'string',
'photo4' => 'string',
'Estates__photo5' => 'string',
'Estates.photo5' => 'string',
'photo5' => 'string',
'Estates__photo6' => 'string',
'Estates.photo6' => 'string',
'photo6' => 'string',
'Estates__floor_plan' => 'string',
'Estates.floor_plan' => 'string',
'floor_plan' => 'string',
'Estates__created' => 'datetime',
'Estates.created' => 'datetime',
'created' => 'datetime',
'Estates__modified' => 'datetime',
'Estates.modified' => 'datetime',
'modified' => 'datetime',
'Estates__deleted' => 'datetime',
'Estates.deleted' => 'datetime',
'deleted' => 'datetime',
'Buildings__id' => 'biginteger',
'Buildings.id' => 'biginteger',
'Buildings__estates_category' => 'string',
'Buildings.estates_category' => 'string',
'estates_category' => 'string',
'Buildings__owner_id' => 'biginteger',
'Buildings.owner_id' => 'biginteger',
'owner_id' => 'biginteger',
'Buildings__management_id' => 'biginteger',
'Buildings.management_id' => 'biginteger',
'management_id' => 'biginteger',
'Buildings__name' => 'string',
'Buildings.name' => 'string',
'Buildings__yomi' => 'string',
'Buildings.yomi' => 'string',
'yomi' => 'string',
'Buildings__area' => 'string',
'Buildings.area' => 'string',
'Buildings__zip' => 'string',
'Buildings.zip' => 'string',
'zip' => 'string',
'Buildings__address1' => 'string',
'Buildings.address1' => 'string',
'Buildings__address2' => 'string',
'Buildings.address2' => 'string',
'Buildings__address3' => 'string',
'Buildings.address3' => 'string',
'address3' => 'string',
'Buildings__address4' => 'string',
'Buildings.address4' => 'string',
'address4' => 'string',
'Buildings__photo' => 'string',
'Buildings.photo' => 'string',
'photo' => 'string',
'Buildings__created' => 'datetime',
'Buildings.created' => 'datetime',
'Buildings__modified' => 'datetime',
'Buildings.modified' => 'datetime',
'Buildings__deleted' => 'datetime',
'Buildings.deleted' => 'datetime'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
'Buildings' => [[maximum depth reached]]
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\EstatesTable) {}
}
$generator = object(Cake\Database\ValueBinder) {
[protected] _bindings => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
],
':c2' => [
[maximum depth reached]
]
]
[protected] _bindingsCount => (int) 3
}count - [internal], line ??
Cake\Database\QueryCompiler::Cake\Database\{closure}() - CORE/src/Database/QueryCompiler.php, line 128
Cake\Database\Query::traverse() - CORE/src/Database/Query.php, line 311
Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99
Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 359
Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 299
Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 282
Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 990
Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136
Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 258
Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 311
Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 213
Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 1011
Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276
Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 959
Cake\ORM\Query::getIterator() - CORE/src/Datasource/QueryTrait.php, line 132
include - APP/Template/Element/estate.ctp, line 71
Warning (2): count() [<a href='http://php.net/function.count'>function.count</a>]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]Code Context {
return function ($parts, $name) use (&$sql, $query, $generator) {
if (!count($parts)) {
$parts = null
$name = 'limit'
$sql = 'SELECT Estates.id AS `Estates__id`, Estates.type AS `Estates__type`, Estates.invalid AS `Estates__invalid`, Estates.special_selection AS `Estates__special_selection`, Estates.new_sign AS `Estates__new_sign`, Estates.building_id AS `Estates__building_id`, Estates.address1 AS `Estates__address1`, Estates.address2 AS `Estates__address2`, Estates.name AS `Estates__name`, Estates.floor AS `Estates__floor`, Estates.floor_sequence AS `Estates__floor_sequence`, Estates.tsubo AS `Estates__tsubo`, Estates.space AS `Estates__space`, Estates.rent_category AS `Estates__rent_category`, Estates.rent_expense AS `Estates__rent_expense`, Estates.common_service_category AS `Estates__common_service_category`, Estates.common_service_expense AS `Estates__common_service_expense`, Estates.air_conditioning_category AS `Estates__air_conditioning_category`, Estates.air_conditioning_expense AS `Estates__air_conditioning_expense`, Estates.caution_money_category AS `Estates__caution_money_category`, Estates.caution_money_expense AS `Estates__caution_money_expense`, Estates.security_money_category AS `Estates__security_money_category`, Estates.security_money_expense AS `Estates__security_money_expense`, Estates.key_money_category AS `Estates__key_money_category`, Estates.key_money_expense AS `Estates__key_money_expense`, Estates.contract AS `Estates__contract`, Estates.business_category AS `Estates__business_category`, Estates.transfer AS `Estates__transfer`, Estates.area AS `Estates__area`, Estates.note1 AS `Estates__note1`, Estates.note2 AS `Estates__note2`, Estates.note3 AS `Estates__note3`, Estates.internal_note1 AS `Estates__internal_note1`, Estates.internal_note2 AS `Estates__internal_note2`, Estates.secret AS `Estates__secret`, Estates.staff AS `Estates__staff`, Estates.inputter AS `Estates__inputter`, Estates.photo_sign AS `Estates__photo_sign`, Estates.photo1 AS `Estates__photo1`, Estates.photo2 AS `Estates__photo2`, Estates.photo3 AS `Estates__photo3`, Estates.photo4 AS `Estates__photo4`, Estates.photo5 AS `Estates__photo5`, Estates.photo6 AS `Estates__photo6`, Estates.floor_plan AS `Estates__floor_plan`, Estates.created AS `Estates__created`, Estates.modified AS `Estates__modified`, Estates.deleted AS `Estates__deleted`, Buildings.id AS `Buildings__id`, Buildings.estates_category AS `Buildings__estates_category`, Buildings.owner_id AS `Buildings__owner_id`, Buildings.management_id AS `Buildings__management_id`, Buildings.name AS `Buildings__name`, Buildings.yomi AS `Buildings__yomi`, Buildings.area AS `Buildings__area`, Buildings.zip AS `Buildings__zip`, Buildings.address1 AS `Buildings__address1`, Buildings.address2 AS `Buildings__address2`, Buildings.address3 AS `Buildings__address3`, Buildings.address4 AS `Buildings__address4`, Buildings.photo AS `Buildings__photo`, Buildings.created AS `Buildings__created`, Buildings.modified AS `Buildings__modified`, Buildings.deleted AS `Buildings__deleted` FROM estates Estates LEFT JOIN buildings Buildings ON Buildings.id = (Estates.building_id) WHERE (Estates.new_sign IS NULL AND Buildings.area LIKE :c0 AND (Estates.secret IS NULL OR Estates.secret != :c1) AND (Estates.invalid IS NULL OR Estates.invalid != :c2)) ORDER BY Estates.photo_sign DESC, Estates.modified DESC, Estates.id DESC'
$query = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SQL could not be generated for this query as it is incomplete.',
'params' => [],
'defaultTypes' => [
'Estates__id' => 'biginteger',
'Estates.id' => 'biginteger',
'id' => 'biginteger',
'Estates__type' => 'string',
'Estates.type' => 'string',
'type' => 'string',
'Estates__invalid' => 'string',
'Estates.invalid' => 'string',
'invalid' => 'string',
'Estates__special_selection' => 'integer',
'Estates.special_selection' => 'integer',
'special_selection' => 'integer',
'Estates__new_sign' => 'integer',
'Estates.new_sign' => 'integer',
'new_sign' => 'integer',
'Estates__building_id' => 'biginteger',
'Estates.building_id' => 'biginteger',
'building_id' => 'biginteger',
'Estates__address1' => 'string',
'Estates.address1' => 'string',
'address1' => 'string',
'Estates__address2' => 'string',
'Estates.address2' => 'string',
'address2' => 'string',
'Estates__name' => 'string',
'Estates.name' => 'string',
'name' => 'string',
'Estates__floor' => 'string',
'Estates.floor' => 'string',
'floor' => 'string',
'Estates__floor_sequence' => 'integer',
'Estates.floor_sequence' => 'integer',
'floor_sequence' => 'integer',
'Estates__tsubo' => 'decimal',
'Estates.tsubo' => 'decimal',
'tsubo' => 'decimal',
'Estates__space' => 'decimal',
'Estates.space' => 'decimal',
'space' => 'decimal',
'Estates__rent_category' => 'string',
'Estates.rent_category' => 'string',
'rent_category' => 'string',
'Estates__rent_expense' => 'biginteger',
'Estates.rent_expense' => 'biginteger',
'rent_expense' => 'biginteger',
'Estates__common_service_category' => 'string',
'Estates.common_service_category' => 'string',
'common_service_category' => 'string',
'Estates__common_service_expense' => 'biginteger',
'Estates.common_service_expense' => 'biginteger',
'common_service_expense' => 'biginteger',
'Estates__air_conditioning_category' => 'string',
'Estates.air_conditioning_category' => 'string',
'air_conditioning_category' => 'string',
'Estates__air_conditioning_expense' => 'biginteger',
'Estates.air_conditioning_expense' => 'biginteger',
'air_conditioning_expense' => 'biginteger',
'Estates__caution_money_category' => 'string',
'Estates.caution_money_category' => 'string',
'caution_money_category' => 'string',
'Estates__caution_money_expense' => 'biginteger',
'Estates.caution_money_expense' => 'biginteger',
'caution_money_expense' => 'biginteger',
'Estates__security_money_category' => 'string',
'Estates.security_money_category' => 'string',
'security_money_category' => 'string',
'Estates__security_money_expense' => 'biginteger',
'Estates.security_money_expense' => 'biginteger',
'security_money_expense' => 'biginteger',
'Estates__key_money_category' => 'string',
'Estates.key_money_category' => 'string',
'key_money_category' => 'string',
'Estates__key_money_expense' => 'biginteger',
'Estates.key_money_expense' => 'biginteger',
'key_money_expense' => 'biginteger',
'Estates__contract' => 'string',
'Estates.contract' => 'string',
'contract' => 'string',
'Estates__business_category' => 'string',
'Estates.business_category' => 'string',
'business_category' => 'string',
'Estates__transfer' => 'string',
'Estates.transfer' => 'string',
'transfer' => 'string',
'Estates__area' => 'string',
'Estates.area' => 'string',
'area' => 'string',
'Estates__note1' => 'string',
'Estates.note1' => 'string',
'note1' => 'string',
'Estates__note2' => 'string',
'Estates.note2' => 'string',
'note2' => 'string',
'Estates__note3' => 'string',
'Estates.note3' => 'string',
'note3' => 'string',
'Estates__internal_note1' => 'string',
'Estates.internal_note1' => 'string',
'internal_note1' => 'string',
'Estates__internal_note2' => 'string',
'Estates.internal_note2' => 'string',
'internal_note2' => 'string',
'Estates__secret' => 'string',
'Estates.secret' => 'string',
'secret' => 'string',
'Estates__staff' => 'string',
'Estates.staff' => 'string',
'staff' => 'string',
'Estates__inputter' => 'string',
'Estates.inputter' => 'string',
'inputter' => 'string',
'Estates__photo_sign' => 'string',
'Estates.photo_sign' => 'string',
'photo_sign' => 'string',
'Estates__photo1' => 'string',
'Estates.photo1' => 'string',
'photo1' => 'string',
'Estates__photo2' => 'string',
'Estates.photo2' => 'string',
'photo2' => 'string',
'Estates__photo3' => 'string',
'Estates.photo3' => 'string',
'photo3' => 'string',
'Estates__photo4' => 'string',
'Estates.photo4' => 'string',
'photo4' => 'string',
'Estates__photo5' => 'string',
'Estates.photo5' => 'string',
'photo5' => 'string',
'Estates__photo6' => 'string',
'Estates.photo6' => 'string',
'photo6' => 'string',
'Estates__floor_plan' => 'string',
'Estates.floor_plan' => 'string',
'floor_plan' => 'string',
'Estates__created' => 'datetime',
'Estates.created' => 'datetime',
'created' => 'datetime',
'Estates__modified' => 'datetime',
'Estates.modified' => 'datetime',
'modified' => 'datetime',
'Estates__deleted' => 'datetime',
'Estates.deleted' => 'datetime',
'deleted' => 'datetime',
'Buildings__id' => 'biginteger',
'Buildings.id' => 'biginteger',
'Buildings__estates_category' => 'string',
'Buildings.estates_category' => 'string',
'estates_category' => 'string',
'Buildings__owner_id' => 'biginteger',
'Buildings.owner_id' => 'biginteger',
'owner_id' => 'biginteger',
'Buildings__management_id' => 'biginteger',
'Buildings.management_id' => 'biginteger',
'management_id' => 'biginteger',
'Buildings__name' => 'string',
'Buildings.name' => 'string',
'Buildings__yomi' => 'string',
'Buildings.yomi' => 'string',
'yomi' => 'string',
'Buildings__area' => 'string',
'Buildings.area' => 'string',
'Buildings__zip' => 'string',
'Buildings.zip' => 'string',
'zip' => 'string',
'Buildings__address1' => 'string',
'Buildings.address1' => 'string',
'Buildings__address2' => 'string',
'Buildings.address2' => 'string',
'Buildings__address3' => 'string',
'Buildings.address3' => 'string',
'address3' => 'string',
'Buildings__address4' => 'string',
'Buildings.address4' => 'string',
'address4' => 'string',
'Buildings__photo' => 'string',
'Buildings.photo' => 'string',
'photo' => 'string',
'Buildings__created' => 'datetime',
'Buildings.created' => 'datetime',
'Buildings__modified' => 'datetime',
'Buildings.modified' => 'datetime',
'Buildings__deleted' => 'datetime',
'Buildings.deleted' => 'datetime'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
'Buildings' => [[maximum depth reached]]
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\EstatesTable) {}
}
$generator = object(Cake\Database\ValueBinder) {
[protected] _bindings => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
],
':c2' => [
[maximum depth reached]
]
]
[protected] _bindingsCount => (int) 3
}count - [internal], line ??
Cake\Database\QueryCompiler::Cake\Database\{closure}() - CORE/src/Database/QueryCompiler.php, line 128
Cake\Database\Query::traverse() - CORE/src/Database/Query.php, line 311
Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99
Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 359
Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 299
Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 282
Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 990
Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136
Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 258
Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 311
Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 213
Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 1011
Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276
Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 959
Cake\ORM\Query::getIterator() - CORE/src/Datasource/QueryTrait.php, line 132
include - APP/Template/Element/estate.ctp, line 71
Warning (2): count() [<a href='http://php.net/function.count'>function.count</a>]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]Code Context {
return function ($parts, $name) use (&$sql, $query, $generator) {
if (!count($parts)) {
$parts = null
$name = 'offset'
$sql = 'SELECT Estates.id AS `Estates__id`, Estates.type AS `Estates__type`, Estates.invalid AS `Estates__invalid`, Estates.special_selection AS `Estates__special_selection`, Estates.new_sign AS `Estates__new_sign`, Estates.building_id AS `Estates__building_id`, Estates.address1 AS `Estates__address1`, Estates.address2 AS `Estates__address2`, Estates.name AS `Estates__name`, Estates.floor AS `Estates__floor`, Estates.floor_sequence AS `Estates__floor_sequence`, Estates.tsubo AS `Estates__tsubo`, Estates.space AS `Estates__space`, Estates.rent_category AS `Estates__rent_category`, Estates.rent_expense AS `Estates__rent_expense`, Estates.common_service_category AS `Estates__common_service_category`, Estates.common_service_expense AS `Estates__common_service_expense`, Estates.air_conditioning_category AS `Estates__air_conditioning_category`, Estates.air_conditioning_expense AS `Estates__air_conditioning_expense`, Estates.caution_money_category AS `Estates__caution_money_category`, Estates.caution_money_expense AS `Estates__caution_money_expense`, Estates.security_money_category AS `Estates__security_money_category`, Estates.security_money_expense AS `Estates__security_money_expense`, Estates.key_money_category AS `Estates__key_money_category`, Estates.key_money_expense AS `Estates__key_money_expense`, Estates.contract AS `Estates__contract`, Estates.business_category AS `Estates__business_category`, Estates.transfer AS `Estates__transfer`, Estates.area AS `Estates__area`, Estates.note1 AS `Estates__note1`, Estates.note2 AS `Estates__note2`, Estates.note3 AS `Estates__note3`, Estates.internal_note1 AS `Estates__internal_note1`, Estates.internal_note2 AS `Estates__internal_note2`, Estates.secret AS `Estates__secret`, Estates.staff AS `Estates__staff`, Estates.inputter AS `Estates__inputter`, Estates.photo_sign AS `Estates__photo_sign`, Estates.photo1 AS `Estates__photo1`, Estates.photo2 AS `Estates__photo2`, Estates.photo3 AS `Estates__photo3`, Estates.photo4 AS `Estates__photo4`, Estates.photo5 AS `Estates__photo5`, Estates.photo6 AS `Estates__photo6`, Estates.floor_plan AS `Estates__floor_plan`, Estates.created AS `Estates__created`, Estates.modified AS `Estates__modified`, Estates.deleted AS `Estates__deleted`, Buildings.id AS `Buildings__id`, Buildings.estates_category AS `Buildings__estates_category`, Buildings.owner_id AS `Buildings__owner_id`, Buildings.management_id AS `Buildings__management_id`, Buildings.name AS `Buildings__name`, Buildings.yomi AS `Buildings__yomi`, Buildings.area AS `Buildings__area`, Buildings.zip AS `Buildings__zip`, Buildings.address1 AS `Buildings__address1`, Buildings.address2 AS `Buildings__address2`, Buildings.address3 AS `Buildings__address3`, Buildings.address4 AS `Buildings__address4`, Buildings.photo AS `Buildings__photo`, Buildings.created AS `Buildings__created`, Buildings.modified AS `Buildings__modified`, Buildings.deleted AS `Buildings__deleted` FROM estates Estates LEFT JOIN buildings Buildings ON Buildings.id = (Estates.building_id) WHERE (Estates.new_sign IS NULL AND Buildings.area LIKE :c0 AND (Estates.secret IS NULL OR Estates.secret != :c1) AND (Estates.invalid IS NULL OR Estates.invalid != :c2)) ORDER BY Estates.photo_sign DESC, Estates.modified DESC, Estates.id DESC'
$query = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SQL could not be generated for this query as it is incomplete.',
'params' => [],
'defaultTypes' => [
'Estates__id' => 'biginteger',
'Estates.id' => 'biginteger',
'id' => 'biginteger',
'Estates__type' => 'string',
'Estates.type' => 'string',
'type' => 'string',
'Estates__invalid' => 'string',
'Estates.invalid' => 'string',
'invalid' => 'string',
'Estates__special_selection' => 'integer',
'Estates.special_selection' => 'integer',
'special_selection' => 'integer',
'Estates__new_sign' => 'integer',
'Estates.new_sign' => 'integer',
'new_sign' => 'integer',
'Estates__building_id' => 'biginteger',
'Estates.building_id' => 'biginteger',
'building_id' => 'biginteger',
'Estates__address1' => 'string',
'Estates.address1' => 'string',
'address1' => 'string',
'Estates__address2' => 'string',
'Estates.address2' => 'string',
'address2' => 'string',
'Estates__name' => 'string',
'Estates.name' => 'string',
'name' => 'string',
'Estates__floor' => 'string',
'Estates.floor' => 'string',
'floor' => 'string',
'Estates__floor_sequence' => 'integer',
'Estates.floor_sequence' => 'integer',
'floor_sequence' => 'integer',
'Estates__tsubo' => 'decimal',
'Estates.tsubo' => 'decimal',
'tsubo' => 'decimal',
'Estates__space' => 'decimal',
'Estates.space' => 'decimal',
'space' => 'decimal',
'Estates__rent_category' => 'string',
'Estates.rent_category' => 'string',
'rent_category' => 'string',
'Estates__rent_expense' => 'biginteger',
'Estates.rent_expense' => 'biginteger',
'rent_expense' => 'biginteger',
'Estates__common_service_category' => 'string',
'Estates.common_service_category' => 'string',
'common_service_category' => 'string',
'Estates__common_service_expense' => 'biginteger',
'Estates.common_service_expense' => 'biginteger',
'common_service_expense' => 'biginteger',
'Estates__air_conditioning_category' => 'string',
'Estates.air_conditioning_category' => 'string',
'air_conditioning_category' => 'string',
'Estates__air_conditioning_expense' => 'biginteger',
'Estates.air_conditioning_expense' => 'biginteger',
'air_conditioning_expense' => 'biginteger',
'Estates__caution_money_category' => 'string',
'Estates.caution_money_category' => 'string',
'caution_money_category' => 'string',
'Estates__caution_money_expense' => 'biginteger',
'Estates.caution_money_expense' => 'biginteger',
'caution_money_expense' => 'biginteger',
'Estates__security_money_category' => 'string',
'Estates.security_money_category' => 'string',
'security_money_category' => 'string',
'Estates__security_money_expense' => 'biginteger',
'Estates.security_money_expense' => 'biginteger',
'security_money_expense' => 'biginteger',
'Estates__key_money_category' => 'string',
'Estates.key_money_category' => 'string',
'key_money_category' => 'string',
'Estates__key_money_expense' => 'biginteger',
'Estates.key_money_expense' => 'biginteger',
'key_money_expense' => 'biginteger',
'Estates__contract' => 'string',
'Estates.contract' => 'string',
'contract' => 'string',
'Estates__business_category' => 'string',
'Estates.business_category' => 'string',
'business_category' => 'string',
'Estates__transfer' => 'string',
'Estates.transfer' => 'string',
'transfer' => 'string',
'Estates__area' => 'string',
'Estates.area' => 'string',
'area' => 'string',
'Estates__note1' => 'string',
'Estates.note1' => 'string',
'note1' => 'string',
'Estates__note2' => 'string',
'Estates.note2' => 'string',
'note2' => 'string',
'Estates__note3' => 'string',
'Estates.note3' => 'string',
'note3' => 'string',
'Estates__internal_note1' => 'string',
'Estates.internal_note1' => 'string',
'internal_note1' => 'string',
'Estates__internal_note2' => 'string',
'Estates.internal_note2' => 'string',
'internal_note2' => 'string',
'Estates__secret' => 'string',
'Estates.secret' => 'string',
'secret' => 'string',
'Estates__staff' => 'string',
'Estates.staff' => 'string',
'staff' => 'string',
'Estates__inputter' => 'string',
'Estates.inputter' => 'string',
'inputter' => 'string',
'Estates__photo_sign' => 'string',
'Estates.photo_sign' => 'string',
'photo_sign' => 'string',
'Estates__photo1' => 'string',
'Estates.photo1' => 'string',
'photo1' => 'string',
'Estates__photo2' => 'string',
'Estates.photo2' => 'string',
'photo2' => 'string',
'Estates__photo3' => 'string',
'Estates.photo3' => 'string',
'photo3' => 'string',
'Estates__photo4' => 'string',
'Estates.photo4' => 'string',
'photo4' => 'string',
'Estates__photo5' => 'string',
'Estates.photo5' => 'string',
'photo5' => 'string',
'Estates__photo6' => 'string',
'Estates.photo6' => 'string',
'photo6' => 'string',
'Estates__floor_plan' => 'string',
'Estates.floor_plan' => 'string',
'floor_plan' => 'string',
'Estates__created' => 'datetime',
'Estates.created' => 'datetime',
'created' => 'datetime',
'Estates__modified' => 'datetime',
'Estates.modified' => 'datetime',
'modified' => 'datetime',
'Estates__deleted' => 'datetime',
'Estates.deleted' => 'datetime',
'deleted' => 'datetime',
'Buildings__id' => 'biginteger',
'Buildings.id' => 'biginteger',
'Buildings__estates_category' => 'string',
'Buildings.estates_category' => 'string',
'estates_category' => 'string',
'Buildings__owner_id' => 'biginteger',
'Buildings.owner_id' => 'biginteger',
'owner_id' => 'biginteger',
'Buildings__management_id' => 'biginteger',
'Buildings.management_id' => 'biginteger',
'management_id' => 'biginteger',
'Buildings__name' => 'string',
'Buildings.name' => 'string',
'Buildings__yomi' => 'string',
'Buildings.yomi' => 'string',
'yomi' => 'string',
'Buildings__area' => 'string',
'Buildings.area' => 'string',
'Buildings__zip' => 'string',
'Buildings.zip' => 'string',
'zip' => 'string',
'Buildings__address1' => 'string',
'Buildings.address1' => 'string',
'Buildings__address2' => 'string',
'Buildings.address2' => 'string',
'Buildings__address3' => 'string',
'Buildings.address3' => 'string',
'address3' => 'string',
'Buildings__address4' => 'string',
'Buildings.address4' => 'string',
'address4' => 'string',
'Buildings__photo' => 'string',
'Buildings.photo' => 'string',
'photo' => 'string',
'Buildings__created' => 'datetime',
'Buildings.created' => 'datetime',
'Buildings__modified' => 'datetime',
'Buildings.modified' => 'datetime',
'Buildings__deleted' => 'datetime',
'Buildings.deleted' => 'datetime'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
'Buildings' => [[maximum depth reached]]
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\EstatesTable) {}
}
$generator = object(Cake\Database\ValueBinder) {
[protected] _bindings => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
],
':c2' => [
[maximum depth reached]
]
]
[protected] _bindingsCount => (int) 3
}count - [internal], line ??
Cake\Database\QueryCompiler::Cake\Database\{closure}() - CORE/src/Database/QueryCompiler.php, line 128
Cake\Database\Query::traverse() - CORE/src/Database/Query.php, line 311
Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99
Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 359
Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 299
Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 282
Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 990
Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136
Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 258
Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 311
Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 213
Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 1011
Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276
Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 959
Cake\ORM\Query::getIterator() - CORE/src/Datasource/QueryTrait.php, line 132
include - APP/Template/Element/estate.ctp, line 71
Warning (2): count() [<a href='http://php.net/function.count'>function.count</a>]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]Code Context {
return function ($parts, $name) use (&$sql, $query, $generator) {
if (!count($parts)) {
$parts = null
$name = 'epilog'
$sql = 'SELECT Estates.id AS `Estates__id`, Estates.type AS `Estates__type`, Estates.invalid AS `Estates__invalid`, Estates.special_selection AS `Estates__special_selection`, Estates.new_sign AS `Estates__new_sign`, Estates.building_id AS `Estates__building_id`, Estates.address1 AS `Estates__address1`, Estates.address2 AS `Estates__address2`, Estates.name AS `Estates__name`, Estates.floor AS `Estates__floor`, Estates.floor_sequence AS `Estates__floor_sequence`, Estates.tsubo AS `Estates__tsubo`, Estates.space AS `Estates__space`, Estates.rent_category AS `Estates__rent_category`, Estates.rent_expense AS `Estates__rent_expense`, Estates.common_service_category AS `Estates__common_service_category`, Estates.common_service_expense AS `Estates__common_service_expense`, Estates.air_conditioning_category AS `Estates__air_conditioning_category`, Estates.air_conditioning_expense AS `Estates__air_conditioning_expense`, Estates.caution_money_category AS `Estates__caution_money_category`, Estates.caution_money_expense AS `Estates__caution_money_expense`, Estates.security_money_category AS `Estates__security_money_category`, Estates.security_money_expense AS `Estates__security_money_expense`, Estates.key_money_category AS `Estates__key_money_category`, Estates.key_money_expense AS `Estates__key_money_expense`, Estates.contract AS `Estates__contract`, Estates.business_category AS `Estates__business_category`, Estates.transfer AS `Estates__transfer`, Estates.area AS `Estates__area`, Estates.note1 AS `Estates__note1`, Estates.note2 AS `Estates__note2`, Estates.note3 AS `Estates__note3`, Estates.internal_note1 AS `Estates__internal_note1`, Estates.internal_note2 AS `Estates__internal_note2`, Estates.secret AS `Estates__secret`, Estates.staff AS `Estates__staff`, Estates.inputter AS `Estates__inputter`, Estates.photo_sign AS `Estates__photo_sign`, Estates.photo1 AS `Estates__photo1`, Estates.photo2 AS `Estates__photo2`, Estates.photo3 AS `Estates__photo3`, Estates.photo4 AS `Estates__photo4`, Estates.photo5 AS `Estates__photo5`, Estates.photo6 AS `Estates__photo6`, Estates.floor_plan AS `Estates__floor_plan`, Estates.created AS `Estates__created`, Estates.modified AS `Estates__modified`, Estates.deleted AS `Estates__deleted`, Buildings.id AS `Buildings__id`, Buildings.estates_category AS `Buildings__estates_category`, Buildings.owner_id AS `Buildings__owner_id`, Buildings.management_id AS `Buildings__management_id`, Buildings.name AS `Buildings__name`, Buildings.yomi AS `Buildings__yomi`, Buildings.area AS `Buildings__area`, Buildings.zip AS `Buildings__zip`, Buildings.address1 AS `Buildings__address1`, Buildings.address2 AS `Buildings__address2`, Buildings.address3 AS `Buildings__address3`, Buildings.address4 AS `Buildings__address4`, Buildings.photo AS `Buildings__photo`, Buildings.created AS `Buildings__created`, Buildings.modified AS `Buildings__modified`, Buildings.deleted AS `Buildings__deleted` FROM estates Estates LEFT JOIN buildings Buildings ON Buildings.id = (Estates.building_id) WHERE (Estates.new_sign IS NULL AND Buildings.area LIKE :c0 AND (Estates.secret IS NULL OR Estates.secret != :c1) AND (Estates.invalid IS NULL OR Estates.invalid != :c2)) ORDER BY Estates.photo_sign DESC, Estates.modified DESC, Estates.id DESC'
$query = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SQL could not be generated for this query as it is incomplete.',
'params' => [],
'defaultTypes' => [
'Estates__id' => 'biginteger',
'Estates.id' => 'biginteger',
'id' => 'biginteger',
'Estates__type' => 'string',
'Estates.type' => 'string',
'type' => 'string',
'Estates__invalid' => 'string',
'Estates.invalid' => 'string',
'invalid' => 'string',
'Estates__special_selection' => 'integer',
'Estates.special_selection' => 'integer',
'special_selection' => 'integer',
'Estates__new_sign' => 'integer',
'Estates.new_sign' => 'integer',
'new_sign' => 'integer',
'Estates__building_id' => 'biginteger',
'Estates.building_id' => 'biginteger',
'building_id' => 'biginteger',
'Estates__address1' => 'string',
'Estates.address1' => 'string',
'address1' => 'string',
'Estates__address2' => 'string',
'Estates.address2' => 'string',
'address2' => 'string',
'Estates__name' => 'string',
'Estates.name' => 'string',
'name' => 'string',
'Estates__floor' => 'string',
'Estates.floor' => 'string',
'floor' => 'string',
'Estates__floor_sequence' => 'integer',
'Estates.floor_sequence' => 'integer',
'floor_sequence' => 'integer',
'Estates__tsubo' => 'decimal',
'Estates.tsubo' => 'decimal',
'tsubo' => 'decimal',
'Estates__space' => 'decimal',
'Estates.space' => 'decimal',
'space' => 'decimal',
'Estates__rent_category' => 'string',
'Estates.rent_category' => 'string',
'rent_category' => 'string',
'Estates__rent_expense' => 'biginteger',
'Estates.rent_expense' => 'biginteger',
'rent_expense' => 'biginteger',
'Estates__common_service_category' => 'string',
'Estates.common_service_category' => 'string',
'common_service_category' => 'string',
'Estates__common_service_expense' => 'biginteger',
'Estates.common_service_expense' => 'biginteger',
'common_service_expense' => 'biginteger',
'Estates__air_conditioning_category' => 'string',
'Estates.air_conditioning_category' => 'string',
'air_conditioning_category' => 'string',
'Estates__air_conditioning_expense' => 'biginteger',
'Estates.air_conditioning_expense' => 'biginteger',
'air_conditioning_expense' => 'biginteger',
'Estates__caution_money_category' => 'string',
'Estates.caution_money_category' => 'string',
'caution_money_category' => 'string',
'Estates__caution_money_expense' => 'biginteger',
'Estates.caution_money_expense' => 'biginteger',
'caution_money_expense' => 'biginteger',
'Estates__security_money_category' => 'string',
'Estates.security_money_category' => 'string',
'security_money_category' => 'string',
'Estates__security_money_expense' => 'biginteger',
'Estates.security_money_expense' => 'biginteger',
'security_money_expense' => 'biginteger',
'Estates__key_money_category' => 'string',
'Estates.key_money_category' => 'string',
'key_money_category' => 'string',
'Estates__key_money_expense' => 'biginteger',
'Estates.key_money_expense' => 'biginteger',
'key_money_expense' => 'biginteger',
'Estates__contract' => 'string',
'Estates.contract' => 'string',
'contract' => 'string',
'Estates__business_category' => 'string',
'Estates.business_category' => 'string',
'business_category' => 'string',
'Estates__transfer' => 'string',
'Estates.transfer' => 'string',
'transfer' => 'string',
'Estates__area' => 'string',
'Estates.area' => 'string',
'area' => 'string',
'Estates__note1' => 'string',
'Estates.note1' => 'string',
'note1' => 'string',
'Estates__note2' => 'string',
'Estates.note2' => 'string',
'note2' => 'string',
'Estates__note3' => 'string',
'Estates.note3' => 'string',
'note3' => 'string',
'Estates__internal_note1' => 'string',
'Estates.internal_note1' => 'string',
'internal_note1' => 'string',
'Estates__internal_note2' => 'string',
'Estates.internal_note2' => 'string',
'internal_note2' => 'string',
'Estates__secret' => 'string',
'Estates.secret' => 'string',
'secret' => 'string',
'Estates__staff' => 'string',
'Estates.staff' => 'string',
'staff' => 'string',
'Estates__inputter' => 'string',
'Estates.inputter' => 'string',
'inputter' => 'string',
'Estates__photo_sign' => 'string',
'Estates.photo_sign' => 'string',
'photo_sign' => 'string',
'Estates__photo1' => 'string',
'Estates.photo1' => 'string',
'photo1' => 'string',
'Estates__photo2' => 'string',
'Estates.photo2' => 'string',
'photo2' => 'string',
'Estates__photo3' => 'string',
'Estates.photo3' => 'string',
'photo3' => 'string',
'Estates__photo4' => 'string',
'Estates.photo4' => 'string',
'photo4' => 'string',
'Estates__photo5' => 'string',
'Estates.photo5' => 'string',
'photo5' => 'string',
'Estates__photo6' => 'string',
'Estates.photo6' => 'string',
'photo6' => 'string',
'Estates__floor_plan' => 'string',
'Estates.floor_plan' => 'string',
'floor_plan' => 'string',
'Estates__created' => 'datetime',
'Estates.created' => 'datetime',
'created' => 'datetime',
'Estates__modified' => 'datetime',
'Estates.modified' => 'datetime',
'modified' => 'datetime',
'Estates__deleted' => 'datetime',
'Estates.deleted' => 'datetime',
'deleted' => 'datetime',
'Buildings__id' => 'biginteger',
'Buildings.id' => 'biginteger',
'Buildings__estates_category' => 'string',
'Buildings.estates_category' => 'string',
'estates_category' => 'string',
'Buildings__owner_id' => 'biginteger',
'Buildings.owner_id' => 'biginteger',
'owner_id' => 'biginteger',
'Buildings__management_id' => 'biginteger',
'Buildings.management_id' => 'biginteger',
'management_id' => 'biginteger',
'Buildings__name' => 'string',
'Buildings.name' => 'string',
'Buildings__yomi' => 'string',
'Buildings.yomi' => 'string',
'yomi' => 'string',
'Buildings__area' => 'string',
'Buildings.area' => 'string',
'Buildings__zip' => 'string',
'Buildings.zip' => 'string',
'zip' => 'string',
'Buildings__address1' => 'string',
'Buildings.address1' => 'string',
'Buildings__address2' => 'string',
'Buildings.address2' => 'string',
'Buildings__address3' => 'string',
'Buildings.address3' => 'string',
'address3' => 'string',
'Buildings__address4' => 'string',
'Buildings.address4' => 'string',
'address4' => 'string',
'Buildings__photo' => 'string',
'Buildings.photo' => 'string',
'photo' => 'string',
'Buildings__created' => 'datetime',
'Buildings.created' => 'datetime',
'Buildings__modified' => 'datetime',
'Buildings.modified' => 'datetime',
'Buildings__deleted' => 'datetime',
'Buildings.deleted' => 'datetime'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
'Buildings' => [[maximum depth reached]]
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\EstatesTable) {}
}
$generator = object(Cake\Database\ValueBinder) {
[protected] _bindings => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
],
':c2' => [
[maximum depth reached]
]
]
[protected] _bindingsCount => (int) 3
}count - [internal], line ??
Cake\Database\QueryCompiler::Cake\Database\{closure}() - CORE/src/Database/QueryCompiler.php, line 128
Cake\Database\Query::traverse() - CORE/src/Database/Query.php, line 311
Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99
Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 359
Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 299
Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 282
Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 990
Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136
Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 258
Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 311
Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 213
Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 1011
Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276
Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 959
Cake\ORM\Query::getIterator() - CORE/src/Datasource/QueryTrait.php, line 132
include - APP/Template/Element/estate.ctp, line 71
北3条西28丁目
事務所
物件番号：1247
賃 料：87,250円
面 積：17.450 坪
階 数：2階
南1条西14丁目
スケルトン
物件番号：2620
賃 料：650,000円
面 積：34.000 坪
階 数：1階
南7条西12丁目
ワインショップ
物件番号：2659
賃 料：170,000円
面 積：38.400 坪
階 数：1階
南1条西13丁目
カレー店
物件番号：2525
賃 料：230,000円
面 積：23.000 坪
階 数：1階
南13条西14丁目
カフェ
物件番号：2472
賃 料：140,000円
面 積：15.000 坪
階 数：1階
南2条西20丁目
スケルトン
物件番号：2464
賃 料：261,900円
面 積：26.190 坪
階 数：1階
南9条西12丁目
スケルトン
物件番号：759
賃 料：98,975円
面 積：11.230 坪
階 数：1階
北3条東3丁目
その他
物件番号：745
賃 料：281,250円
面 積：31.250 坪
階 数：1階
大通西19丁目
オフィス
物件番号：648
賃 料：118,400円
面 積：14.800 坪
階 数：3階
南1条西26丁目
カフェ
物件番号：2878
賃 料：130,000円
面 積：20.000 坪
階 数：B1階
北3条西28丁目
事務所
物件番号：2807
賃 料：174,550円
面 積：34.910 坪
階 数：3階
北3条西28丁目
事務所
物件番号：2806
賃 料：174,550円
面 積：34.910 坪
階 数：5階
北3条西28丁目
事務所
物件番号：2805
賃 料：243,600円
面 積：48.720 坪
階 数：5階
北3条西28丁目
事務所
物件番号：2804
賃 料：121,800円
面 積：24.360 坪
階 数：5階
北3条西28丁目
事務所
物件番号：2803
賃 料：232,700円
面 積：46.540 坪
階 数：4階
北3条西28丁目
事務所
物件番号：2802
賃 料：378,150円
面 積：75.630 坪
階 数：4階
北3条西28丁目
事務所
物件番号：2801
賃 料：121,800円
面 積：24.360 坪
階 数：4階
北3条西28丁目
事務所
物件番号：2800
賃 料：157,450円
面 積：31.490 坪
階 数：3階
北3条西28丁目
事務所
物件番号：2799
賃 料：116,350円
面 積：23.270 坪
階 数：3階
北3条西28丁目
事務所
物件番号：2797
賃 料：138,200円
面 積：27.640 坪
階 数：3階
北3条西28丁目
事務所
物件番号：2798
賃 料：121,800円
面 積：24.360 坪
階 数：3階
北3条西28丁目
事務所
物件番号：2796
賃 料：121,800円
面 積：24.360 坪
階 数：3階
北3条西28丁目
事務所
物件番号：2795
賃 料：87,250円
面 積：17.450 坪
階 数：3階
北3条西28丁目
事務所
物件番号：2794
賃 料：121,800円
面 積：24.360 坪
階 数：2階
北3条西28丁目
事務所
物件番号：2793
賃 料：121,800円
面 積：24.360 坪
階 数：2階
北3条西28丁目
事務所
物件番号：2792
賃 料：250,400円
面 積：50.080 坪
階 数：2階
北3条西28丁目
事務所
物件番号：2791
賃 料：232,700円
面 積：46.540 坪
階 数：2階
北3条西28丁目
ワインバー
物件番号：2789
賃 料：104,700円
面 積：17.450 坪
階 数：B1階
北3条西28丁目
事務所
物件番号：2790
賃 料：24,900円
面 積：4.980 坪
階 数：B2階
南１条西１２丁目
事務所
物件番号：2757
賃 料：209,990円
面 積：38.180 坪
階 数：9階
南１条西１２丁目
事務所
物件番号：2756
賃 料：593,340円
面 積：107.880 坪
階 数：5階
南１条西１２丁目
事務所
物件番号：2755
賃 料：71,940円
面 積：13.080 坪
階 数：4階
南１条西１２丁目
事務所
物件番号：2754
賃 料：138,050円
面 積：25.100 坪
階 数：4階
南１条西１２丁目
事務所
物件番号：2753
賃 料：138,050円
面 積：25.100 坪
階 数：2階
南１条西１２丁目
事務所
物件番号：2752
賃 料：196,570円
面 積：35.740 坪
階 数：2階
宮の森2条６丁目
焼肉
物件番号：2732
賃 料：600,000円
面 積：88.185 坪
階 数：1～2階
南9条西10丁目
店舗
物件番号：2675
賃 料：283,050円
面 積：31.450 坪
階 数：1階
大通西22丁目
スケルトン
物件番号：2673
賃 料：132,000円
面 積：11.000 坪
階 数：1階
南4条西10丁目
託児所
物件番号：2599
賃 料：応談
面 積：43.640 坪
階 数：1階
北5条西27丁目
事務所
物件番号：2547
賃 料：157,000円
面 積：28.810 坪
階 数：2階
大通東2丁目
事務所
物件番号：2545
賃 料：149,000円
面 積：18.530 坪
階 数：6階
大通東2丁目
事務所
物件番号：2544
賃 料：136,000円
面 積：16.950 坪
階 数：5階
大通東2丁目
事務所
物件番号：2543
賃 料：205,000円
面 積：25.500 坪
階 数：B1階
南1条東2丁目
物販
物件番号：2339
賃 料：837,200円
面 積：64.400 坪
階 数：1階
北11条西20丁目
その他
物件番号：1098
賃 料：72,000円
面 積：9.670 坪
階 数：1階
南1条東1丁目
オフィス
物件番号：1453
賃 料：513,229円
面 積：54.310 坪
階 数：3階
南1条東1丁目
オフィス
物件番号：1452
賃 料：371,857円
面 積：39.350 坪
階 数：5階
南1条東1丁目
その他
物件番号：1451
賃 料：812,605円
面 積：85.990 坪
階 数：5階
南1条東1丁目
その他
物件番号：1450
賃 料：241,353円
面 積：25.540 坪
階 数：8階
南1条東2丁目
オフィス
物件番号：1449
賃 料：1,529,808円
面 積：182.120 坪
階 数：2階
南1条東2丁目
オフィス
物件番号：1448
賃 料：238,056円
面 積：28.340 坪
階 数：3階
南1条東2丁目
オフィス
物件番号：1447
賃 料：217,728円
面 積：25.920 坪
階 数：3階
北4条西15丁目
オフィス
物件番号：1405
賃 料：367,500円
面 積：70.000 坪
階 数：3階
北7条西14丁目
その他
物件番号：1403
賃 料：126,000円
面 積：19.660 坪
階 数：1階
北6条西24丁目
その他
物件番号：1397
賃 料：48,000円
面 積：10.150 坪
階 数：3階
大通東3丁目
その他
物件番号：1383
賃 料：80,000円
面 積：18.180 坪
階 数：3階
大通東3丁目
その他
物件番号：1382
賃 料：100,000円
面 積：40.110 坪
階 数：5階
南2条東2丁目
スケルトン
物件番号：1301
賃 料：112,560円
面 積：16.080 坪
階 数：B1階
南2条東2丁目
その他
物件番号：1300
賃 料：114,870円
面 積：16.410 坪
階 数：B1階
南2条東2丁目
居酒屋
物件番号：1299
賃 料：140,505円
面 積：16.530 坪
階 数：B1階
南1条東1丁目
オフィス
物件番号：1298
賃 料：1,215,553円
面 積：128.630 坪
階 数：5階
南14条西6丁目
オフィス
物件番号：1033
賃 料：240,000円
面 積：65.400 坪
階 数：5階
南1条西17丁目
焼鳥
物件番号：1032
賃 料：120,000円
面 積：20.000 坪
階 数：2階
南5条西23丁目
イタリアン
物件番号：986
賃 料：200,000円
面 積：24.500 坪
階 数：1階
北3条西7丁目
居酒屋
物件番号：958
賃 料：120,000円
面 積：19.920 坪
階 数：B1階
大通西18丁目
オフィス
物件番号：809
賃 料：75,960円
面 積：12.660 坪
階 数：6階
大通西19丁目
スケルトン
物件番号：684
賃 料：214,560円
面 積：17.880 坪
階 数：1階
