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 (Estates.secret IS NULL OR Estates.secret != :c0) AND (Estates.invalid IS NULL OR Estates.invalid != :c1))'
$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]
]
]
[protected] _bindingsCount => (int) 2
}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/estatetop.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 (Estates.secret IS NULL OR Estates.secret != :c0) AND (Estates.invalid IS NULL OR Estates.invalid != :c1)) 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]
]
]
[protected] _bindingsCount => (int) 2
}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/estatetop.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 (Estates.secret IS NULL OR Estates.secret != :c0) AND (Estates.invalid IS NULL OR Estates.invalid != :c1)) 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]
]
]
[protected] _bindingsCount => (int) 2
}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/estatetop.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 (Estates.secret IS NULL OR Estates.secret != :c0) AND (Estates.invalid IS NULL OR Estates.invalid != :c1)) 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]
]
]
[protected] _bindingsCount => (int) 2
}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/estatetop.ctp, line 71
北24条西4丁目
パブ
物件番号:2460
賃 料:130,000円
面 積:13.500 坪
階 数:1階
南5条西5丁目
ダイニングバー
物件番号:2869
賃 料:450,000円
面 積:50.000 坪
階 数:9階
北1条西8丁目
立呑み
物件番号:2530
賃 料:220,000円
面 積:16.190 坪
階 数:1階
南4条西5丁目
ダイニングバー
物件番号:2658
賃 料:125,580円
面 積:9.660 坪
階 数:11階
南4条西3丁目
スケルトン
物件番号:2605
賃 料:506,550円
面 積:30.700 坪
階 数:1階
南1条西5丁目
レストラン
物件番号:2307
賃 料:235,900円
面 積:23.590 坪
階 数:B1階
南3条西6丁目
スケルトン
物件番号:2531
賃 料:733,900円
面 積:76.500 坪
階 数:B1階
南5条西3丁目
おばんざい・居酒屋
物件番号:2573
賃 料:150,960円
面 積:12.580 坪
階 数:4階
南4条西3丁目
事務所
物件番号:2849
賃 料:825,703円
面 積:113.110 坪
階 数:2階
南6条西3丁目
スナック
物件番号:2448
賃 料:75,000円
面 積:6.370 坪
階 数:5階
南3条西5丁目
事務所
物件番号:2741
賃 料:119,500円
面 積:16.460 坪
階 数:6階
南5条西2丁目
ラウンジ
物件番号:581
賃 料:310,000円
面 積:25.500 坪
階 数:8階
南5条西2丁目
パブ
物件番号:580
賃 料:330,000円
面 積:27.500 坪
階 数:7階
南3条西3丁目
スケルトン
物件番号:1101
賃 料:130,000円
面 積:16.000 坪
階 数:B1階
南4条西3丁目
事務所
物件番号:2783
賃 料:253,840円
面 積:31.730 坪
階 数:2階
南4条西3丁目
オフィス・その他
物件番号:885
賃 料:500,800円
面 積:62.600 坪
階 数:2階
南4条西3丁目
事務所
物件番号:2784
賃 料:154,710円
面 積:18.780 坪
階 数:2階
北3条西28丁目
事務所
物件番号:1247
賃 料:87,250円
面 積:17.450 坪
階 数:2階
南4条西2丁目
居酒屋
物件番号:2
賃 料:518,980円
面 積:47.180 坪
階 数:5階
南5条西4丁目
スナック
物件番号:2038
賃 料:108,290円
面 積:8.330 坪
階 数:8階
南5条西2丁目
パブ
物件番号:1292
賃 料:170,000円
面 積:14.100 坪
階 数:7階
南6条西3丁目
スケルトン
物件番号:2696
賃 料:120,000円
面 積:16.080 坪
階 数:B1階
南6条西4丁目
スケルトン
物件番号:647
賃 料:171,000円
面 積:17.100 坪
階 数:1階
南1条西14丁目
スケルトン
物件番号:2620
賃 料:650,000円
面 積:34.000 坪
階 数:1階
南5条西5丁目
ダイニングバー
物件番号:1513
賃 料:290,260円
面 積:25.240 坪
階 数:5階
南4条西3丁目
ダーツバー
物件番号:1022
賃 料:330,000円
面 積:30.000 坪
階 数:4階
南5条西4丁目
ライブハウス
物件番号:1812
賃 料:374,000円
面 積:34.000 坪
階 数:B1階
南4条西3丁目
居酒屋
物件番号:1251
賃 料:192,500円
面 積:17.500 坪
階 数:5階
南4条西2丁目
ダイニングバー
物件番号:716
賃 料:651,600円
面 積:43.440 坪
階 数:1階
南7条西12丁目
ワインショップ
物件番号:2659
賃 料:170,000円
面 積:38.400 坪
階 数:1階
南郷通2丁目南
居酒屋
物件番号:2644
賃 料:400,000円
面 積:84.540 坪
階 数:1階
南4条西3丁目
バー
物件番号:2506
賃 料:200,200円
面 積:15.400 坪
階 数:4階
南5条西4丁目
スナック
物件番号:2722
賃 料:123,240円
面 積:9.480 坪
階 数:9階
南5条西4丁目
スナック
物件番号:2723
賃 料:123,240円
面 積:9.480 坪
階 数:9階
南5条西4丁目
スナック
物件番号:2721
賃 料:74,970円
面 積:8.330 坪
階 数:8階
南6条西4丁目
スナック
物件番号:505
賃 料:68,800円
面 積:8.600 坪
階 数:3階
南7条西5丁目
スケルトン
物件番号:2369
賃 料:155,540円
面 積:22.220 坪
階 数:1階
南4条西3丁目
ラウンジ
物件番号:2375
賃 料:422,500円
面 積:32.500 坪
階 数:4階
南7条西3丁目
寿司
物件番号:837
賃 料:335,880円
面 積:35.400 坪
階 数:2階
南5条西5丁目
バー
物件番号:2559
賃 料:184,100円
面 積:18.410 坪
階 数:6階
南5条西5丁目
ラウンジ
物件番号:2557
賃 料:184,100円
面 積:18.410 坪
階 数:5階
南5条西5丁目
バー
物件番号:2558
賃 料:127,500円
面 積:12.750 坪
階 数:4階
南2条西6丁目
オフィス
物件番号:811
賃 料:118,500円
面 積:15.800 坪
階 数:2階
南5条西2丁目
スポーツバー
物件番号:2386
賃 料:610,800円
面 積:50.900 坪
階 数:5階
南5条西2丁目
スケルトン
物件番号:576
賃 料:495,600円
面 積:41.300 坪
階 数:4階
南5条西3丁目
バー
物件番号:2325
賃 料:141,700円
面 積:13.000 坪
階 数:8階
南5条西2丁目
スケルトン
物件番号:2511
賃 料:1,924,800円
面 積:160.400 坪
階 数:12階
南7条西4丁目
バー
物件番号:2560
賃 料:150,880円
面 積:18.860 坪
階 数:4階
南7条西4丁目
バー
物件番号:2561
賃 料:132,560円
面 積:16.570 坪
階 数:2階
平岸4条8丁目
居酒屋
物件番号:2583
賃 料:130,000円
面 積:22.300 坪
階 数:1階
南5条西4丁目
居酒屋
物件番号:1025
賃 料:281,710円
面 積:25.610 坪
階 数:2階
南6条西4丁目
居酒屋
物件番号:2566
賃 料:60,000円
面 積:13.800 坪
階 数:4階
南2条西4丁目
物販
物件番号:2517
賃 料:1,750,000円
面 積:61.890 坪
階 数:B1階
南1条西13丁目
カレー店
物件番号:2525
賃 料:230,000円
面 積:23.000 坪
階 数:1階
北23条西4丁目
オフィス・その他
物件番号:2520
賃 料:162,000円
面 積:32.000 坪
階 数:2階
北23条西4丁目
物販・その他
物件番号:2519
賃 料:600,000円
面 積:35.000 坪
階 数:1階
南1条西5丁目
居酒屋
物件番号:733
賃 料:387,000円
面 積:43.000 坪
階 数:5階
南13条西14丁目
カフェ
物件番号:2472
賃 料:140,000円
面 積:15.000 坪
階 数:1階
北1条西10丁目
スケルトン
物件番号:2471
賃 料:125,000円
面 積:13.700 坪
階 数:1階
南2条西20丁目
スケルトン
物件番号:2464
賃 料:261,900円
面 積:26.190 坪
階 数:1階
南1条西5丁目
ネイル
物件番号:2398
賃 料:95,000円
面 積:11.994 坪
階 数:6階
南4条西3丁目
ラウンジ
物件番号:2370
賃 料:148,900円
面 積:14.892 坪
階 数:5階
南7条西3丁目
オフィス
物件番号:881
賃 料:83,000円
面 積:10.400 坪
階 数:3階
南1条西6丁目
オフィス
物件番号:2360
賃 料:126,770円
面 積:18.110 坪
階 数:5階
南1条西5丁目
オフィス
物件番号:2358
賃 料:60,060円
面 積:10.920 坪
階 数:9階
南6条西3丁目
居酒屋
物件番号:2354
賃 料:82,500円
面 積:10.380 坪
階 数:3階
南5条西4丁目
ライブハウス
物件番号:2305
賃 料:198,170円
面 積:20.860 坪
階 数:7階
南3条西2丁目
その他
物件番号:2345
賃 料:500,000円
面 積:45.000 坪
階 数:3階
南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階
南5条西5丁目
居酒屋
物件番号:2332
賃 料:146,668円
面 積:12.960 坪
階 数:2階
南6条西4丁目
スナック
物件番号:1960
賃 料:90,400円
面 積:11.300 坪
階 数:4階
南6条西4丁目
焼鳥
物件番号:798
賃 料:106,400円
面 積:13.300 坪
階 数:3階
南6条西4丁目
スナック
物件番号:503
賃 料:76,800円
面 積:9.600 坪
階 数:4階
南6条西4丁目
スナック
物件番号:2218
賃 料:125,600円
面 積:15.700 坪
階 数:3階
南6条西4丁目
スナック
物件番号:504
賃 料:68,000円
面 積:8.500 坪
階 数:4階
南6条西4丁目
スナック
物件番号:799
賃 料:90,400円
面 積:11.300 坪
階 数:6階
南7条西8丁目
オフィス
物件番号:2315
賃 料:130,000円
面 積:31.557 坪
階 数:3階
北1条西2丁目
スケルトン
物件番号:1019
賃 料:123,970円
面 積:11.270 坪
階 数:B1階