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
北1条西8丁目
立呑み
物件番号：2530
賃 料：220,000円
面 積：16.190 坪
階 数：1階
南1条西5丁目
レストラン
物件番号：2307
賃 料：235,900円
面 積：23.590 坪
階 数：B1階
南2条西6丁目
オフィス
物件番号：811
賃 料：118,500円
面 積：15.800 坪
階 数：2階
南2条西4丁目
物販
物件番号：2517
賃 料：1,750,000円
面 積：61.890 坪
階 数：B1階
南1条西5丁目
居酒屋
物件番号：733
賃 料：387,000円
面 積：43.000 坪
階 数：5階
北1条西10丁目
スケルトン
物件番号：2471
賃 料：125,000円
面 積：13.700 坪
階 数：1階
南1条西5丁目
ネイル
物件番号：2398
賃 料：95,000円
面 積：11.994 坪
階 数：6階
南1条西6丁目
オフィス
物件番号：2360
賃 料：126,770円
面 積：18.110 坪
階 数：5階
南1条西5丁目
オフィス
物件番号：2358
賃 料：60,060円
面 積：10.920 坪
階 数：9階
南2条西5丁目
ブライダル
物件番号：2303
賃 料：2,500,000円
面 積：236.307 坪
階 数：1棟階
南2条西2丁目
物販
物件番号：2344
賃 料：700,000円
面 積：52.350 坪
階 数：2階
南1条西8丁目
その他
物件番号：2343
賃 料：108,120円
面 積：18.020 坪
階 数：2階
北1条西2丁目
スケルトン
物件番号：1019
賃 料：123,970円
面 積：11.270 坪
階 数：B1階
南1条西3丁目
その他
物件番号：1273
賃 料：470,400円
面 積：58.800 坪
階 数：3階
南1条西5丁目
その他
物件番号：1092
賃 料：228,600円
面 積：25.400 坪
階 数：2階
南1条西11丁目
その他
物件番号：1066
賃 料：59,785円
面 積：10.870 坪
階 数：3階
南1条西11丁目
その他
物件番号：1064
賃 料：189,200円
面 積：34.400 坪
階 数：5階
南1条西11丁目
その他
物件番号：1063
賃 料：120,835円
面 積：21.970 坪
階 数：1階
南2条西1丁目
スケルトン
物件番号：933
賃 料：534,650円
面 積：31.450 坪
階 数：1階
南1条西5丁目
その他
物件番号：779
賃 料：189,000円
面 積：31.500 坪
階 数：5階
南1条西9丁目
オフィス
物件番号：778
賃 料：300,100円
面 積：30.010 坪
階 数：1階
南2条西1丁目
スケルトン
物件番号：661
賃 料：445,936円
面 積：23.720 坪
階 数：1階
南2条西1丁目
スケルトン
物件番号：660
賃 料：391,986円
面 積：16.470 坪
階 数：1階
大通西10丁目
スケルトン
物件番号：659
賃 料：123,120円
面 積：15.390 坪
階 数：B1階
大通西10丁目
スケルトン
物件番号：658
賃 料：175,680円
面 積：21.960 坪
階 数：B2階
大通西10丁目
物販
物件番号：657
賃 料：31,200円
面 積：3.900 坪
階 数：B2階
南2条西1丁目
スケルトン
物件番号：646
賃 料：171,300円
面 積：11.420 坪
階 数：2階
南2条西4丁目
スケルトン
物件番号：641
賃 料：165,000円
面 積：10.000 坪
階 数：B1階
南1条西7丁目
多業種可能
物件番号：2834
賃 料：150,000円
面 積：11.840 坪
階 数：B1階
大通西5丁目
事務所
物件番号：2833
賃 料：97,760円
面 積：12.220 坪
階 数：7階
大通西5丁目
事務所
物件番号：2832
賃 料：404,460円
面 積：44.940 坪
階 数：7階
大通西5丁目
事務所
物件番号：2831
賃 料：450,450円
面 積：50.050 坪
階 数：7階
大通西5丁目
店舗
物件番号：341
賃 料：60,000円
面 積：2.000 坪
階 数：B1階
南1条西10丁目
事務所
物件番号：2788
賃 料：169,150円
面 積：19.900 坪
階 数：5階
南1条西10丁目
事務所
物件番号：2628
賃 料：169,150円
面 積：19.900 坪
階 数：4階
南1条西10丁目
事務所
物件番号：2627
賃 料：455,600円
面 積：53.600 坪
階 数：3階
南1条西10丁目
事務所
物件番号：2626
賃 料：147,050円
面 積：17.300 坪
階 数：2階
南1条西6丁目
事務所
物件番号：2542
賃 料：795,000円
面 積：79.500 坪
階 数：5階
南1条西7丁目
飲食店
物件番号：2703
賃 料：350,000円
面 積：23.330 坪
階 数：1階
南1条西9丁目
店舗
物件番号：2702
賃 料：455,580円
面 積：50.620 坪
階 数：1階
南2条西6丁目
スケルトン
物件番号：2666
賃 料：応談
面 積：35.600 坪
階 数：1～2階
大通西11丁目
生花店
物件番号：2656
賃 料：50,000円
面 積：2.370 坪
階 数：B2階
北 2条西4丁目
オフィス・その他
物件番号：2580
賃 料： －
面 積：11.000 坪
階 数：1階
南1条西6丁目
事務所
物件番号：2518
賃 料：77,000円
面 積：6.400 坪
階 数：2階
南1条西5丁目
オフィス
物件番号：2359
賃 料：136,900円
面 積：13.690 坪
階 数：6階
南2条西1丁目
オフィス
物件番号：1584
賃 料：370,000円
面 積：46.480 坪
階 数：3階
南1条西4丁目
オフィス
物件番号：1385
賃 料：168,000円
面 積：27.600 坪
階 数：3階
南1条西4丁目
オフィス
物件番号：1384
賃 料：124,000円
面 積：20.290 坪
階 数：3階
北1条西5丁目
スケルトン
物件番号：1358
賃 料：119,200円
面 積：14.900 坪
階 数：B1階
北1条西3丁目
スケルトン
物件番号：1346
賃 料：1,550,430円
面 積：98.440 坪
階 数：1階
大通西2丁目
その他
物件番号：1278
賃 料：580,030円
面 積：52.730 坪
階 数：2階
大通西2丁目
その他
物件番号：1277
賃 料：283,220円
面 積：28.900 坪
階 数：9階
南2条西1丁目
その他
物件番号：1258
賃 料：145,000円
面 積：22.000 坪
階 数：3階
南2条西1丁目(狸小路1丁目)
その他
物件番号：1257
賃 料：261,800円
面 積：23.800 坪
階 数：3階
大通西2丁目
その他
物件番号：1226
賃 料：508,935円
面 積：27.510 坪
階 数：1階
南2条西4丁目
居酒屋
物件番号：1201
賃 料：650,000円
面 積：33.000 坪
階 数：1階
南1条西2丁目
その他
物件番号：1156
賃 料：122,600円
面 積：6.130 坪
階 数：1階
南2条西4丁目
物販
物件番号：1127
賃 料：571,860円
面 積：31.770 坪
階 数：2階
南2条西4丁目
その他
物件番号：1126
賃 料：253,800円
面 積：21.150 坪
階 数：2階
北1条西2丁目
スケルトン
物件番号：1116
賃 料：317,570円
面 積：28.870 坪
階 数：B1階
南1条西4丁目
スケルトン
物件番号：1069
賃 料：応談
面 積：165.190 坪
階 数：B1階
南1条西4丁目
スケルトン
物件番号：1068
賃 料：応談
面 積：216.530 坪
階 数：B2階
南1条西11丁目
その他
物件番号：1065
賃 料：198,220円
面 積：36.040 坪
階 数：4階
南1条西2丁目
レストラン
物件番号：1035
賃 料：220,964円
面 積：30.380 坪
階 数：B1階
南2条西2丁目
その他
物件番号：1029
賃 料：360,000円
面 積：40.000 坪
階 数：B1階
大通西10丁目
居酒屋
物件番号：963
賃 料：111,930円
面 積：13.000 坪
階 数：B1階
北1条西3丁目
その他
物件番号：848
賃 料：511,000円
面 積：73.100 坪
階 数：B1階
南1条西2丁目
オフィス
物件番号：810
賃 料：57,900円
面 積：9.650 坪
階 数：6階
北1条西3丁目
オフィス
物件番号：773
賃 料：308,750円
面 積：32.500 坪
階 数：3階
北1条西3丁目
その他
物件番号：768
賃 料：5,178,264円
面 積：142.260 坪
階 数：1階
南2条西1丁目
物販
物件番号：696
賃 料：232,500円
面 積：15.500 坪
階 数：1階
南1条西5丁目
オフィス
物件番号：678
賃 料：641,700円
面 積：64.170 坪
階 数：3階
南1条西7丁目
オフィス
物件番号：677
賃 料：273,375円
面 積：60.750 坪
階 数：8階
南2条西4丁目(狸小路4丁目)
物販
物件番号：675
賃 料：165,000円
面 積：11.000 坪
階 数：1階
