Warning (2): count(): 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 Offices.id AS `Offices__id`, Offices.name AS `Offices__name`, Offices.slug AS `Offices__slug`, Offices.category AS `Offices__category`, Offices.presentation AS `Offices__presentation`, Offices.logo AS `Offices__logo`, Offices.email AS `Offices__email`, Offices.website AS `Offices__website`, Offices.active AS `Offices__active`, Offices.location_id AS `Offices__location_id`, Offices.user_id AS `Offices__user_id`, Locations.id AS `Locations__id`, Locations.adress1 AS `Locations__adress1`, Locations.adress2 AS `Locations__adress2`, Locations.city AS `Locations__city`, Locations.state AS `Locations__state`, Locations.phone1 AS `Locations__phone1`, Locations.phone2 AS `Locations__phone2`, Locations.fax AS `Locations__fax`, Locations.lng AS `Locations__lng`, Locations.lat AS `Locations__lat`, Locations.country_id AS `Locations__country_id`, Countries.id AS `Countries__id`, Countries.country_code AS `Countries__country_code`, Countries.country_name AS `Countries__country_name`, Countries.currency_code AS `Countries__currency_code` FROM offices Offices INNER JOIN locations Locations ON Locations.id = (Offices.location_id) LEFT JOIN countries Countries ON Countries.id = (Locations.country_id) WHERE Offices.id = :c0'
$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' => [
		'Offices__id' => 'integer',
		'Offices.id' => 'integer',
		'id' => 'integer',
		'Offices__name' => 'string',
		'Offices.name' => 'string',
		'name' => 'string',
		'Offices__slug' => 'string',
		'Offices.slug' => 'string',
		'slug' => 'string',
		'Offices__category' => 'string',
		'Offices.category' => 'string',
		'category' => 'string',
		'Offices__presentation' => 'text',
		'Offices.presentation' => 'text',
		'presentation' => 'text',
		'Offices__logo' => 'string',
		'Offices.logo' => 'string',
		'logo' => 'string',
		'Offices__email' => 'string',
		'Offices.email' => 'string',
		'email' => 'string',
		'Offices__website' => 'string',
		'Offices.website' => 'string',
		'website' => 'string',
		'Offices__active' => 'boolean',
		'Offices.active' => 'boolean',
		'active' => 'boolean',
		'Offices__location_id' => 'integer',
		'Offices.location_id' => 'integer',
		'location_id' => 'integer',
		'Offices__user_id' => 'integer',
		'Offices.user_id' => 'integer',
		'user_id' => 'integer',
		'Locations__id' => 'integer',
		'Locations.id' => 'integer',
		'Locations__adress1' => 'string',
		'Locations.adress1' => 'string',
		'adress1' => 'string',
		'Locations__adress2' => 'string',
		'Locations.adress2' => 'string',
		'adress2' => 'string',
		'Locations__city' => 'string',
		'Locations.city' => 'string',
		'city' => 'string',
		'Locations__state' => 'string',
		'Locations.state' => 'string',
		'state' => 'string',
		'Locations__phone1' => 'string',
		'Locations.phone1' => 'string',
		'phone1' => 'string',
		'Locations__phone2' => 'string',
		'Locations.phone2' => 'string',
		'phone2' => 'string',
		'Locations__fax' => 'string',
		'Locations.fax' => 'string',
		'fax' => 'string',
		'Locations__lng' => 'string',
		'Locations.lng' => 'string',
		'lng' => 'string',
		'Locations__lat' => 'string',
		'Locations.lat' => 'string',
		'lat' => 'string',
		'Locations__country_id' => 'integer',
		'Locations.country_id' => 'integer',
		'country_id' => 'integer',
		'Countries__id' => 'integer',
		'Countries.id' => 'integer',
		'Countries__country_code' => 'string',
		'Countries.country_code' => 'string',
		'country_code' => 'string',
		'Countries__country_name' => 'string',
		'Countries.country_name' => 'string',
		'country_name' => 'string',
		'Countries__currency_code' => 'string',
		'Countries.currency_code' => 'string',
		'currency_code' => 'string',
		'Sales__id' => 'integer',
		'Sales.id' => 'integer',
		'Sales__price' => 'integer',
		'Sales.price' => 'integer',
		'price' => 'integer',
		'Sales__usd_price' => 'integer',
		'Sales.usd_price' => 'integer',
		'usd_price' => 'integer',
		'Sales__title' => 'string',
		'Sales.title' => 'string',
		'title' => 'string',
		'Sales__slug' => 'string',
		'Sales.slug' => 'string',
		'Sales__description' => 'text',
		'Sales.description' => 'text',
		'description' => 'text',
		'Sales__year' => 'text',
		'Sales.year' => 'text',
		'year' => 'text',
		'Sales__location' => 'string',
		'Sales.location' => 'string',
		'location' => 'string',
		'Sales__adress' => 'string',
		'Sales.adress' => 'string',
		'adress' => 'string',
		'Sales__internal_reference' => 'string',
		'Sales.internal_reference' => 'string',
		'internal_reference' => 'string',
		'Sales__validate' => 'boolean',
		'Sales.validate' => 'boolean',
		'validate' => 'boolean',
		'Sales__active' => 'boolean',
		'Sales.active' => 'boolean',
		'Sales__views' => 'integer',
		'Sales.views' => 'integer',
		'views' => 'integer',
		'Sales__created' => 'datetime',
		'Sales.created' => 'datetime',
		'created' => 'datetime',
		'Sales__currency_id' => 'integer',
		'Sales.currency_id' => 'integer',
		'currency_id' => 'integer',
		'Sales__car_id' => 'integer',
		'Sales.car_id' => 'integer',
		'car_id' => 'integer',
		'Sales__real_estate_id' => 'integer',
		'Sales.real_estate_id' => 'integer',
		'real_estate_id' => 'integer',
		'Sales__watche_id' => 'integer',
		'Sales.watche_id' => 'integer',
		'watche_id' => 'integer',
		'Sales__yacht_id' => 'integer',
		'Sales.yacht_id' => 'integer',
		'yacht_id' => 'integer',
		'Sales__office_id' => 'integer',
		'Sales.office_id' => 'integer',
		'office_id' => 'integer',
		'Sales__agent_id' => 'integer',
		'Sales.agent_id' => 'integer',
		'agent_id' => 'integer',
		'Sales__user_id' => 'integer',
		'Sales.user_id' => 'integer',
		'Pictures__id' => 'integer',
		'Pictures.id' => 'integer',
		'Pictures__name' => 'string',
		'Pictures.name' => 'string',
		'Pictures__rang' => 'integer',
		'Pictures.rang' => 'integer',
		'rang' => 'integer',
		'Pictures__sale_id' => 'integer',
		'Pictures.sale_id' => 'integer',
		'sale_id' => 'integer'
	],
	'decorators' => (int) 0,
	'executed' => false,
	'hydrate' => true,
	'buffered' => true,
	'formatters' => (int) 0,
	'mapReducers' => (int) 0,
	'contain' => [
		'Locations' => [
			[maximum depth reached]
		],
		'Sales' => [
			[maximum depth reached]
		]
	],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\OfficesTable) {}

}
$generator = object(Cake\Database\ValueBinder) {
	[protected] _bindings => [
		':c0' => [
			[maximum depth reached]
		]
	]
	[protected] _bindingsCount => (int) 1
}
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 257
Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99
Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333
Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262
Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 228
Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 936
Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136
Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221
Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274
Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 190
Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 957
Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276
Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 905
Cake\ORM\Query::first() - CORE/src/Datasource/QueryTrait.php, line 404
App\Controller\OfficesController::show() - APP/Controller/OfficesController.php, line 24

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 = 'order'
$sql = 'SELECT Offices.id AS `Offices__id`, Offices.name AS `Offices__name`, Offices.slug AS `Offices__slug`, Offices.category AS `Offices__category`, Offices.presentation AS `Offices__presentation`, Offices.logo AS `Offices__logo`, Offices.email AS `Offices__email`, Offices.website AS `Offices__website`, Offices.active AS `Offices__active`, Offices.location_id AS `Offices__location_id`, Offices.user_id AS `Offices__user_id`, Locations.id AS `Locations__id`, Locations.adress1 AS `Locations__adress1`, Locations.adress2 AS `Locations__adress2`, Locations.city AS `Locations__city`, Locations.state AS `Locations__state`, Locations.phone1 AS `Locations__phone1`, Locations.phone2 AS `Locations__phone2`, Locations.fax AS `Locations__fax`, Locations.lng AS `Locations__lng`, Locations.lat AS `Locations__lat`, Locations.country_id AS `Locations__country_id`, Countries.id AS `Countries__id`, Countries.country_code AS `Countries__country_code`, Countries.country_name AS `Countries__country_name`, Countries.currency_code AS `Countries__currency_code` FROM offices Offices INNER JOIN locations Locations ON Locations.id = (Offices.location_id) LEFT JOIN countries Countries ON Countries.id = (Locations.country_id) WHERE Offices.id = :c0'
$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' => [
		'Offices__id' => 'integer',
		'Offices.id' => 'integer',
		'id' => 'integer',
		'Offices__name' => 'string',
		'Offices.name' => 'string',
		'name' => 'string',
		'Offices__slug' => 'string',
		'Offices.slug' => 'string',
		'slug' => 'string',
		'Offices__category' => 'string',
		'Offices.category' => 'string',
		'category' => 'string',
		'Offices__presentation' => 'text',
		'Offices.presentation' => 'text',
		'presentation' => 'text',
		'Offices__logo' => 'string',
		'Offices.logo' => 'string',
		'logo' => 'string',
		'Offices__email' => 'string',
		'Offices.email' => 'string',
		'email' => 'string',
		'Offices__website' => 'string',
		'Offices.website' => 'string',
		'website' => 'string',
		'Offices__active' => 'boolean',
		'Offices.active' => 'boolean',
		'active' => 'boolean',
		'Offices__location_id' => 'integer',
		'Offices.location_id' => 'integer',
		'location_id' => 'integer',
		'Offices__user_id' => 'integer',
		'Offices.user_id' => 'integer',
		'user_id' => 'integer',
		'Locations__id' => 'integer',
		'Locations.id' => 'integer',
		'Locations__adress1' => 'string',
		'Locations.adress1' => 'string',
		'adress1' => 'string',
		'Locations__adress2' => 'string',
		'Locations.adress2' => 'string',
		'adress2' => 'string',
		'Locations__city' => 'string',
		'Locations.city' => 'string',
		'city' => 'string',
		'Locations__state' => 'string',
		'Locations.state' => 'string',
		'state' => 'string',
		'Locations__phone1' => 'string',
		'Locations.phone1' => 'string',
		'phone1' => 'string',
		'Locations__phone2' => 'string',
		'Locations.phone2' => 'string',
		'phone2' => 'string',
		'Locations__fax' => 'string',
		'Locations.fax' => 'string',
		'fax' => 'string',
		'Locations__lng' => 'string',
		'Locations.lng' => 'string',
		'lng' => 'string',
		'Locations__lat' => 'string',
		'Locations.lat' => 'string',
		'lat' => 'string',
		'Locations__country_id' => 'integer',
		'Locations.country_id' => 'integer',
		'country_id' => 'integer',
		'Countries__id' => 'integer',
		'Countries.id' => 'integer',
		'Countries__country_code' => 'string',
		'Countries.country_code' => 'string',
		'country_code' => 'string',
		'Countries__country_name' => 'string',
		'Countries.country_name' => 'string',
		'country_name' => 'string',
		'Countries__currency_code' => 'string',
		'Countries.currency_code' => 'string',
		'currency_code' => 'string',
		'Sales__id' => 'integer',
		'Sales.id' => 'integer',
		'Sales__price' => 'integer',
		'Sales.price' => 'integer',
		'price' => 'integer',
		'Sales__usd_price' => 'integer',
		'Sales.usd_price' => 'integer',
		'usd_price' => 'integer',
		'Sales__title' => 'string',
		'Sales.title' => 'string',
		'title' => 'string',
		'Sales__slug' => 'string',
		'Sales.slug' => 'string',
		'Sales__description' => 'text',
		'Sales.description' => 'text',
		'description' => 'text',
		'Sales__year' => 'text',
		'Sales.year' => 'text',
		'year' => 'text',
		'Sales__location' => 'string',
		'Sales.location' => 'string',
		'location' => 'string',
		'Sales__adress' => 'string',
		'Sales.adress' => 'string',
		'adress' => 'string',
		'Sales__internal_reference' => 'string',
		'Sales.internal_reference' => 'string',
		'internal_reference' => 'string',
		'Sales__validate' => 'boolean',
		'Sales.validate' => 'boolean',
		'validate' => 'boolean',
		'Sales__active' => 'boolean',
		'Sales.active' => 'boolean',
		'Sales__views' => 'integer',
		'Sales.views' => 'integer',
		'views' => 'integer',
		'Sales__created' => 'datetime',
		'Sales.created' => 'datetime',
		'created' => 'datetime',
		'Sales__currency_id' => 'integer',
		'Sales.currency_id' => 'integer',
		'currency_id' => 'integer',
		'Sales__car_id' => 'integer',
		'Sales.car_id' => 'integer',
		'car_id' => 'integer',
		'Sales__real_estate_id' => 'integer',
		'Sales.real_estate_id' => 'integer',
		'real_estate_id' => 'integer',
		'Sales__watche_id' => 'integer',
		'Sales.watche_id' => 'integer',
		'watche_id' => 'integer',
		'Sales__yacht_id' => 'integer',
		'Sales.yacht_id' => 'integer',
		'yacht_id' => 'integer',
		'Sales__office_id' => 'integer',
		'Sales.office_id' => 'integer',
		'office_id' => 'integer',
		'Sales__agent_id' => 'integer',
		'Sales.agent_id' => 'integer',
		'agent_id' => 'integer',
		'Sales__user_id' => 'integer',
		'Sales.user_id' => 'integer',
		'Pictures__id' => 'integer',
		'Pictures.id' => 'integer',
		'Pictures__name' => 'string',
		'Pictures.name' => 'string',
		'Pictures__rang' => 'integer',
		'Pictures.rang' => 'integer',
		'rang' => 'integer',
		'Pictures__sale_id' => 'integer',
		'Pictures.sale_id' => 'integer',
		'sale_id' => 'integer'
	],
	'decorators' => (int) 0,
	'executed' => false,
	'hydrate' => true,
	'buffered' => true,
	'formatters' => (int) 0,
	'mapReducers' => (int) 0,
	'contain' => [
		'Locations' => [
			[maximum depth reached]
		],
		'Sales' => [
			[maximum depth reached]
		]
	],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\OfficesTable) {}

}
$generator = object(Cake\Database\ValueBinder) {
	[protected] _bindings => [
		':c0' => [
			[maximum depth reached]
		]
	]
	[protected] _bindingsCount => (int) 1
}
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 257
Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99
Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333
Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262
Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 228
Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 936
Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136
Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221
Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274
Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 190
Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 957
Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276
Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 905
Cake\ORM\Query::first() - CORE/src/Datasource/QueryTrait.php, line 404
App\Controller\OfficesController::show() - APP/Controller/OfficesController.php, line 24

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 = (int) 1
$name = 'limit'
$sql = 'SELECT Offices.id AS `Offices__id`, Offices.name AS `Offices__name`, Offices.slug AS `Offices__slug`, Offices.category AS `Offices__category`, Offices.presentation AS `Offices__presentation`, Offices.logo AS `Offices__logo`, Offices.email AS `Offices__email`, Offices.website AS `Offices__website`, Offices.active AS `Offices__active`, Offices.location_id AS `Offices__location_id`, Offices.user_id AS `Offices__user_id`, Locations.id AS `Locations__id`, Locations.adress1 AS `Locations__adress1`, Locations.adress2 AS `Locations__adress2`, Locations.city AS `Locations__city`, Locations.state AS `Locations__state`, Locations.phone1 AS `Locations__phone1`, Locations.phone2 AS `Locations__phone2`, Locations.fax AS `Locations__fax`, Locations.lng AS `Locations__lng`, Locations.lat AS `Locations__lat`, Locations.country_id AS `Locations__country_id`, Countries.id AS `Countries__id`, Countries.country_code AS `Countries__country_code`, Countries.country_name AS `Countries__country_name`, Countries.currency_code AS `Countries__currency_code` FROM offices Offices INNER JOIN locations Locations ON Locations.id = (Offices.location_id) LEFT JOIN countries Countries ON Countries.id = (Locations.country_id) WHERE Offices.id = :c0'
$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' => [
		'Offices__id' => 'integer',
		'Offices.id' => 'integer',
		'id' => 'integer',
		'Offices__name' => 'string',
		'Offices.name' => 'string',
		'name' => 'string',
		'Offices__slug' => 'string',
		'Offices.slug' => 'string',
		'slug' => 'string',
		'Offices__category' => 'string',
		'Offices.category' => 'string',
		'category' => 'string',
		'Offices__presentation' => 'text',
		'Offices.presentation' => 'text',
		'presentation' => 'text',
		'Offices__logo' => 'string',
		'Offices.logo' => 'string',
		'logo' => 'string',
		'Offices__email' => 'string',
		'Offices.email' => 'string',
		'email' => 'string',
		'Offices__website' => 'string',
		'Offices.website' => 'string',
		'website' => 'string',
		'Offices__active' => 'boolean',
		'Offices.active' => 'boolean',
		'active' => 'boolean',
		'Offices__location_id' => 'integer',
		'Offices.location_id' => 'integer',
		'location_id' => 'integer',
		'Offices__user_id' => 'integer',
		'Offices.user_id' => 'integer',
		'user_id' => 'integer',
		'Locations__id' => 'integer',
		'Locations.id' => 'integer',
		'Locations__adress1' => 'string',
		'Locations.adress1' => 'string',
		'adress1' => 'string',
		'Locations__adress2' => 'string',
		'Locations.adress2' => 'string',
		'adress2' => 'string',
		'Locations__city' => 'string',
		'Locations.city' => 'string',
		'city' => 'string',
		'Locations__state' => 'string',
		'Locations.state' => 'string',
		'state' => 'string',
		'Locations__phone1' => 'string',
		'Locations.phone1' => 'string',
		'phone1' => 'string',
		'Locations__phone2' => 'string',
		'Locations.phone2' => 'string',
		'phone2' => 'string',
		'Locations__fax' => 'string',
		'Locations.fax' => 'string',
		'fax' => 'string',
		'Locations__lng' => 'string',
		'Locations.lng' => 'string',
		'lng' => 'string',
		'Locations__lat' => 'string',
		'Locations.lat' => 'string',
		'lat' => 'string',
		'Locations__country_id' => 'integer',
		'Locations.country_id' => 'integer',
		'country_id' => 'integer',
		'Countries__id' => 'integer',
		'Countries.id' => 'integer',
		'Countries__country_code' => 'string',
		'Countries.country_code' => 'string',
		'country_code' => 'string',
		'Countries__country_name' => 'string',
		'Countries.country_name' => 'string',
		'country_name' => 'string',
		'Countries__currency_code' => 'string',
		'Countries.currency_code' => 'string',
		'currency_code' => 'string',
		'Sales__id' => 'integer',
		'Sales.id' => 'integer',
		'Sales__price' => 'integer',
		'Sales.price' => 'integer',
		'price' => 'integer',
		'Sales__usd_price' => 'integer',
		'Sales.usd_price' => 'integer',
		'usd_price' => 'integer',
		'Sales__title' => 'string',
		'Sales.title' => 'string',
		'title' => 'string',
		'Sales__slug' => 'string',
		'Sales.slug' => 'string',
		'Sales__description' => 'text',
		'Sales.description' => 'text',
		'description' => 'text',
		'Sales__year' => 'text',
		'Sales.year' => 'text',
		'year' => 'text',
		'Sales__location' => 'string',
		'Sales.location' => 'string',
		'location' => 'string',
		'Sales__adress' => 'string',
		'Sales.adress' => 'string',
		'adress' => 'string',
		'Sales__internal_reference' => 'string',
		'Sales.internal_reference' => 'string',
		'internal_reference' => 'string',
		'Sales__validate' => 'boolean',
		'Sales.validate' => 'boolean',
		'validate' => 'boolean',
		'Sales__active' => 'boolean',
		'Sales.active' => 'boolean',
		'Sales__views' => 'integer',
		'Sales.views' => 'integer',
		'views' => 'integer',
		'Sales__created' => 'datetime',
		'Sales.created' => 'datetime',
		'created' => 'datetime',
		'Sales__currency_id' => 'integer',
		'Sales.currency_id' => 'integer',
		'currency_id' => 'integer',
		'Sales__car_id' => 'integer',
		'Sales.car_id' => 'integer',
		'car_id' => 'integer',
		'Sales__real_estate_id' => 'integer',
		'Sales.real_estate_id' => 'integer',
		'real_estate_id' => 'integer',
		'Sales__watche_id' => 'integer',
		'Sales.watche_id' => 'integer',
		'watche_id' => 'integer',
		'Sales__yacht_id' => 'integer',
		'Sales.yacht_id' => 'integer',
		'yacht_id' => 'integer',
		'Sales__office_id' => 'integer',
		'Sales.office_id' => 'integer',
		'office_id' => 'integer',
		'Sales__agent_id' => 'integer',
		'Sales.agent_id' => 'integer',
		'agent_id' => 'integer',
		'Sales__user_id' => 'integer',
		'Sales.user_id' => 'integer',
		'Pictures__id' => 'integer',
		'Pictures.id' => 'integer',
		'Pictures__name' => 'string',
		'Pictures.name' => 'string',
		'Pictures__rang' => 'integer',
		'Pictures.rang' => 'integer',
		'rang' => 'integer',
		'Pictures__sale_id' => 'integer',
		'Pictures.sale_id' => 'integer',
		'sale_id' => 'integer'
	],
	'decorators' => (int) 0,
	'executed' => false,
	'hydrate' => true,
	'buffered' => true,
	'formatters' => (int) 0,
	'mapReducers' => (int) 0,
	'contain' => [
		'Locations' => [
			[maximum depth reached]
		],
		'Sales' => [
			[maximum depth reached]
		]
	],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\OfficesTable) {}

}
$generator = object(Cake\Database\ValueBinder) {
	[protected] _bindings => [
		':c0' => [
			[maximum depth reached]
		]
	]
	[protected] _bindingsCount => (int) 1
}
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 257
Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99
Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333
Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262
Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 228
Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 936
Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136
Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221
Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274
Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 190
Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 957
Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276
Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 905
Cake\ORM\Query::first() - CORE/src/Datasource/QueryTrait.php, line 404
App\Controller\OfficesController::show() - APP/Controller/OfficesController.php, line 24

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 Offices.id AS `Offices__id`, Offices.name AS `Offices__name`, Offices.slug AS `Offices__slug`, Offices.category AS `Offices__category`, Offices.presentation AS `Offices__presentation`, Offices.logo AS `Offices__logo`, Offices.email AS `Offices__email`, Offices.website AS `Offices__website`, Offices.active AS `Offices__active`, Offices.location_id AS `Offices__location_id`, Offices.user_id AS `Offices__user_id`, Locations.id AS `Locations__id`, Locations.adress1 AS `Locations__adress1`, Locations.adress2 AS `Locations__adress2`, Locations.city AS `Locations__city`, Locations.state AS `Locations__state`, Locations.phone1 AS `Locations__phone1`, Locations.phone2 AS `Locations__phone2`, Locations.fax AS `Locations__fax`, Locations.lng AS `Locations__lng`, Locations.lat AS `Locations__lat`, Locations.country_id AS `Locations__country_id`, Countries.id AS `Countries__id`, Countries.country_code AS `Countries__country_code`, Countries.country_name AS `Countries__country_name`, Countries.currency_code AS `Countries__currency_code` FROM offices Offices INNER JOIN locations Locations ON Locations.id = (Offices.location_id) LEFT JOIN countries Countries ON Countries.id = (Locations.country_id) WHERE Offices.id = :c0 LIMIT 1'
$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' => [
		'Offices__id' => 'integer',
		'Offices.id' => 'integer',
		'id' => 'integer',
		'Offices__name' => 'string',
		'Offices.name' => 'string',
		'name' => 'string',
		'Offices__slug' => 'string',
		'Offices.slug' => 'string',
		'slug' => 'string',
		'Offices__category' => 'string',
		'Offices.category' => 'string',
		'category' => 'string',
		'Offices__presentation' => 'text',
		'Offices.presentation' => 'text',
		'presentation' => 'text',
		'Offices__logo' => 'string',
		'Offices.logo' => 'string',
		'logo' => 'string',
		'Offices__email' => 'string',
		'Offices.email' => 'string',
		'email' => 'string',
		'Offices__website' => 'string',
		'Offices.website' => 'string',
		'website' => 'string',
		'Offices__active' => 'boolean',
		'Offices.active' => 'boolean',
		'active' => 'boolean',
		'Offices__location_id' => 'integer',
		'Offices.location_id' => 'integer',
		'location_id' => 'integer',
		'Offices__user_id' => 'integer',
		'Offices.user_id' => 'integer',
		'user_id' => 'integer',
		'Locations__id' => 'integer',
		'Locations.id' => 'integer',
		'Locations__adress1' => 'string',
		'Locations.adress1' => 'string',
		'adress1' => 'string',
		'Locations__adress2' => 'string',
		'Locations.adress2' => 'string',
		'adress2' => 'string',
		'Locations__city' => 'string',
		'Locations.city' => 'string',
		'city' => 'string',
		'Locations__state' => 'string',
		'Locations.state' => 'string',
		'state' => 'string',
		'Locations__phone1' => 'string',
		'Locations.phone1' => 'string',
		'phone1' => 'string',
		'Locations__phone2' => 'string',
		'Locations.phone2' => 'string',
		'phone2' => 'string',
		'Locations__fax' => 'string',
		'Locations.fax' => 'string',
		'fax' => 'string',
		'Locations__lng' => 'string',
		'Locations.lng' => 'string',
		'lng' => 'string',
		'Locations__lat' => 'string',
		'Locations.lat' => 'string',
		'lat' => 'string',
		'Locations__country_id' => 'integer',
		'Locations.country_id' => 'integer',
		'country_id' => 'integer',
		'Countries__id' => 'integer',
		'Countries.id' => 'integer',
		'Countries__country_code' => 'string',
		'Countries.country_code' => 'string',
		'country_code' => 'string',
		'Countries__country_name' => 'string',
		'Countries.country_name' => 'string',
		'country_name' => 'string',
		'Countries__currency_code' => 'string',
		'Countries.currency_code' => 'string',
		'currency_code' => 'string',
		'Sales__id' => 'integer',
		'Sales.id' => 'integer',
		'Sales__price' => 'integer',
		'Sales.price' => 'integer',
		'price' => 'integer',
		'Sales__usd_price' => 'integer',
		'Sales.usd_price' => 'integer',
		'usd_price' => 'integer',
		'Sales__title' => 'string',
		'Sales.title' => 'string',
		'title' => 'string',
		'Sales__slug' => 'string',
		'Sales.slug' => 'string',
		'Sales__description' => 'text',
		'Sales.description' => 'text',
		'description' => 'text',
		'Sales__year' => 'text',
		'Sales.year' => 'text',
		'year' => 'text',
		'Sales__location' => 'string',
		'Sales.location' => 'string',
		'location' => 'string',
		'Sales__adress' => 'string',
		'Sales.adress' => 'string',
		'adress' => 'string',
		'Sales__internal_reference' => 'string',
		'Sales.internal_reference' => 'string',
		'internal_reference' => 'string',
		'Sales__validate' => 'boolean',
		'Sales.validate' => 'boolean',
		'validate' => 'boolean',
		'Sales__active' => 'boolean',
		'Sales.active' => 'boolean',
		'Sales__views' => 'integer',
		'Sales.views' => 'integer',
		'views' => 'integer',
		'Sales__created' => 'datetime',
		'Sales.created' => 'datetime',
		'created' => 'datetime',
		'Sales__currency_id' => 'integer',
		'Sales.currency_id' => 'integer',
		'currency_id' => 'integer',
		'Sales__car_id' => 'integer',
		'Sales.car_id' => 'integer',
		'car_id' => 'integer',
		'Sales__real_estate_id' => 'integer',
		'Sales.real_estate_id' => 'integer',
		'real_estate_id' => 'integer',
		'Sales__watche_id' => 'integer',
		'Sales.watche_id' => 'integer',
		'watche_id' => 'integer',
		'Sales__yacht_id' => 'integer',
		'Sales.yacht_id' => 'integer',
		'yacht_id' => 'integer',
		'Sales__office_id' => 'integer',
		'Sales.office_id' => 'integer',
		'office_id' => 'integer',
		'Sales__agent_id' => 'integer',
		'Sales.agent_id' => 'integer',
		'agent_id' => 'integer',
		'Sales__user_id' => 'integer',
		'Sales.user_id' => 'integer',
		'Pictures__id' => 'integer',
		'Pictures.id' => 'integer',
		'Pictures__name' => 'string',
		'Pictures.name' => 'string',
		'Pictures__rang' => 'integer',
		'Pictures.rang' => 'integer',
		'rang' => 'integer',
		'Pictures__sale_id' => 'integer',
		'Pictures.sale_id' => 'integer',
		'sale_id' => 'integer'
	],
	'decorators' => (int) 0,
	'executed' => false,
	'hydrate' => true,
	'buffered' => true,
	'formatters' => (int) 0,
	'mapReducers' => (int) 0,
	'contain' => [
		'Locations' => [
			[maximum depth reached]
		],
		'Sales' => [
			[maximum depth reached]
		]
	],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\OfficesTable) {}

}
$generator = object(Cake\Database\ValueBinder) {
	[protected] _bindings => [
		':c0' => [
			[maximum depth reached]
		]
	]
	[protected] _bindingsCount => (int) 1
}
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 257
Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99
Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333
Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262
Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 228
Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 936
Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136
Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221
Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274
Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 190
Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 957
Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276
Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 905
Cake\ORM\Query::first() - CORE/src/Datasource/QueryTrait.php, line 404
App\Controller\OfficesController::show() - APP/Controller/OfficesController.php, line 24

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 Offices.id AS `Offices__id`, Offices.name AS `Offices__name`, Offices.slug AS `Offices__slug`, Offices.category AS `Offices__category`, Offices.presentation AS `Offices__presentation`, Offices.logo AS `Offices__logo`, Offices.email AS `Offices__email`, Offices.website AS `Offices__website`, Offices.active AS `Offices__active`, Offices.location_id AS `Offices__location_id`, Offices.user_id AS `Offices__user_id`, Locations.id AS `Locations__id`, Locations.adress1 AS `Locations__adress1`, Locations.adress2 AS `Locations__adress2`, Locations.city AS `Locations__city`, Locations.state AS `Locations__state`, Locations.phone1 AS `Locations__phone1`, Locations.phone2 AS `Locations__phone2`, Locations.fax AS `Locations__fax`, Locations.lng AS `Locations__lng`, Locations.lat AS `Locations__lat`, Locations.country_id AS `Locations__country_id`, Countries.id AS `Countries__id`, Countries.country_code AS `Countries__country_code`, Countries.country_name AS `Countries__country_name`, Countries.currency_code AS `Countries__currency_code` FROM offices Offices INNER JOIN locations Locations ON Locations.id = (Offices.location_id) LEFT JOIN countries Countries ON Countries.id = (Locations.country_id) WHERE Offices.id = :c0 LIMIT 1'
$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' => [
		'Offices__id' => 'integer',
		'Offices.id' => 'integer',
		'id' => 'integer',
		'Offices__name' => 'string',
		'Offices.name' => 'string',
		'name' => 'string',
		'Offices__slug' => 'string',
		'Offices.slug' => 'string',
		'slug' => 'string',
		'Offices__category' => 'string',
		'Offices.category' => 'string',
		'category' => 'string',
		'Offices__presentation' => 'text',
		'Offices.presentation' => 'text',
		'presentation' => 'text',
		'Offices__logo' => 'string',
		'Offices.logo' => 'string',
		'logo' => 'string',
		'Offices__email' => 'string',
		'Offices.email' => 'string',
		'email' => 'string',
		'Offices__website' => 'string',
		'Offices.website' => 'string',
		'website' => 'string',
		'Offices__active' => 'boolean',
		'Offices.active' => 'boolean',
		'active' => 'boolean',
		'Offices__location_id' => 'integer',
		'Offices.location_id' => 'integer',
		'location_id' => 'integer',
		'Offices__user_id' => 'integer',
		'Offices.user_id' => 'integer',
		'user_id' => 'integer',
		'Locations__id' => 'integer',
		'Locations.id' => 'integer',
		'Locations__adress1' => 'string',
		'Locations.adress1' => 'string',
		'adress1' => 'string',
		'Locations__adress2' => 'string',
		'Locations.adress2' => 'string',
		'adress2' => 'string',
		'Locations__city' => 'string',
		'Locations.city' => 'string',
		'city' => 'string',
		'Locations__state' => 'string',
		'Locations.state' => 'string',
		'state' => 'string',
		'Locations__phone1' => 'string',
		'Locations.phone1' => 'string',
		'phone1' => 'string',
		'Locations__phone2' => 'string',
		'Locations.phone2' => 'string',
		'phone2' => 'string',
		'Locations__fax' => 'string',
		'Locations.fax' => 'string',
		'fax' => 'string',
		'Locations__lng' => 'string',
		'Locations.lng' => 'string',
		'lng' => 'string',
		'Locations__lat' => 'string',
		'Locations.lat' => 'string',
		'lat' => 'string',
		'Locations__country_id' => 'integer',
		'Locations.country_id' => 'integer',
		'country_id' => 'integer',
		'Countries__id' => 'integer',
		'Countries.id' => 'integer',
		'Countries__country_code' => 'string',
		'Countries.country_code' => 'string',
		'country_code' => 'string',
		'Countries__country_name' => 'string',
		'Countries.country_name' => 'string',
		'country_name' => 'string',
		'Countries__currency_code' => 'string',
		'Countries.currency_code' => 'string',
		'currency_code' => 'string',
		'Sales__id' => 'integer',
		'Sales.id' => 'integer',
		'Sales__price' => 'integer',
		'Sales.price' => 'integer',
		'price' => 'integer',
		'Sales__usd_price' => 'integer',
		'Sales.usd_price' => 'integer',
		'usd_price' => 'integer',
		'Sales__title' => 'string',
		'Sales.title' => 'string',
		'title' => 'string',
		'Sales__slug' => 'string',
		'Sales.slug' => 'string',
		'Sales__description' => 'text',
		'Sales.description' => 'text',
		'description' => 'text',
		'Sales__year' => 'text',
		'Sales.year' => 'text',
		'year' => 'text',
		'Sales__location' => 'string',
		'Sales.location' => 'string',
		'location' => 'string',
		'Sales__adress' => 'string',
		'Sales.adress' => 'string',
		'adress' => 'string',
		'Sales__internal_reference' => 'string',
		'Sales.internal_reference' => 'string',
		'internal_reference' => 'string',
		'Sales__validate' => 'boolean',
		'Sales.validate' => 'boolean',
		'validate' => 'boolean',
		'Sales__active' => 'boolean',
		'Sales.active' => 'boolean',
		'Sales__views' => 'integer',
		'Sales.views' => 'integer',
		'views' => 'integer',
		'Sales__created' => 'datetime',
		'Sales.created' => 'datetime',
		'created' => 'datetime',
		'Sales__currency_id' => 'integer',
		'Sales.currency_id' => 'integer',
		'currency_id' => 'integer',
		'Sales__car_id' => 'integer',
		'Sales.car_id' => 'integer',
		'car_id' => 'integer',
		'Sales__real_estate_id' => 'integer',
		'Sales.real_estate_id' => 'integer',
		'real_estate_id' => 'integer',
		'Sales__watche_id' => 'integer',
		'Sales.watche_id' => 'integer',
		'watche_id' => 'integer',
		'Sales__yacht_id' => 'integer',
		'Sales.yacht_id' => 'integer',
		'yacht_id' => 'integer',
		'Sales__office_id' => 'integer',
		'Sales.office_id' => 'integer',
		'office_id' => 'integer',
		'Sales__agent_id' => 'integer',
		'Sales.agent_id' => 'integer',
		'agent_id' => 'integer',
		'Sales__user_id' => 'integer',
		'Sales.user_id' => 'integer',
		'Pictures__id' => 'integer',
		'Pictures.id' => 'integer',
		'Pictures__name' => 'string',
		'Pictures.name' => 'string',
		'Pictures__rang' => 'integer',
		'Pictures.rang' => 'integer',
		'rang' => 'integer',
		'Pictures__sale_id' => 'integer',
		'Pictures.sale_id' => 'integer',
		'sale_id' => 'integer'
	],
	'decorators' => (int) 0,
	'executed' => false,
	'hydrate' => true,
	'buffered' => true,
	'formatters' => (int) 0,
	'mapReducers' => (int) 0,
	'contain' => [
		'Locations' => [
			[maximum depth reached]
		],
		'Sales' => [
			[maximum depth reached]
		]
	],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\OfficesTable) {}

}
$generator = object(Cake\Database\ValueBinder) {
	[protected] _bindings => [
		':c0' => [
			[maximum depth reached]
		]
	]
	[protected] _bindingsCount => (int) 1
}
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 257
Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99
Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333
Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262
Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 228
Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 936
Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136
Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221
Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274
Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 190
Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 957
Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276
Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 905
Cake\ORM\Query::first() - CORE/src/Datasource/QueryTrait.php, line 404
App\Controller\OfficesController::show() - APP/Controller/OfficesController.php, line 24

Notice (8): Trying to get property 'name' of non-object [APP/Controller/OfficesController.php, line 25]
Code Context
                ->contain(['Locations' => ['Countries'], 'Sales' => ['Pictures']])
                ->first();
        $title = $office->name;
$id = 'yachts'
$page = '20'
$menuType = 'fixed'
$office = null
App\Controller\OfficesController::show() - APP/Controller/OfficesController.php, line 25
Cake\Controller\Controller::invokeAction() - CORE/src/Controller/Controller.php, line 435
Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 121
Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 95
Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 83
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Routing\Middleware\RoutingMiddleware::__invoke() - CORE/src/Routing/Middleware/RoutingMiddleware.php, line 62
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Routing\Middleware\AssetMiddleware::__invoke() - CORE/src/Routing/Middleware/AssetMiddleware.php, line 88
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Error\Middleware\ErrorHandlerMiddleware::__invoke() - CORE/src/Error/Middleware/ErrorHandlerMiddleware.php, line 81
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Http\Runner::run() - CORE/src/Http/Runner.php, line 51
Cake\Http\Server::run() - CORE/src/Http/Server.php, line 90
[main] - ROOT/webroot/index.php, line 37

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 Sales.id AS `Sales__id`, Sales.price AS `Sales__price`, Sales.usd_price AS `Sales__usd_price`, Sales.title AS `Sales__title`, Sales.slug AS `Sales__slug`, Sales.description AS `Sales__description`, Sales.year AS `Sales__year`, Sales.location AS `Sales__location`, Sales.adress AS `Sales__adress`, Sales.internal_reference AS `Sales__internal_reference`, Sales.validate AS `Sales__validate`, Sales.active AS `Sales__active`, Sales.views AS `Sales__views`, Sales.created AS `Sales__created`, Sales.currency_id AS `Sales__currency_id`, Sales.car_id AS `Sales__car_id`, Sales.real_estate_id AS `Sales__real_estate_id`, Sales.watche_id AS `Sales__watche_id`, Sales.yacht_id AS `Sales__yacht_id`, Sales.office_id AS `Sales__office_id`, Sales.agent_id AS `Sales__agent_id`, Sales.user_id AS `Sales__user_id`, Users.id AS `Users__id`, Users.email AS `Users__email`, Users.password AS `Users__password`, Users.name AS `Users__name`, Users.firstname AS `Users__firstname`, Users.subscription_date AS `Users__subscription_date`, Users.active AS `Users__active`, Users.created AS `Users__created`, Users.type AS `Users__type`, Users.location_id AS `Users__location_id`, Cars.id AS `Cars__id`, Cars.brand_name AS `Cars__brand_name`, Cars.model_name AS `Cars__model_name`, Cars.gamme AS `Cars__gamme`, Cars.model_trim AS `Cars__model_trim`, Cars.mileage AS `Cars__mileage`, Cars.gearbox AS `Cars__gearbox`, Cars.fuel_type AS `Cars__fuel_type`, Cars.color AS `Cars__color`, Cars.car_type AS `Cars__car_type`, Cars.interior_color AS `Cars__interior_color`, Cars.vin AS `Cars__vin`, Cars.conditions AS `Cars__conditions`, RealEstates.id AS `RealEstates__id`, RealEstates.property_type AS `RealEstates__property_type`, RealEstates.bedrooms AS `RealEstates__bedrooms`, RealEstates.bathrooms AS `RealEstates__bathrooms`, RealEstates.living_area AS `RealEstates__living_area`, RealEstates.land_area AS `RealEstates__land_area`, RealEstates.floors AS `RealEstates__floors`, RealEstates.guests AS `RealEstates__guests`, Watches.id AS `Watches__id`, Watches.brand_name AS `Watches__brand_name`, Watches.gender AS `Watches__gender`, Watches.case_material AS `Watches__case_material`, Watches.strap_material AS `Watches__strap_material`, Watches.movement AS `Watches__movement`, Watches.conditions AS `Watches__conditions`, Offices.id AS `Offices__id`, Offices.name AS `Offices__name`, Offices.slug AS `Offices__slug`, Offices.category AS `Offices__category`, Offices.presentation AS `Offices__presentation`, Offices.logo AS `Offices__logo`, Offices.email AS `Offices__email`, Offices.website AS `Offices__website`, Offices.active AS `Offices__active`, Offices.location_id AS `Offices__location_id`, Offices.user_id AS `Offices__user_id` FROM sales Sales INNER JOIN users Users ON Users.id = (Sales.user_id) LEFT JOIN cars Cars ON Cars.id = (Sales.car_id) LEFT JOIN real_estates RealEstates ON RealEstates.id = (Sales.real_estate_id) LEFT JOIN watches Watches ON Watches.id = (Sales.watche_id) LEFT JOIN offices Offices ON Offices.id = (Sales.office_id) WHERE (Sales.active = :c0 AND Sales.validate = :c1 AND Sales.office_id = :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' => [
		'Sales__id' => 'integer',
		'Sales.id' => 'integer',
		'id' => 'integer',
		'Sales__price' => 'integer',
		'Sales.price' => 'integer',
		'price' => 'integer',
		'Sales__usd_price' => 'integer',
		'Sales.usd_price' => 'integer',
		'usd_price' => 'integer',
		'Sales__title' => 'string',
		'Sales.title' => 'string',
		'title' => 'string',
		'Sales__slug' => 'string',
		'Sales.slug' => 'string',
		'slug' => 'string',
		'Sales__description' => 'text',
		'Sales.description' => 'text',
		'description' => 'text',
		'Sales__year' => 'text',
		'Sales.year' => 'text',
		'year' => 'text',
		'Sales__location' => 'string',
		'Sales.location' => 'string',
		'location' => 'string',
		'Sales__adress' => 'string',
		'Sales.adress' => 'string',
		'adress' => 'string',
		'Sales__internal_reference' => 'string',
		'Sales.internal_reference' => 'string',
		'internal_reference' => 'string',
		'Sales__validate' => 'boolean',
		'Sales.validate' => 'boolean',
		'validate' => 'boolean',
		'Sales__active' => 'boolean',
		'Sales.active' => 'boolean',
		'active' => 'boolean',
		'Sales__views' => 'integer',
		'Sales.views' => 'integer',
		'views' => 'integer',
		'Sales__created' => 'datetime',
		'Sales.created' => 'datetime',
		'created' => 'datetime',
		'Sales__currency_id' => 'integer',
		'Sales.currency_id' => 'integer',
		'currency_id' => 'integer',
		'Sales__car_id' => 'integer',
		'Sales.car_id' => 'integer',
		'car_id' => 'integer',
		'Sales__real_estate_id' => 'integer',
		'Sales.real_estate_id' => 'integer',
		'real_estate_id' => 'integer',
		'Sales__watche_id' => 'integer',
		'Sales.watche_id' => 'integer',
		'watche_id' => 'integer',
		'Sales__yacht_id' => 'integer',
		'Sales.yacht_id' => 'integer',
		'yacht_id' => 'integer',
		'Sales__office_id' => 'integer',
		'Sales.office_id' => 'integer',
		'office_id' => 'integer',
		'Sales__agent_id' => 'integer',
		'Sales.agent_id' => 'integer',
		'agent_id' => 'integer',
		'Sales__user_id' => 'integer',
		'Sales.user_id' => 'integer',
		'user_id' => 'integer',
		'Users__id' => 'integer',
		'Users.id' => 'integer',
		'Users__email' => 'string',
		'Users.email' => 'string',
		'email' => 'string',
		'Users__password' => 'string',
		'Users.password' => 'string',
		'password' => 'string',
		'Users__name' => 'string',
		'Users.name' => 'string',
		'name' => 'string',
		'Users__firstname' => 'string',
		'Users.firstname' => 'string',
		'firstname' => 'string',
		'Users__subscription_date' => 'date',
		'Users.subscription_date' => 'date',
		'subscription_date' => 'date',
		'Users__active' => 'boolean',
		'Users.active' => 'boolean',
		'Users__created' => 'datetime',
		'Users.created' => 'datetime',
		'Users__type' => 'string',
		'Users.type' => 'string',
		'type' => 'string',
		'Users__location_id' => 'integer',
		'Users.location_id' => 'integer',
		'location_id' => 'integer',
		'Cars__id' => 'integer',
		'Cars.id' => 'integer',
		'Cars__brand_name' => 'string',
		'Cars.brand_name' => 'string',
		'brand_name' => 'string',
		'Cars__model_name' => 'string',
		'Cars.model_name' => 'string',
		'model_name' => 'string',
		'Cars__gamme' => 'string',
		'Cars.gamme' => 'string',
		'gamme' => 'string',
		'Cars__model_trim' => 'string',
		'Cars.model_trim' => 'string',
		'model_trim' => 'string',
		'Cars__mileage' => 'string',
		'Cars.mileage' => 'string',
		'mileage' => 'string',
		'Cars__gearbox' => 'string',
		'Cars.gearbox' => 'string',
		'gearbox' => 'string',
		'Cars__fuel_type' => 'string',
		'Cars.fuel_type' => 'string',
		'fuel_type' => 'string',
		'Cars__color' => 'string',
		'Cars.color' => 'string',
		'color' => 'string',
		'Cars__car_type' => 'string',
		'Cars.car_type' => 'string',
		'car_type' => 'string',
		'Cars__interior_color' => 'string',
		'Cars.interior_color' => 'string',
		'interior_color' => 'string',
		'Cars__vin' => 'string',
		'Cars.vin' => 'string',
		'vin' => 'string',
		'Cars__conditions' => 'string',
		'Cars.conditions' => 'string',
		'conditions' => 'string',
		'RealEstates__id' => 'integer',
		'RealEstates.id' => 'integer',
		'RealEstates__property_type' => 'string',
		'RealEstates.property_type' => 'string',
		'property_type' => 'string',
		'RealEstates__bedrooms' => 'integer',
		'RealEstates.bedrooms' => 'integer',
		'bedrooms' => 'integer',
		'RealEstates__bathrooms' => 'integer',
		'RealEstates.bathrooms' => 'integer',
		'bathrooms' => 'integer',
		'RealEstates__living_area' => 'string',
		'RealEstates.living_area' => 'string',
		'living_area' => 'string',
		'RealEstates__land_area' => 'string',
		'RealEstates.land_area' => 'string',
		'land_area' => 'string',
		'RealEstates__floors' => 'integer',
		'RealEstates.floors' => 'integer',
		'floors' => 'integer',
		'RealEstates__guests' => 'integer',
		'RealEstates.guests' => 'integer',
		'guests' => 'integer',
		'Watches__id' => 'integer',
		'Watches.id' => 'integer',
		'Watches__brand_name' => 'string',
		'Watches.brand_name' => 'string',
		'Watches__gender' => 'string',
		'Watches.gender' => 'string',
		'gender' => 'string',
		'Watches__case_material' => 'string',
		'Watches.case_material' => 'string',
		'case_material' => 'string',
		'Watches__strap_material' => 'string',
		'Watches.strap_material' => 'string',
		'strap_material' => 'string',
		'Watches__movement' => 'string',
		'Watches.movement' => 'string',
		'movement' => 'string',
		'Watches__conditions' => 'string',
		'Watches.conditions' => 'string',
		'Pictures__id' => 'integer',
		'Pictures.id' => 'integer',
		'Pictures__name' => 'string',
		'Pictures.name' => 'string',
		'Pictures__rang' => 'integer',
		'Pictures.rang' => 'integer',
		'rang' => 'integer',
		'Pictures__sale_id' => 'integer',
		'Pictures.sale_id' => 'integer',
		'sale_id' => 'integer',
		'Offices__id' => 'integer',
		'Offices.id' => 'integer',
		'Offices__name' => 'string',
		'Offices.name' => 'string',
		'Offices__slug' => 'string',
		'Offices.slug' => 'string',
		'Offices__category' => 'string',
		'Offices.category' => 'string',
		'category' => 'string',
		'Offices__presentation' => 'text',
		'Offices.presentation' => 'text',
		'presentation' => 'text',
		'Offices__logo' => 'string',
		'Offices.logo' => 'string',
		'logo' => 'string',
		'Offices__email' => 'string',
		'Offices.email' => 'string',
		'Offices__website' => 'string',
		'Offices.website' => 'string',
		'website' => 'string',
		'Offices__active' => 'boolean',
		'Offices.active' => 'boolean',
		'Offices__location_id' => 'integer',
		'Offices.location_id' => 'integer',
		'Offices__user_id' => 'integer',
		'Offices.user_id' => 'integer'
	],
	'decorators' => (int) 0,
	'executed' => false,
	'hydrate' => true,
	'buffered' => true,
	'formatters' => (int) 0,
	'mapReducers' => (int) 0,
	'contain' => [
		'Users' => [[maximum depth reached]],
		'Cars' => [[maximum depth reached]],
		'RealEstates' => [[maximum depth reached]],
		'Watches' => [[maximum depth reached]],
		'Pictures' => [
			[maximum depth reached]
		],
		'Offices' => [[maximum depth reached]]
	],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\SalesTable) {}

}
$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 257
Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99
Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333
Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262
Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 228
Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 936
Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136
Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221
Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274
Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 190
Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 957
Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276
Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 905
App\Model\Table\SalesTable::lists() - APP/Model/Table/SalesTable.php, line 178
App\Controller\OfficesController::show() - APP/Controller/OfficesController.php, line 32

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 = (int) 9
$name = 'limit'
$sql = 'SELECT Sales.id AS `Sales__id`, Sales.price AS `Sales__price`, Sales.usd_price AS `Sales__usd_price`, Sales.title AS `Sales__title`, Sales.slug AS `Sales__slug`, Sales.description AS `Sales__description`, Sales.year AS `Sales__year`, Sales.location AS `Sales__location`, Sales.adress AS `Sales__adress`, Sales.internal_reference AS `Sales__internal_reference`, Sales.validate AS `Sales__validate`, Sales.active AS `Sales__active`, Sales.views AS `Sales__views`, Sales.created AS `Sales__created`, Sales.currency_id AS `Sales__currency_id`, Sales.car_id AS `Sales__car_id`, Sales.real_estate_id AS `Sales__real_estate_id`, Sales.watche_id AS `Sales__watche_id`, Sales.yacht_id AS `Sales__yacht_id`, Sales.office_id AS `Sales__office_id`, Sales.agent_id AS `Sales__agent_id`, Sales.user_id AS `Sales__user_id`, Users.id AS `Users__id`, Users.email AS `Users__email`, Users.password AS `Users__password`, Users.name AS `Users__name`, Users.firstname AS `Users__firstname`, Users.subscription_date AS `Users__subscription_date`, Users.active AS `Users__active`, Users.created AS `Users__created`, Users.type AS `Users__type`, Users.location_id AS `Users__location_id`, Cars.id AS `Cars__id`, Cars.brand_name AS `Cars__brand_name`, Cars.model_name AS `Cars__model_name`, Cars.gamme AS `Cars__gamme`, Cars.model_trim AS `Cars__model_trim`, Cars.mileage AS `Cars__mileage`, Cars.gearbox AS `Cars__gearbox`, Cars.fuel_type AS `Cars__fuel_type`, Cars.color AS `Cars__color`, Cars.car_type AS `Cars__car_type`, Cars.interior_color AS `Cars__interior_color`, Cars.vin AS `Cars__vin`, Cars.conditions AS `Cars__conditions`, RealEstates.id AS `RealEstates__id`, RealEstates.property_type AS `RealEstates__property_type`, RealEstates.bedrooms AS `RealEstates__bedrooms`, RealEstates.bathrooms AS `RealEstates__bathrooms`, RealEstates.living_area AS `RealEstates__living_area`, RealEstates.land_area AS `RealEstates__land_area`, RealEstates.floors AS `RealEstates__floors`, RealEstates.guests AS `RealEstates__guests`, Watches.id AS `Watches__id`, Watches.brand_name AS `Watches__brand_name`, Watches.gender AS `Watches__gender`, Watches.case_material AS `Watches__case_material`, Watches.strap_material AS `Watches__strap_material`, Watches.movement AS `Watches__movement`, Watches.conditions AS `Watches__conditions`, Offices.id AS `Offices__id`, Offices.name AS `Offices__name`, Offices.slug AS `Offices__slug`, Offices.category AS `Offices__category`, Offices.presentation AS `Offices__presentation`, Offices.logo AS `Offices__logo`, Offices.email AS `Offices__email`, Offices.website AS `Offices__website`, Offices.active AS `Offices__active`, Offices.location_id AS `Offices__location_id`, Offices.user_id AS `Offices__user_id` FROM sales Sales INNER JOIN users Users ON Users.id = (Sales.user_id) LEFT JOIN cars Cars ON Cars.id = (Sales.car_id) LEFT JOIN real_estates RealEstates ON RealEstates.id = (Sales.real_estate_id) LEFT JOIN watches Watches ON Watches.id = (Sales.watche_id) LEFT JOIN offices Offices ON Offices.id = (Sales.office_id) WHERE (Sales.active = :c0 AND Sales.validate = :c1 AND Sales.office_id = :c2) ORDER BY Sales.created 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' => [
		'Sales__id' => 'integer',
		'Sales.id' => 'integer',
		'id' => 'integer',
		'Sales__price' => 'integer',
		'Sales.price' => 'integer',
		'price' => 'integer',
		'Sales__usd_price' => 'integer',
		'Sales.usd_price' => 'integer',
		'usd_price' => 'integer',
		'Sales__title' => 'string',
		'Sales.title' => 'string',
		'title' => 'string',
		'Sales__slug' => 'string',
		'Sales.slug' => 'string',
		'slug' => 'string',
		'Sales__description' => 'text',
		'Sales.description' => 'text',
		'description' => 'text',
		'Sales__year' => 'text',
		'Sales.year' => 'text',
		'year' => 'text',
		'Sales__location' => 'string',
		'Sales.location' => 'string',
		'location' => 'string',
		'Sales__adress' => 'string',
		'Sales.adress' => 'string',
		'adress' => 'string',
		'Sales__internal_reference' => 'string',
		'Sales.internal_reference' => 'string',
		'internal_reference' => 'string',
		'Sales__validate' => 'boolean',
		'Sales.validate' => 'boolean',
		'validate' => 'boolean',
		'Sales__active' => 'boolean',
		'Sales.active' => 'boolean',
		'active' => 'boolean',
		'Sales__views' => 'integer',
		'Sales.views' => 'integer',
		'views' => 'integer',
		'Sales__created' => 'datetime',
		'Sales.created' => 'datetime',
		'created' => 'datetime',
		'Sales__currency_id' => 'integer',
		'Sales.currency_id' => 'integer',
		'currency_id' => 'integer',
		'Sales__car_id' => 'integer',
		'Sales.car_id' => 'integer',
		'car_id' => 'integer',
		'Sales__real_estate_id' => 'integer',
		'Sales.real_estate_id' => 'integer',
		'real_estate_id' => 'integer',
		'Sales__watche_id' => 'integer',
		'Sales.watche_id' => 'integer',
		'watche_id' => 'integer',
		'Sales__yacht_id' => 'integer',
		'Sales.yacht_id' => 'integer',
		'yacht_id' => 'integer',
		'Sales__office_id' => 'integer',
		'Sales.office_id' => 'integer',
		'office_id' => 'integer',
		'Sales__agent_id' => 'integer',
		'Sales.agent_id' => 'integer',
		'agent_id' => 'integer',
		'Sales__user_id' => 'integer',
		'Sales.user_id' => 'integer',
		'user_id' => 'integer',
		'Users__id' => 'integer',
		'Users.id' => 'integer',
		'Users__email' => 'string',
		'Users.email' => 'string',
		'email' => 'string',
		'Users__password' => 'string',
		'Users.password' => 'string',
		'password' => 'string',
		'Users__name' => 'string',
		'Users.name' => 'string',
		'name' => 'string',
		'Users__firstname' => 'string',
		'Users.firstname' => 'string',
		'firstname' => 'string',
		'Users__subscription_date' => 'date',
		'Users.subscription_date' => 'date',
		'subscription_date' => 'date',
		'Users__active' => 'boolean',
		'Users.active' => 'boolean',
		'Users__created' => 'datetime',
		'Users.created' => 'datetime',
		'Users__type' => 'string',
		'Users.type' => 'string',
		'type' => 'string',
		'Users__location_id' => 'integer',
		'Users.location_id' => 'integer',
		'location_id' => 'integer',
		'Cars__id' => 'integer',
		'Cars.id' => 'integer',
		'Cars__brand_name' => 'string',
		'Cars.brand_name' => 'string',
		'brand_name' => 'string',
		'Cars__model_name' => 'string',
		'Cars.model_name' => 'string',
		'model_name' => 'string',
		'Cars__gamme' => 'string',
		'Cars.gamme' => 'string',
		'gamme' => 'string',
		'Cars__model_trim' => 'string',
		'Cars.model_trim' => 'string',
		'model_trim' => 'string',
		'Cars__mileage' => 'string',
		'Cars.mileage' => 'string',
		'mileage' => 'string',
		'Cars__gearbox' => 'string',
		'Cars.gearbox' => 'string',
		'gearbox' => 'string',
		'Cars__fuel_type' => 'string',
		'Cars.fuel_type' => 'string',
		'fuel_type' => 'string',
		'Cars__color' => 'string',
		'Cars.color' => 'string',
		'color' => 'string',
		'Cars__car_type' => 'string',
		'Cars.car_type' => 'string',
		'car_type' => 'string',
		'Cars__interior_color' => 'string',
		'Cars.interior_color' => 'string',
		'interior_color' => 'string',
		'Cars__vin' => 'string',
		'Cars.vin' => 'string',
		'vin' => 'string',
		'Cars__conditions' => 'string',
		'Cars.conditions' => 'string',
		'conditions' => 'string',
		'RealEstates__id' => 'integer',
		'RealEstates.id' => 'integer',
		'RealEstates__property_type' => 'string',
		'RealEstates.property_type' => 'string',
		'property_type' => 'string',
		'RealEstates__bedrooms' => 'integer',
		'RealEstates.bedrooms' => 'integer',
		'bedrooms' => 'integer',
		'RealEstates__bathrooms' => 'integer',
		'RealEstates.bathrooms' => 'integer',
		'bathrooms' => 'integer',
		'RealEstates__living_area' => 'string',
		'RealEstates.living_area' => 'string',
		'living_area' => 'string',
		'RealEstates__land_area' => 'string',
		'RealEstates.land_area' => 'string',
		'land_area' => 'string',
		'RealEstates__floors' => 'integer',
		'RealEstates.floors' => 'integer',
		'floors' => 'integer',
		'RealEstates__guests' => 'integer',
		'RealEstates.guests' => 'integer',
		'guests' => 'integer',
		'Watches__id' => 'integer',
		'Watches.id' => 'integer',
		'Watches__brand_name' => 'string',
		'Watches.brand_name' => 'string',
		'Watches__gender' => 'string',
		'Watches.gender' => 'string',
		'gender' => 'string',
		'Watches__case_material' => 'string',
		'Watches.case_material' => 'string',
		'case_material' => 'string',
		'Watches__strap_material' => 'string',
		'Watches.strap_material' => 'string',
		'strap_material' => 'string',
		'Watches__movement' => 'string',
		'Watches.movement' => 'string',
		'movement' => 'string',
		'Watches__conditions' => 'string',
		'Watches.conditions' => 'string',
		'Pictures__id' => 'integer',
		'Pictures.id' => 'integer',
		'Pictures__name' => 'string',
		'Pictures.name' => 'string',
		'Pictures__rang' => 'integer',
		'Pictures.rang' => 'integer',
		'rang' => 'integer',
		'Pictures__sale_id' => 'integer',
		'Pictures.sale_id' => 'integer',
		'sale_id' => 'integer',
		'Offices__id' => 'integer',
		'Offices.id' => 'integer',
		'Offices__name' => 'string',
		'Offices.name' => 'string',
		'Offices__slug' => 'string',
		'Offices.slug' => 'string',
		'Offices__category' => 'string',
		'Offices.category' => 'string',
		'category' => 'string',
		'Offices__presentation' => 'text',
		'Offices.presentation' => 'text',
		'presentation' => 'text',
		'Offices__logo' => 'string',
		'Offices.logo' => 'string',
		'logo' => 'string',
		'Offices__email' => 'string',
		'Offices.email' => 'string',
		'Offices__website' => 'string',
		'Offices.website' => 'string',
		'website' => 'string',
		'Offices__active' => 'boolean',
		'Offices.active' => 'boolean',
		'Offices__location_id' => 'integer',
		'Offices.location_id' => 'integer',
		'Offices__user_id' => 'integer',
		'Offices.user_id' => 'integer'
	],
	'decorators' => (int) 0,
	'executed' => false,
	'hydrate' => true,
	'buffered' => true,
	'formatters' => (int) 0,
	'mapReducers' => (int) 0,
	'contain' => [
		'Users' => [[maximum depth reached]],
		'Cars' => [[maximum depth reached]],
		'RealEstates' => [[maximum depth reached]],
		'Watches' => [[maximum depth reached]],
		'Pictures' => [
			[maximum depth reached]
		],
		'Offices' => [[maximum depth reached]]
	],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\SalesTable) {}

}
$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 257
Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99
Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333
Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262
Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 228
Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 936
Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136
Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221
Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274
Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 190
Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 957
Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276
Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 905
App\Model\Table\SalesTable::lists() - APP/Model/Table/SalesTable.php, line 178
App\Controller\OfficesController::show() - APP/Controller/OfficesController.php, line 32

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 = (int) 171
$name = 'offset'
$sql = 'SELECT Sales.id AS `Sales__id`, Sales.price AS `Sales__price`, Sales.usd_price AS `Sales__usd_price`, Sales.title AS `Sales__title`, Sales.slug AS `Sales__slug`, Sales.description AS `Sales__description`, Sales.year AS `Sales__year`, Sales.location AS `Sales__location`, Sales.adress AS `Sales__adress`, Sales.internal_reference AS `Sales__internal_reference`, Sales.validate AS `Sales__validate`, Sales.active AS `Sales__active`, Sales.views AS `Sales__views`, Sales.created AS `Sales__created`, Sales.currency_id AS `Sales__currency_id`, Sales.car_id AS `Sales__car_id`, Sales.real_estate_id AS `Sales__real_estate_id`, Sales.watche_id AS `Sales__watche_id`, Sales.yacht_id AS `Sales__yacht_id`, Sales.office_id AS `Sales__office_id`, Sales.agent_id AS `Sales__agent_id`, Sales.user_id AS `Sales__user_id`, Users.id AS `Users__id`, Users.email AS `Users__email`, Users.password AS `Users__password`, Users.name AS `Users__name`, Users.firstname AS `Users__firstname`, Users.subscription_date AS `Users__subscription_date`, Users.active AS `Users__active`, Users.created AS `Users__created`, Users.type AS `Users__type`, Users.location_id AS `Users__location_id`, Cars.id AS `Cars__id`, Cars.brand_name AS `Cars__brand_name`, Cars.model_name AS `Cars__model_name`, Cars.gamme AS `Cars__gamme`, Cars.model_trim AS `Cars__model_trim`, Cars.mileage AS `Cars__mileage`, Cars.gearbox AS `Cars__gearbox`, Cars.fuel_type AS `Cars__fuel_type`, Cars.color AS `Cars__color`, Cars.car_type AS `Cars__car_type`, Cars.interior_color AS `Cars__interior_color`, Cars.vin AS `Cars__vin`, Cars.conditions AS `Cars__conditions`, RealEstates.id AS `RealEstates__id`, RealEstates.property_type AS `RealEstates__property_type`, RealEstates.bedrooms AS `RealEstates__bedrooms`, RealEstates.bathrooms AS `RealEstates__bathrooms`, RealEstates.living_area AS `RealEstates__living_area`, RealEstates.land_area AS `RealEstates__land_area`, RealEstates.floors AS `RealEstates__floors`, RealEstates.guests AS `RealEstates__guests`, Watches.id AS `Watches__id`, Watches.brand_name AS `Watches__brand_name`, Watches.gender AS `Watches__gender`, Watches.case_material AS `Watches__case_material`, Watches.strap_material AS `Watches__strap_material`, Watches.movement AS `Watches__movement`, Watches.conditions AS `Watches__conditions`, Offices.id AS `Offices__id`, Offices.name AS `Offices__name`, Offices.slug AS `Offices__slug`, Offices.category AS `Offices__category`, Offices.presentation AS `Offices__presentation`, Offices.logo AS `Offices__logo`, Offices.email AS `Offices__email`, Offices.website AS `Offices__website`, Offices.active AS `Offices__active`, Offices.location_id AS `Offices__location_id`, Offices.user_id AS `Offices__user_id` FROM sales Sales INNER JOIN users Users ON Users.id = (Sales.user_id) LEFT JOIN cars Cars ON Cars.id = (Sales.car_id) LEFT JOIN real_estates RealEstates ON RealEstates.id = (Sales.real_estate_id) LEFT JOIN watches Watches ON Watches.id = (Sales.watche_id) LEFT JOIN offices Offices ON Offices.id = (Sales.office_id) WHERE (Sales.active = :c0 AND Sales.validate = :c1 AND Sales.office_id = :c2) ORDER BY Sales.created desc LIMIT 9'
$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' => [
		'Sales__id' => 'integer',
		'Sales.id' => 'integer',
		'id' => 'integer',
		'Sales__price' => 'integer',
		'Sales.price' => 'integer',
		'price' => 'integer',
		'Sales__usd_price' => 'integer',
		'Sales.usd_price' => 'integer',
		'usd_price' => 'integer',
		'Sales__title' => 'string',
		'Sales.title' => 'string',
		'title' => 'string',
		'Sales__slug' => 'string',
		'Sales.slug' => 'string',
		'slug' => 'string',
		'Sales__description' => 'text',
		'Sales.description' => 'text',
		'description' => 'text',
		'Sales__year' => 'text',
		'Sales.year' => 'text',
		'year' => 'text',
		'Sales__location' => 'string',
		'Sales.location' => 'string',
		'location' => 'string',
		'Sales__adress' => 'string',
		'Sales.adress' => 'string',
		'adress' => 'string',
		'Sales__internal_reference' => 'string',
		'Sales.internal_reference' => 'string',
		'internal_reference' => 'string',
		'Sales__validate' => 'boolean',
		'Sales.validate' => 'boolean',
		'validate' => 'boolean',
		'Sales__active' => 'boolean',
		'Sales.active' => 'boolean',
		'active' => 'boolean',
		'Sales__views' => 'integer',
		'Sales.views' => 'integer',
		'views' => 'integer',
		'Sales__created' => 'datetime',
		'Sales.created' => 'datetime',
		'created' => 'datetime',
		'Sales__currency_id' => 'integer',
		'Sales.currency_id' => 'integer',
		'currency_id' => 'integer',
		'Sales__car_id' => 'integer',
		'Sales.car_id' => 'integer',
		'car_id' => 'integer',
		'Sales__real_estate_id' => 'integer',
		'Sales.real_estate_id' => 'integer',
		'real_estate_id' => 'integer',
		'Sales__watche_id' => 'integer',
		'Sales.watche_id' => 'integer',
		'watche_id' => 'integer',
		'Sales__yacht_id' => 'integer',
		'Sales.yacht_id' => 'integer',
		'yacht_id' => 'integer',
		'Sales__office_id' => 'integer',
		'Sales.office_id' => 'integer',
		'office_id' => 'integer',
		'Sales__agent_id' => 'integer',
		'Sales.agent_id' => 'integer',
		'agent_id' => 'integer',
		'Sales__user_id' => 'integer',
		'Sales.user_id' => 'integer',
		'user_id' => 'integer',
		'Users__id' => 'integer',
		'Users.id' => 'integer',
		'Users__email' => 'string',
		'Users.email' => 'string',
		'email' => 'string',
		'Users__password' => 'string',
		'Users.password' => 'string',
		'password' => 'string',
		'Users__name' => 'string',
		'Users.name' => 'string',
		'name' => 'string',
		'Users__firstname' => 'string',
		'Users.firstname' => 'string',
		'firstname' => 'string',
		'Users__subscription_date' => 'date',
		'Users.subscription_date' => 'date',
		'subscription_date' => 'date',
		'Users__active' => 'boolean',
		'Users.active' => 'boolean',
		'Users__created' => 'datetime',
		'Users.created' => 'datetime',
		'Users__type' => 'string',
		'Users.type' => 'string',
		'type' => 'string',
		'Users__location_id' => 'integer',
		'Users.location_id' => 'integer',
		'location_id' => 'integer',
		'Cars__id' => 'integer',
		'Cars.id' => 'integer',
		'Cars__brand_name' => 'string',
		'Cars.brand_name' => 'string',
		'brand_name' => 'string',
		'Cars__model_name' => 'string',
		'Cars.model_name' => 'string',
		'model_name' => 'string',
		'Cars__gamme' => 'string',
		'Cars.gamme' => 'string',
		'gamme' => 'string',
		'Cars__model_trim' => 'string',
		'Cars.model_trim' => 'string',
		'model_trim' => 'string',
		'Cars__mileage' => 'string',
		'Cars.mileage' => 'string',
		'mileage' => 'string',
		'Cars__gearbox' => 'string',
		'Cars.gearbox' => 'string',
		'gearbox' => 'string',
		'Cars__fuel_type' => 'string',
		'Cars.fuel_type' => 'string',
		'fuel_type' => 'string',
		'Cars__color' => 'string',
		'Cars.color' => 'string',
		'color' => 'string',
		'Cars__car_type' => 'string',
		'Cars.car_type' => 'string',
		'car_type' => 'string',
		'Cars__interior_color' => 'string',
		'Cars.interior_color' => 'string',
		'interior_color' => 'string',
		'Cars__vin' => 'string',
		'Cars.vin' => 'string',
		'vin' => 'string',
		'Cars__conditions' => 'string',
		'Cars.conditions' => 'string',
		'conditions' => 'string',
		'RealEstates__id' => 'integer',
		'RealEstates.id' => 'integer',
		'RealEstates__property_type' => 'string',
		'RealEstates.property_type' => 'string',
		'property_type' => 'string',
		'RealEstates__bedrooms' => 'integer',
		'RealEstates.bedrooms' => 'integer',
		'bedrooms' => 'integer',
		'RealEstates__bathrooms' => 'integer',
		'RealEstates.bathrooms' => 'integer',
		'bathrooms' => 'integer',
		'RealEstates__living_area' => 'string',
		'RealEstates.living_area' => 'string',
		'living_area' => 'string',
		'RealEstates__land_area' => 'string',
		'RealEstates.land_area' => 'string',
		'land_area' => 'string',
		'RealEstates__floors' => 'integer',
		'RealEstates.floors' => 'integer',
		'floors' => 'integer',
		'RealEstates__guests' => 'integer',
		'RealEstates.guests' => 'integer',
		'guests' => 'integer',
		'Watches__id' => 'integer',
		'Watches.id' => 'integer',
		'Watches__brand_name' => 'string',
		'Watches.brand_name' => 'string',
		'Watches__gender' => 'string',
		'Watches.gender' => 'string',
		'gender' => 'string',
		'Watches__case_material' => 'string',
		'Watches.case_material' => 'string',
		'case_material' => 'string',
		'Watches__strap_material' => 'string',
		'Watches.strap_material' => 'string',
		'strap_material' => 'string',
		'Watches__movement' => 'string',
		'Watches.movement' => 'string',
		'movement' => 'string',
		'Watches__conditions' => 'string',
		'Watches.conditions' => 'string',
		'Pictures__id' => 'integer',
		'Pictures.id' => 'integer',
		'Pictures__name' => 'string',
		'Pictures.name' => 'string',
		'Pictures__rang' => 'integer',
		'Pictures.rang' => 'integer',
		'rang' => 'integer',
		'Pictures__sale_id' => 'integer',
		'Pictures.sale_id' => 'integer',
		'sale_id' => 'integer',
		'Offices__id' => 'integer',
		'Offices.id' => 'integer',
		'Offices__name' => 'string',
		'Offices.name' => 'string',
		'Offices__slug' => 'string',
		'Offices.slug' => 'string',
		'Offices__category' => 'string',
		'Offices.category' => 'string',
		'category' => 'string',
		'Offices__presentation' => 'text',
		'Offices.presentation' => 'text',
		'presentation' => 'text',
		'Offices__logo' => 'string',
		'Offices.logo' => 'string',
		'logo' => 'string',
		'Offices__email' => 'string',
		'Offices.email' => 'string',
		'Offices__website' => 'string',
		'Offices.website' => 'string',
		'website' => 'string',
		'Offices__active' => 'boolean',
		'Offices.active' => 'boolean',
		'Offices__location_id' => 'integer',
		'Offices.location_id' => 'integer',
		'Offices__user_id' => 'integer',
		'Offices.user_id' => 'integer'
	],
	'decorators' => (int) 0,
	'executed' => false,
	'hydrate' => true,
	'buffered' => true,
	'formatters' => (int) 0,
	'mapReducers' => (int) 0,
	'contain' => [
		'Users' => [[maximum depth reached]],
		'Cars' => [[maximum depth reached]],
		'RealEstates' => [[maximum depth reached]],
		'Watches' => [[maximum depth reached]],
		'Pictures' => [
			[maximum depth reached]
		],
		'Offices' => [[maximum depth reached]]
	],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\SalesTable) {}

}
$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 257
Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99
Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333
Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262
Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 228
Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 936
Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136
Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221
Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274
Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 190
Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 957
Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276
Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 905
App\Model\Table\SalesTable::lists() - APP/Model/Table/SalesTable.php, line 178
App\Controller\OfficesController::show() - APP/Controller/OfficesController.php, line 32

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 Sales.id AS `Sales__id`, Sales.price AS `Sales__price`, Sales.usd_price AS `Sales__usd_price`, Sales.title AS `Sales__title`, Sales.slug AS `Sales__slug`, Sales.description AS `Sales__description`, Sales.year AS `Sales__year`, Sales.location AS `Sales__location`, Sales.adress AS `Sales__adress`, Sales.internal_reference AS `Sales__internal_reference`, Sales.validate AS `Sales__validate`, Sales.active AS `Sales__active`, Sales.views AS `Sales__views`, Sales.created AS `Sales__created`, Sales.currency_id AS `Sales__currency_id`, Sales.car_id AS `Sales__car_id`, Sales.real_estate_id AS `Sales__real_estate_id`, Sales.watche_id AS `Sales__watche_id`, Sales.yacht_id AS `Sales__yacht_id`, Sales.office_id AS `Sales__office_id`, Sales.agent_id AS `Sales__agent_id`, Sales.user_id AS `Sales__user_id`, Users.id AS `Users__id`, Users.email AS `Users__email`, Users.password AS `Users__password`, Users.name AS `Users__name`, Users.firstname AS `Users__firstname`, Users.subscription_date AS `Users__subscription_date`, Users.active AS `Users__active`, Users.created AS `Users__created`, Users.type AS `Users__type`, Users.location_id AS `Users__location_id`, Cars.id AS `Cars__id`, Cars.brand_name AS `Cars__brand_name`, Cars.model_name AS `Cars__model_name`, Cars.gamme AS `Cars__gamme`, Cars.model_trim AS `Cars__model_trim`, Cars.mileage AS `Cars__mileage`, Cars.gearbox AS `Cars__gearbox`, Cars.fuel_type AS `Cars__fuel_type`, Cars.color AS `Cars__color`, Cars.car_type AS `Cars__car_type`, Cars.interior_color AS `Cars__interior_color`, Cars.vin AS `Cars__vin`, Cars.conditions AS `Cars__conditions`, RealEstates.id AS `RealEstates__id`, RealEstates.property_type AS `RealEstates__property_type`, RealEstates.bedrooms AS `RealEstates__bedrooms`, RealEstates.bathrooms AS `RealEstates__bathrooms`, RealEstates.living_area AS `RealEstates__living_area`, RealEstates.land_area AS `RealEstates__land_area`, RealEstates.floors AS `RealEstates__floors`, RealEstates.guests AS `RealEstates__guests`, Watches.id AS `Watches__id`, Watches.brand_name AS `Watches__brand_name`, Watches.gender AS `Watches__gender`, Watches.case_material AS `Watches__case_material`, Watches.strap_material AS `Watches__strap_material`, Watches.movement AS `Watches__movement`, Watches.conditions AS `Watches__conditions`, Offices.id AS `Offices__id`, Offices.name AS `Offices__name`, Offices.slug AS `Offices__slug`, Offices.category AS `Offices__category`, Offices.presentation AS `Offices__presentation`, Offices.logo AS `Offices__logo`, Offices.email AS `Offices__email`, Offices.website AS `Offices__website`, Offices.active AS `Offices__active`, Offices.location_id AS `Offices__location_id`, Offices.user_id AS `Offices__user_id` FROM sales Sales INNER JOIN users Users ON Users.id = (Sales.user_id) LEFT JOIN cars Cars ON Cars.id = (Sales.car_id) LEFT JOIN real_estates RealEstates ON RealEstates.id = (Sales.real_estate_id) LEFT JOIN watches Watches ON Watches.id = (Sales.watche_id) LEFT JOIN offices Offices ON Offices.id = (Sales.office_id) WHERE (Sales.active = :c0 AND Sales.validate = :c1 AND Sales.office_id = :c2) ORDER BY Sales.created desc LIMIT 9 OFFSET 171'
$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' => [
		'Sales__id' => 'integer',
		'Sales.id' => 'integer',
		'id' => 'integer',
		'Sales__price' => 'integer',
		'Sales.price' => 'integer',
		'price' => 'integer',
		'Sales__usd_price' => 'integer',
		'Sales.usd_price' => 'integer',
		'usd_price' => 'integer',
		'Sales__title' => 'string',
		'Sales.title' => 'string',
		'title' => 'string',
		'Sales__slug' => 'string',
		'Sales.slug' => 'string',
		'slug' => 'string',
		'Sales__description' => 'text',
		'Sales.description' => 'text',
		'description' => 'text',
		'Sales__year' => 'text',
		'Sales.year' => 'text',
		'year' => 'text',
		'Sales__location' => 'string',
		'Sales.location' => 'string',
		'location' => 'string',
		'Sales__adress' => 'string',
		'Sales.adress' => 'string',
		'adress' => 'string',
		'Sales__internal_reference' => 'string',
		'Sales.internal_reference' => 'string',
		'internal_reference' => 'string',
		'Sales__validate' => 'boolean',
		'Sales.validate' => 'boolean',
		'validate' => 'boolean',
		'Sales__active' => 'boolean',
		'Sales.active' => 'boolean',
		'active' => 'boolean',
		'Sales__views' => 'integer',
		'Sales.views' => 'integer',
		'views' => 'integer',
		'Sales__created' => 'datetime',
		'Sales.created' => 'datetime',
		'created' => 'datetime',
		'Sales__currency_id' => 'integer',
		'Sales.currency_id' => 'integer',
		'currency_id' => 'integer',
		'Sales__car_id' => 'integer',
		'Sales.car_id' => 'integer',
		'car_id' => 'integer',
		'Sales__real_estate_id' => 'integer',
		'Sales.real_estate_id' => 'integer',
		'real_estate_id' => 'integer',
		'Sales__watche_id' => 'integer',
		'Sales.watche_id' => 'integer',
		'watche_id' => 'integer',
		'Sales__yacht_id' => 'integer',
		'Sales.yacht_id' => 'integer',
		'yacht_id' => 'integer',
		'Sales__office_id' => 'integer',
		'Sales.office_id' => 'integer',
		'office_id' => 'integer',
		'Sales__agent_id' => 'integer',
		'Sales.agent_id' => 'integer',
		'agent_id' => 'integer',
		'Sales__user_id' => 'integer',
		'Sales.user_id' => 'integer',
		'user_id' => 'integer',
		'Users__id' => 'integer',
		'Users.id' => 'integer',
		'Users__email' => 'string',
		'Users.email' => 'string',
		'email' => 'string',
		'Users__password' => 'string',
		'Users.password' => 'string',
		'password' => 'string',
		'Users__name' => 'string',
		'Users.name' => 'string',
		'name' => 'string',
		'Users__firstname' => 'string',
		'Users.firstname' => 'string',
		'firstname' => 'string',
		'Users__subscription_date' => 'date',
		'Users.subscription_date' => 'date',
		'subscription_date' => 'date',
		'Users__active' => 'boolean',
		'Users.active' => 'boolean',
		'Users__created' => 'datetime',
		'Users.created' => 'datetime',
		'Users__type' => 'string',
		'Users.type' => 'string',
		'type' => 'string',
		'Users__location_id' => 'integer',
		'Users.location_id' => 'integer',
		'location_id' => 'integer',
		'Cars__id' => 'integer',
		'Cars.id' => 'integer',
		'Cars__brand_name' => 'string',
		'Cars.brand_name' => 'string',
		'brand_name' => 'string',
		'Cars__model_name' => 'string',
		'Cars.model_name' => 'string',
		'model_name' => 'string',
		'Cars__gamme' => 'string',
		'Cars.gamme' => 'string',
		'gamme' => 'string',
		'Cars__model_trim' => 'string',
		'Cars.model_trim' => 'string',
		'model_trim' => 'string',
		'Cars__mileage' => 'string',
		'Cars.mileage' => 'string',
		'mileage' => 'string',
		'Cars__gearbox' => 'string',
		'Cars.gearbox' => 'string',
		'gearbox' => 'string',
		'Cars__fuel_type' => 'string',
		'Cars.fuel_type' => 'string',
		'fuel_type' => 'string',
		'Cars__color' => 'string',
		'Cars.color' => 'string',
		'color' => 'string',
		'Cars__car_type' => 'string',
		'Cars.car_type' => 'string',
		'car_type' => 'string',
		'Cars__interior_color' => 'string',
		'Cars.interior_color' => 'string',
		'interior_color' => 'string',
		'Cars__vin' => 'string',
		'Cars.vin' => 'string',
		'vin' => 'string',
		'Cars__conditions' => 'string',
		'Cars.conditions' => 'string',
		'conditions' => 'string',
		'RealEstates__id' => 'integer',
		'RealEstates.id' => 'integer',
		'RealEstates__property_type' => 'string',
		'RealEstates.property_type' => 'string',
		'property_type' => 'string',
		'RealEstates__bedrooms' => 'integer',
		'RealEstates.bedrooms' => 'integer',
		'bedrooms' => 'integer',
		'RealEstates__bathrooms' => 'integer',
		'RealEstates.bathrooms' => 'integer',
		'bathrooms' => 'integer',
		'RealEstates__living_area' => 'string',
		'RealEstates.living_area' => 'string',
		'living_area' => 'string',
		'RealEstates__land_area' => 'string',
		'RealEstates.land_area' => 'string',
		'land_area' => 'string',
		'RealEstates__floors' => 'integer',
		'RealEstates.floors' => 'integer',
		'floors' => 'integer',
		'RealEstates__guests' => 'integer',
		'RealEstates.guests' => 'integer',
		'guests' => 'integer',
		'Watches__id' => 'integer',
		'Watches.id' => 'integer',
		'Watches__brand_name' => 'string',
		'Watches.brand_name' => 'string',
		'Watches__gender' => 'string',
		'Watches.gender' => 'string',
		'gender' => 'string',
		'Watches__case_material' => 'string',
		'Watches.case_material' => 'string',
		'case_material' => 'string',
		'Watches__strap_material' => 'string',
		'Watches.strap_material' => 'string',
		'strap_material' => 'string',
		'Watches__movement' => 'string',
		'Watches.movement' => 'string',
		'movement' => 'string',
		'Watches__conditions' => 'string',
		'Watches.conditions' => 'string',
		'Pictures__id' => 'integer',
		'Pictures.id' => 'integer',
		'Pictures__name' => 'string',
		'Pictures.name' => 'string',
		'Pictures__rang' => 'integer',
		'Pictures.rang' => 'integer',
		'rang' => 'integer',
		'Pictures__sale_id' => 'integer',
		'Pictures.sale_id' => 'integer',
		'sale_id' => 'integer',
		'Offices__id' => 'integer',
		'Offices.id' => 'integer',
		'Offices__name' => 'string',
		'Offices.name' => 'string',
		'Offices__slug' => 'string',
		'Offices.slug' => 'string',
		'Offices__category' => 'string',
		'Offices.category' => 'string',
		'category' => 'string',
		'Offices__presentation' => 'text',
		'Offices.presentation' => 'text',
		'presentation' => 'text',
		'Offices__logo' => 'string',
		'Offices.logo' => 'string',
		'logo' => 'string',
		'Offices__email' => 'string',
		'Offices.email' => 'string',
		'Offices__website' => 'string',
		'Offices.website' => 'string',
		'website' => 'string',
		'Offices__active' => 'boolean',
		'Offices.active' => 'boolean',
		'Offices__location_id' => 'integer',
		'Offices.location_id' => 'integer',
		'Offices__user_id' => 'integer',
		'Offices.user_id' => 'integer'
	],
	'decorators' => (int) 0,
	'executed' => false,
	'hydrate' => true,
	'buffered' => true,
	'formatters' => (int) 0,
	'mapReducers' => (int) 0,
	'contain' => [
		'Users' => [[maximum depth reached]],
		'Cars' => [[maximum depth reached]],
		'RealEstates' => [[maximum depth reached]],
		'Watches' => [[maximum depth reached]],
		'Pictures' => [
			[maximum depth reached]
		],
		'Offices' => [[maximum depth reached]]
	],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\SalesTable) {}

}
$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 257
Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99
Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333
Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262
Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 228
Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 936
Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136
Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221
Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274
Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 190
Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 957
Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276
Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 905
App\Model\Table\SalesTable::lists() - APP/Model/Table/SalesTable.php, line 178
App\Controller\OfficesController::show() - APP/Controller/OfficesController.php, line 32

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 (COUNT(*)) AS `total` FROM sales Sales WHERE (Sales.active = :c0 AND Sales.validate = :c1 AND Sales.office_id = :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' => [
		'Sales__id' => 'integer',
		'Sales.id' => 'integer',
		'id' => 'integer',
		'Sales__price' => 'integer',
		'Sales.price' => 'integer',
		'price' => 'integer',
		'Sales__usd_price' => 'integer',
		'Sales.usd_price' => 'integer',
		'usd_price' => 'integer',
		'Sales__title' => 'string',
		'Sales.title' => 'string',
		'title' => 'string',
		'Sales__slug' => 'string',
		'Sales.slug' => 'string',
		'slug' => 'string',
		'Sales__description' => 'text',
		'Sales.description' => 'text',
		'description' => 'text',
		'Sales__year' => 'text',
		'Sales.year' => 'text',
		'year' => 'text',
		'Sales__location' => 'string',
		'Sales.location' => 'string',
		'location' => 'string',
		'Sales__adress' => 'string',
		'Sales.adress' => 'string',
		'adress' => 'string',
		'Sales__internal_reference' => 'string',
		'Sales.internal_reference' => 'string',
		'internal_reference' => 'string',
		'Sales__validate' => 'boolean',
		'Sales.validate' => 'boolean',
		'validate' => 'boolean',
		'Sales__active' => 'boolean',
		'Sales.active' => 'boolean',
		'active' => 'boolean',
		'Sales__views' => 'integer',
		'Sales.views' => 'integer',
		'views' => 'integer',
		'Sales__created' => 'datetime',
		'Sales.created' => 'datetime',
		'created' => 'datetime',
		'Sales__currency_id' => 'integer',
		'Sales.currency_id' => 'integer',
		'currency_id' => 'integer',
		'Sales__car_id' => 'integer',
		'Sales.car_id' => 'integer',
		'car_id' => 'integer',
		'Sales__real_estate_id' => 'integer',
		'Sales.real_estate_id' => 'integer',
		'real_estate_id' => 'integer',
		'Sales__watche_id' => 'integer',
		'Sales.watche_id' => 'integer',
		'watche_id' => 'integer',
		'Sales__yacht_id' => 'integer',
		'Sales.yacht_id' => 'integer',
		'yacht_id' => 'integer',
		'Sales__office_id' => 'integer',
		'Sales.office_id' => 'integer',
		'office_id' => 'integer',
		'Sales__agent_id' => 'integer',
		'Sales.agent_id' => 'integer',
		'agent_id' => 'integer',
		'Sales__user_id' => 'integer',
		'Sales.user_id' => 'integer',
		'user_id' => 'integer'
	],
	'decorators' => (int) 0,
	'executed' => false,
	'hydrate' => false,
	'buffered' => true,
	'formatters' => (int) 0,
	'mapReducers' => (int) 0,
	'contain' => [],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\SalesTable) {}

}
$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 257
Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99
Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333
Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262
Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 228
Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 936
Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136
Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221
Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274
Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 190
Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 957
Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276
Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 905
Cake\ORM\Query::first() - CORE/src/Datasource/QueryTrait.php, line 404
App\Model\Table\SalesTable::lists() - APP/Model/Table/SalesTable.php, line 183

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 = 'order'
$sql = 'SELECT (COUNT(*)) AS `total` FROM sales Sales WHERE (Sales.active = :c0 AND Sales.validate = :c1 AND Sales.office_id = :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' => [
		'Sales__id' => 'integer',
		'Sales.id' => 'integer',
		'id' => 'integer',
		'Sales__price' => 'integer',
		'Sales.price' => 'integer',
		'price' => 'integer',
		'Sales__usd_price' => 'integer',
		'Sales.usd_price' => 'integer',
		'usd_price' => 'integer',
		'Sales__title' => 'string',
		'Sales.title' => 'string',
		'title' => 'string',
		'Sales__slug' => 'string',
		'Sales.slug' => 'string',
		'slug' => 'string',
		'Sales__description' => 'text',
		'Sales.description' => 'text',
		'description' => 'text',
		'Sales__year' => 'text',
		'Sales.year' => 'text',
		'year' => 'text',
		'Sales__location' => 'string',
		'Sales.location' => 'string',
		'location' => 'string',
		'Sales__adress' => 'string',
		'Sales.adress' => 'string',
		'adress' => 'string',
		'Sales__internal_reference' => 'string',
		'Sales.internal_reference' => 'string',
		'internal_reference' => 'string',
		'Sales__validate' => 'boolean',
		'Sales.validate' => 'boolean',
		'validate' => 'boolean',
		'Sales__active' => 'boolean',
		'Sales.active' => 'boolean',
		'active' => 'boolean',
		'Sales__views' => 'integer',
		'Sales.views' => 'integer',
		'views' => 'integer',
		'Sales__created' => 'datetime',
		'Sales.created' => 'datetime',
		'created' => 'datetime',
		'Sales__currency_id' => 'integer',
		'Sales.currency_id' => 'integer',
		'currency_id' => 'integer',
		'Sales__car_id' => 'integer',
		'Sales.car_id' => 'integer',
		'car_id' => 'integer',
		'Sales__real_estate_id' => 'integer',
		'Sales.real_estate_id' => 'integer',
		'real_estate_id' => 'integer',
		'Sales__watche_id' => 'integer',
		'Sales.watche_id' => 'integer',
		'watche_id' => 'integer',
		'Sales__yacht_id' => 'integer',
		'Sales.yacht_id' => 'integer',
		'yacht_id' => 'integer',
		'Sales__office_id' => 'integer',
		'Sales.office_id' => 'integer',
		'office_id' => 'integer',
		'Sales__agent_id' => 'integer',
		'Sales.agent_id' => 'integer',
		'agent_id' => 'integer',
		'Sales__user_id' => 'integer',
		'Sales.user_id' => 'integer',
		'user_id' => 'integer'
	],
	'decorators' => (int) 0,
	'executed' => false,
	'hydrate' => false,
	'buffered' => true,
	'formatters' => (int) 0,
	'mapReducers' => (int) 0,
	'contain' => [],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\SalesTable) {}

}
$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 257
Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99
Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333
Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262
Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 228
Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 936
Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136
Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221
Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274
Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 190
Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 957
Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276
Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 905
Cake\ORM\Query::first() - CORE/src/Datasource/QueryTrait.php, line 404
App\Model\Table\SalesTable::lists() - APP/Model/Table/SalesTable.php, line 183

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 = (int) 1
$name = 'limit'
$sql = 'SELECT (COUNT(*)) AS `total` FROM sales Sales WHERE (Sales.active = :c0 AND Sales.validate = :c1 AND Sales.office_id = :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' => [
		'Sales__id' => 'integer',
		'Sales.id' => 'integer',
		'id' => 'integer',
		'Sales__price' => 'integer',
		'Sales.price' => 'integer',
		'price' => 'integer',
		'Sales__usd_price' => 'integer',
		'Sales.usd_price' => 'integer',
		'usd_price' => 'integer',
		'Sales__title' => 'string',
		'Sales.title' => 'string',
		'title' => 'string',
		'Sales__slug' => 'string',
		'Sales.slug' => 'string',
		'slug' => 'string',
		'Sales__description' => 'text',
		'Sales.description' => 'text',
		'description' => 'text',
		'Sales__year' => 'text',
		'Sales.year' => 'text',
		'year' => 'text',
		'Sales__location' => 'string',
		'Sales.location' => 'string',
		'location' => 'string',
		'Sales__adress' => 'string',
		'Sales.adress' => 'string',
		'adress' => 'string',
		'Sales__internal_reference' => 'string',
		'Sales.internal_reference' => 'string',
		'internal_reference' => 'string',
		'Sales__validate' => 'boolean',
		'Sales.validate' => 'boolean',
		'validate' => 'boolean',
		'Sales__active' => 'boolean',
		'Sales.active' => 'boolean',
		'active' => 'boolean',
		'Sales__views' => 'integer',
		'Sales.views' => 'integer',
		'views' => 'integer',
		'Sales__created' => 'datetime',
		'Sales.created' => 'datetime',
		'created' => 'datetime',
		'Sales__currency_id' => 'integer',
		'Sales.currency_id' => 'integer',
		'currency_id' => 'integer',
		'Sales__car_id' => 'integer',
		'Sales.car_id' => 'integer',
		'car_id' => 'integer',
		'Sales__real_estate_id' => 'integer',
		'Sales.real_estate_id' => 'integer',
		'real_estate_id' => 'integer',
		'Sales__watche_id' => 'integer',
		'Sales.watche_id' => 'integer',
		'watche_id' => 'integer',
		'Sales__yacht_id' => 'integer',
		'Sales.yacht_id' => 'integer',
		'yacht_id' => 'integer',
		'Sales__office_id' => 'integer',
		'Sales.office_id' => 'integer',
		'office_id' => 'integer',
		'Sales__agent_id' => 'integer',
		'Sales.agent_id' => 'integer',
		'agent_id' => 'integer',
		'Sales__user_id' => 'integer',
		'Sales.user_id' => 'integer',
		'user_id' => 'integer'
	],
	'decorators' => (int) 0,
	'executed' => false,
	'hydrate' => false,
	'buffered' => true,
	'formatters' => (int) 0,
	'mapReducers' => (int) 0,
	'contain' => [],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\SalesTable) {}

}
$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 257
Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99
Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333
Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262
Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 228
Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 936
Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136
Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221
Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274
Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 190
Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 957
Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276
Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 905
Cake\ORM\Query::first() - CORE/src/Datasource/QueryTrait.php, line 404
App\Model\Table\SalesTable::lists() - APP/Model/Table/SalesTable.php, line 183

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 (COUNT(*)) AS `total` FROM sales Sales WHERE (Sales.active = :c0 AND Sales.validate = :c1 AND Sales.office_id = :c2) LIMIT 1'
$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' => [
		'Sales__id' => 'integer',
		'Sales.id' => 'integer',
		'id' => 'integer',
		'Sales__price' => 'integer',
		'Sales.price' => 'integer',
		'price' => 'integer',
		'Sales__usd_price' => 'integer',
		'Sales.usd_price' => 'integer',
		'usd_price' => 'integer',
		'Sales__title' => 'string',
		'Sales.title' => 'string',
		'title' => 'string',
		'Sales__slug' => 'string',
		'Sales.slug' => 'string',
		'slug' => 'string',
		'Sales__description' => 'text',
		'Sales.description' => 'text',
		'description' => 'text',
		'Sales__year' => 'text',
		'Sales.year' => 'text',
		'year' => 'text',
		'Sales__location' => 'string',
		'Sales.location' => 'string',
		'location' => 'string',
		'Sales__adress' => 'string',
		'Sales.adress' => 'string',
		'adress' => 'string',
		'Sales__internal_reference' => 'string',
		'Sales.internal_reference' => 'string',
		'internal_reference' => 'string',
		'Sales__validate' => 'boolean',
		'Sales.validate' => 'boolean',
		'validate' => 'boolean',
		'Sales__active' => 'boolean',
		'Sales.active' => 'boolean',
		'active' => 'boolean',
		'Sales__views' => 'integer',
		'Sales.views' => 'integer',
		'views' => 'integer',
		'Sales__created' => 'datetime',
		'Sales.created' => 'datetime',
		'created' => 'datetime',
		'Sales__currency_id' => 'integer',
		'Sales.currency_id' => 'integer',
		'currency_id' => 'integer',
		'Sales__car_id' => 'integer',
		'Sales.car_id' => 'integer',
		'car_id' => 'integer',
		'Sales__real_estate_id' => 'integer',
		'Sales.real_estate_id' => 'integer',
		'real_estate_id' => 'integer',
		'Sales__watche_id' => 'integer',
		'Sales.watche_id' => 'integer',
		'watche_id' => 'integer',
		'Sales__yacht_id' => 'integer',
		'Sales.yacht_id' => 'integer',
		'yacht_id' => 'integer',
		'Sales__office_id' => 'integer',
		'Sales.office_id' => 'integer',
		'office_id' => 'integer',
		'Sales__agent_id' => 'integer',
		'Sales.agent_id' => 'integer',
		'agent_id' => 'integer',
		'Sales__user_id' => 'integer',
		'Sales.user_id' => 'integer',
		'user_id' => 'integer'
	],
	'decorators' => (int) 0,
	'executed' => false,
	'hydrate' => false,
	'buffered' => true,
	'formatters' => (int) 0,
	'mapReducers' => (int) 0,
	'contain' => [],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\SalesTable) {}

}
$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 257
Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99
Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333
Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262
Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 228
Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 936
Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136
Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221
Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274
Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 190
Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 957
Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276
Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 905
Cake\ORM\Query::first() - CORE/src/Datasource/QueryTrait.php, line 404
App\Model\Table\SalesTable::lists() - APP/Model/Table/SalesTable.php, line 183

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 (COUNT(*)) AS `total` FROM sales Sales WHERE (Sales.active = :c0 AND Sales.validate = :c1 AND Sales.office_id = :c2) LIMIT 1'
$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' => [
		'Sales__id' => 'integer',
		'Sales.id' => 'integer',
		'id' => 'integer',
		'Sales__price' => 'integer',
		'Sales.price' => 'integer',
		'price' => 'integer',
		'Sales__usd_price' => 'integer',
		'Sales.usd_price' => 'integer',
		'usd_price' => 'integer',
		'Sales__title' => 'string',
		'Sales.title' => 'string',
		'title' => 'string',
		'Sales__slug' => 'string',
		'Sales.slug' => 'string',
		'slug' => 'string',
		'Sales__description' => 'text',
		'Sales.description' => 'text',
		'description' => 'text',
		'Sales__year' => 'text',
		'Sales.year' => 'text',
		'year' => 'text',
		'Sales__location' => 'string',
		'Sales.location' => 'string',
		'location' => 'string',
		'Sales__adress' => 'string',
		'Sales.adress' => 'string',
		'adress' => 'string',
		'Sales__internal_reference' => 'string',
		'Sales.internal_reference' => 'string',
		'internal_reference' => 'string',
		'Sales__validate' => 'boolean',
		'Sales.validate' => 'boolean',
		'validate' => 'boolean',
		'Sales__active' => 'boolean',
		'Sales.active' => 'boolean',
		'active' => 'boolean',
		'Sales__views' => 'integer',
		'Sales.views' => 'integer',
		'views' => 'integer',
		'Sales__created' => 'datetime',
		'Sales.created' => 'datetime',
		'created' => 'datetime',
		'Sales__currency_id' => 'integer',
		'Sales.currency_id' => 'integer',
		'currency_id' => 'integer',
		'Sales__car_id' => 'integer',
		'Sales.car_id' => 'integer',
		'car_id' => 'integer',
		'Sales__real_estate_id' => 'integer',
		'Sales.real_estate_id' => 'integer',
		'real_estate_id' => 'integer',
		'Sales__watche_id' => 'integer',
		'Sales.watche_id' => 'integer',
		'watche_id' => 'integer',
		'Sales__yacht_id' => 'integer',
		'Sales.yacht_id' => 'integer',
		'yacht_id' => 'integer',
		'Sales__office_id' => 'integer',
		'Sales.office_id' => 'integer',
		'office_id' => 'integer',
		'Sales__agent_id' => 'integer',
		'Sales.agent_id' => 'integer',
		'agent_id' => 'integer',
		'Sales__user_id' => 'integer',
		'Sales.user_id' => 'integer',
		'user_id' => 'integer'
	],
	'decorators' => (int) 0,
	'executed' => false,
	'hydrate' => false,
	'buffered' => true,
	'formatters' => (int) 0,
	'mapReducers' => (int) 0,
	'contain' => [],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\SalesTable) {}

}
$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 257
Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99
Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333
Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262
Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 228
Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 936
Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136
Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221
Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274
Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 190
Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 957
Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276
Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 905
Cake\ORM\Query::first() - CORE/src/Datasource/QueryTrait.php, line 404
App\Model\Table\SalesTable::lists() - APP/Model/Table/SalesTable.php, line 183

Warning (512): Unable to emit headers. Headers sent in file=/home/luxury_pulse/sites/luxury_old/www/vendor/cakephp/cakephp/src/Error/Debugger.php line=754 [CORE/src/Http/ResponseEmitter.php, line 48]
Code Context
            $message = "Unable to emit headers. Headers sent in file=$file line=$line";
            if (Configure::read('debug')) {
                trigger_error($message, E_USER_WARNING);
$response = object(Zend\Diactoros\Response) {
	[protected] headers => [
		'Content-Type' => [
			[maximum depth reached]
		]
	]
	[protected] headerNames => [
		'content-type' => 'Content-Type'
	]
	[private] phrases => [
		(int) 100 => 'Continue',
		(int) 101 => 'Switching Protocols',
		(int) 102 => 'Processing',
		(int) 200 => 'OK',
		(int) 201 => 'Created',
		(int) 202 => 'Accepted',
		(int) 203 => 'Non-Authoritative Information',
		(int) 204 => 'No Content',
		(int) 205 => 'Reset Content',
		(int) 206 => 'Partial Content',
		(int) 207 => 'Multi-Status',
		(int) 208 => 'Already Reported',
		(int) 226 => 'IM Used',
		(int) 300 => 'Multiple Choices',
		(int) 301 => 'Moved Permanently',
		(int) 302 => 'Found',
		(int) 303 => 'See Other',
		(int) 304 => 'Not Modified',
		(int) 305 => 'Use Proxy',
		(int) 306 => 'Switch Proxy',
		(int) 307 => 'Temporary Redirect',
		(int) 308 => 'Permanent Redirect',
		(int) 400 => 'Bad Request',
		(int) 401 => 'Unauthorized',
		(int) 402 => 'Payment Required',
		(int) 403 => 'Forbidden',
		(int) 404 => 'Not Found',
		(int) 405 => 'Method Not Allowed',
		(int) 406 => 'Not Acceptable',
		(int) 407 => 'Proxy Authentication Required',
		(int) 408 => 'Request Timeout',
		(int) 409 => 'Conflict',
		(int) 410 => 'Gone',
		(int) 411 => 'Length Required',
		(int) 412 => 'Precondition Failed',
		(int) 413 => 'Payload Too Large',
		(int) 414 => 'URI Too Long',
		(int) 415 => 'Unsupported Media Type',
		(int) 416 => 'Range Not Satisfiable',
		(int) 417 => 'Expectation Failed',
		(int) 418 => 'I'm a teapot',
		(int) 421 => 'Misdirected Request',
		(int) 422 => 'Unprocessable Entity',
		(int) 423 => 'Locked',
		(int) 424 => 'Failed Dependency',
		(int) 425 => 'Unordered Collection',
		(int) 426 => 'Upgrade Required',
		(int) 428 => 'Precondition Required',
		(int) 429 => 'Too Many Requests',
		(int) 431 => 'Request Header Fields Too Large',
		(int) 444 => 'Connection Closed Without Response',
		(int) 451 => 'Unavailable For Legal Reasons',
		(int) 499 => 'Client Closed Request',
		(int) 500 => 'Internal Server Error',
		(int) 501 => 'Not Implemented',
		(int) 502 => 'Bad Gateway',
		(int) 503 => 'Service Unavailable',
		(int) 504 => 'Gateway Timeout',
		(int) 505 => 'HTTP Version Not Supported',
		(int) 506 => 'Variant Also Negotiates',
		(int) 507 => 'Insufficient Storage',
		(int) 508 => 'Loop Detected',
		(int) 510 => 'Not Extended',
		(int) 511 => 'Network Authentication Required',
		(int) 599 => 'Network Connect Timeout Error'
	]
	[private] reasonPhrase => ''
	[private] statusCode => (int) 200
	[private] protocol => '1.1'
	[private] stream => object(Zend\Diactoros\Stream) {}
}
$maxBufferLength = (int) 8192
$file = '/home/luxury_pulse/sites/luxury_old/www/vendor/cakephp/cakephp/src/Error/Debugger.php'
$line = (int) 754
$message = 'Unable to emit headers. Headers sent in file=/home/luxury_pulse/sites/luxury_old/www/vendor/cakephp/cakephp/src/Error/Debugger.php line=754'
Cake\Http\ResponseEmitter::emit() - CORE/src/Http/ResponseEmitter.php, line 48
Cake\Http\Server::emit() - CORE/src/Http/Server.php, line 116
[main] - ROOT/webroot/index.php, line 37

Warning (2): Cannot modify header information - headers already sent by (output started at /home/luxury_pulse/sites/luxury_old/www/vendor/cakephp/cakephp/src/Error/Debugger.php:754) [CORE/src/Http/ResponseEmitter.php, line 145]
Code Context
            $response->getProtocolVersion(),
            $response->getStatusCode(),
            ($reasonPhrase ? ' ' . $reasonPhrase : '')
$response = object(Zend\Diactoros\Response) {
	[protected] headers => [
		'Content-Type' => [
			[maximum depth reached]
		]
	]
	[protected] headerNames => [
		'content-type' => 'Content-Type'
	]
	[private] phrases => [
		(int) 100 => 'Continue',
		(int) 101 => 'Switching Protocols',
		(int) 102 => 'Processing',
		(int) 200 => 'OK',
		(int) 201 => 'Created',
		(int) 202 => 'Accepted',
		(int) 203 => 'Non-Authoritative Information',
		(int) 204 => 'No Content',
		(int) 205 => 'Reset Content',
		(int) 206 => 'Partial Content',
		(int) 207 => 'Multi-Status',
		(int) 208 => 'Already Reported',
		(int) 226 => 'IM Used',
		(int) 300 => 'Multiple Choices',
		(int) 301 => 'Moved Permanently',
		(int) 302 => 'Found',
		(int) 303 => 'See Other',
		(int) 304 => 'Not Modified',
		(int) 305 => 'Use Proxy',
		(int) 306 => 'Switch Proxy',
		(int) 307 => 'Temporary Redirect',
		(int) 308 => 'Permanent Redirect',
		(int) 400 => 'Bad Request',
		(int) 401 => 'Unauthorized',
		(int) 402 => 'Payment Required',
		(int) 403 => 'Forbidden',
		(int) 404 => 'Not Found',
		(int) 405 => 'Method Not Allowed',
		(int) 406 => 'Not Acceptable',
		(int) 407 => 'Proxy Authentication Required',
		(int) 408 => 'Request Timeout',
		(int) 409 => 'Conflict',
		(int) 410 => 'Gone',
		(int) 411 => 'Length Required',
		(int) 412 => 'Precondition Failed',
		(int) 413 => 'Payload Too Large',
		(int) 414 => 'URI Too Long',
		(int) 415 => 'Unsupported Media Type',
		(int) 416 => 'Range Not Satisfiable',
		(int) 417 => 'Expectation Failed',
		(int) 418 => 'I'm a teapot',
		(int) 421 => 'Misdirected Request',
		(int) 422 => 'Unprocessable Entity',
		(int) 423 => 'Locked',
		(int) 424 => 'Failed Dependency',
		(int) 425 => 'Unordered Collection',
		(int) 426 => 'Upgrade Required',
		(int) 428 => 'Precondition Required',
		(int) 429 => 'Too Many Requests',
		(int) 431 => 'Request Header Fields Too Large',
		(int) 444 => 'Connection Closed Without Response',
		(int) 451 => 'Unavailable For Legal Reasons',
		(int) 499 => 'Client Closed Request',
		(int) 500 => 'Internal Server Error',
		(int) 501 => 'Not Implemented',
		(int) 502 => 'Bad Gateway',
		(int) 503 => 'Service Unavailable',
		(int) 504 => 'Gateway Timeout',
		(int) 505 => 'HTTP Version Not Supported',
		(int) 506 => 'Variant Also Negotiates',
		(int) 507 => 'Insufficient Storage',
		(int) 508 => 'Loop Detected',
		(int) 510 => 'Not Extended',
		(int) 511 => 'Network Authentication Required',
		(int) 599 => 'Network Connect Timeout Error'
	]
	[private] reasonPhrase => 'OK'
	[private] statusCode => (int) 200
	[private] protocol => '1.1'
	[private] stream => object(Zend\Diactoros\Stream) {}
}
$reasonPhrase = 'OK'
header - [internal], line ??
Cake\Http\ResponseEmitter::emitStatusLine() - CORE/src/Http/ResponseEmitter.php, line 145
Cake\Http\ResponseEmitter::emit() - CORE/src/Http/ResponseEmitter.php, line 54
Cake\Http\Server::emit() - CORE/src/Http/Server.php, line 116
[main] - ROOT/webroot/index.php, line 37

Warning (2): Cannot modify header information - headers already sent by (output started at /home/luxury_pulse/sites/luxury_old/www/vendor/cakephp/cakephp/src/Error/Debugger.php:754) [CORE/src/Http/ResponseEmitter.php, line 173]
Code Context
                    $name,
                    $value
                ), $first);
$response = object(Zend\Diactoros\Response) {
	[protected] headers => [
		'Content-Type' => [
			[maximum depth reached]
		]
	]
	[protected] headerNames => [
		'content-type' => 'Content-Type'
	]
	[private] phrases => [
		(int) 100 => 'Continue',
		(int) 101 => 'Switching Protocols',
		(int) 102 => 'Processing',
		(int) 200 => 'OK',
		(int) 201 => 'Created',
		(int) 202 => 'Accepted',
		(int) 203 => 'Non-Authoritative Information',
		(int) 204 => 'No Content',
		(int) 205 => 'Reset Content',
		(int) 206 => 'Partial Content',
		(int) 207 => 'Multi-Status',
		(int) 208 => 'Already Reported',
		(int) 226 => 'IM Used',
		(int) 300 => 'Multiple Choices',
		(int) 301 => 'Moved Permanently',
		(int) 302 => 'Found',
		(int) 303 => 'See Other',
		(int) 304 => 'Not Modified',
		(int) 305 => 'Use Proxy',
		(int) 306 => 'Switch Proxy',
		(int) 307 => 'Temporary Redirect',
		(int) 308 => 'Permanent Redirect',
		(int) 400 => 'Bad Request',
		(int) 401 => 'Unauthorized',
		(int) 402 => 'Payment Required',
		(int) 403 => 'Forbidden',
		(int) 404 => 'Not Found',
		(int) 405 => 'Method Not Allowed',
		(int) 406 => 'Not Acceptable',
		(int) 407 => 'Proxy Authentication Required',
		(int) 408 => 'Request Timeout',
		(int) 409 => 'Conflict',
		(int) 410 => 'Gone',
		(int) 411 => 'Length Required',
		(int) 412 => 'Precondition Failed',
		(int) 413 => 'Payload Too Large',
		(int) 414 => 'URI Too Long',
		(int) 415 => 'Unsupported Media Type',
		(int) 416 => 'Range Not Satisfiable',
		(int) 417 => 'Expectation Failed',
		(int) 418 => 'I'm a teapot',
		(int) 421 => 'Misdirected Request',
		(int) 422 => 'Unprocessable Entity',
		(int) 423 => 'Locked',
		(int) 424 => 'Failed Dependency',
		(int) 425 => 'Unordered Collection',
		(int) 426 => 'Upgrade Required',
		(int) 428 => 'Precondition Required',
		(int) 429 => 'Too Many Requests',
		(int) 431 => 'Request Header Fields Too Large',
		(int) 444 => 'Connection Closed Without Response',
		(int) 451 => 'Unavailable For Legal Reasons',
		(int) 499 => 'Client Closed Request',
		(int) 500 => 'Internal Server Error',
		(int) 501 => 'Not Implemented',
		(int) 502 => 'Bad Gateway',
		(int) 503 => 'Service Unavailable',
		(int) 504 => 'Gateway Timeout',
		(int) 505 => 'HTTP Version Not Supported',
		(int) 506 => 'Variant Also Negotiates',
		(int) 507 => 'Insufficient Storage',
		(int) 508 => 'Loop Detected',
		(int) 510 => 'Not Extended',
		(int) 511 => 'Network Authentication Required',
		(int) 599 => 'Network Connect Timeout Error'
	]
	[private] reasonPhrase => 'OK'
	[private] statusCode => (int) 200
	[private] protocol => '1.1'
	[private] stream => object(Zend\Diactoros\Stream) {}
}
$values = [
	(int) 0 => 'text/html; charset=UTF-8'
]
$name = 'Content-Type'
$first = true
$value = 'text/html; charset=UTF-8'
header - [internal], line ??
Cake\Http\ResponseEmitter::emitHeaders() - CORE/src/Http/ResponseEmitter.php, line 173
Cake\Http\ResponseEmitter::emit() - CORE/src/Http/ResponseEmitter.php, line 55
Cake\Http\Server::emit() - CORE/src/Http/Server.php, line 116
[main] - ROOT/webroot/index.php, line 37

Notice (8): Trying to get property 'presentation' of non-object [APP/Template/Offices/show.ctp, line 6]
Code Context
// Description
$this->start('meta');
echo $this->Html->meta('description', strip_tags(substr($office->presentation, 0, 250)));
$viewFile = '/home/luxury_pulse/sites/luxury_old/www/src/Template/Offices/show.ctp'
$dataForView = [
	'title' => null,
	'menuType' => 'fixed',
	'page' => '20',
	'office' => null,
	'sales' => [
		'datas' => [],
		'count' => [
			'total' => (int) 0,
			'pages' => (int) 0
		]
	]
]
$title = null
$menuType = 'fixed'
$page = '20'
$office = null
$sales = [
	'datas' => [],
	'count' => [
		'total' => (int) 0,
		'pages' => (int) 0
	]
]
include - APP/Template/Offices/show.ctp, line 6
Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1014
Cake\View\View::_render() - CORE/src/View/View.php, line 973
Cake\View\View::render() - CORE/src/View/View.php, line 597
Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 617
Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 127
Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 95
Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 83
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Routing\Middleware\RoutingMiddleware::__invoke() - CORE/src/Routing/Middleware/RoutingMiddleware.php, line 62
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Routing\Middleware\AssetMiddleware::__invoke() - CORE/src/Routing/Middleware/AssetMiddleware.php, line 88
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Error\Middleware\ErrorHandlerMiddleware::__invoke() - CORE/src/Error/Middleware/ErrorHandlerMiddleware.php, line 81
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Http\Runner::run() - CORE/src/Http/Runner.php, line 51
Cake\Http\Server::run() - CORE/src/Http/Server.php, line 90

Login

Notice (8): Trying to get property 'name' of non-object [APP/Template/Offices/show.ctp, line 3]
Code Context
<?php
// Titre
$this->assign('title', $office->name . ' - More luxury dealers on LuxuryPulse.');
$viewFile = '/home/luxury_pulse/sites/luxury_old/www/src/Template/Offices/show.ctp'
$dataForView = [
	'title' => null,
	'menuType' => 'fixed',
	'page' => '20',
	'office' => null,
	'sales' => [
		'datas' => [],
		'count' => [
			'total' => (int) 0,
			'pages' => (int) 0
		]
	]
]
$title = null
$menuType = 'fixed'
$page = '20'
$office = null
$sales = [
	'datas' => [],
	'count' => [
		'total' => (int) 0,
		'pages' => (int) 0
	]
]
include - APP/Template/Offices/show.ctp, line 3
Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1014
Cake\View\View::_render() - CORE/src/View/View.php, line 973
Cake\View\View::render() - CORE/src/View/View.php, line 597
Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 617
Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 127
Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 95
Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 83
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Routing\Middleware\RoutingMiddleware::__invoke() - CORE/src/Routing/Middleware/RoutingMiddleware.php, line 62
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Routing\Middleware\AssetMiddleware::__invoke() - CORE/src/Routing/Middleware/AssetMiddleware.php, line 88
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Error\Middleware\ErrorHandlerMiddleware::__invoke() - CORE/src/Error/Middleware/ErrorHandlerMiddleware.php, line 81
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Http\Runner::run() - CORE/src/Http/Runner.php, line 51
Cake\Http\Server::run() - CORE/src/Http/Server.php, line 90

Notice (8): Trying to get property 'location' of non-object [APP/Template/Offices/show.ctp, line 44]
Code Context
                <?= isset($office->location->adress1) && $office->location->adress1 != '' ? $office->location->adress1 . '<br>' : '' ?>
                <?= isset($office->location->adress2) && $office->location->adress2 != '' ? $office->location->adress2 . '<br>' : '' ?>
                <?= $office->location->city ?><br>
$viewFile = '/home/luxury_pulse/sites/luxury_old/www/src/Template/Offices/show.ctp'
$dataForView = [
	'title' => null,
	'menuType' => 'fixed',
	'page' => '20',
	'office' => null,
	'sales' => [
		'datas' => [],
		'count' => [
			'total' => (int) 0,
			'pages' => (int) 0
		]
	]
]
$title = null
$menuType = 'fixed'
$page = '20'
$office = null
$sales = [
	'datas' => [],
	'count' => [
		'total' => (int) 0,
		'pages' => (int) 0
	]
]
include - APP/Template/Offices/show.ctp, line 44
Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1014
Cake\View\View::_render() - CORE/src/View/View.php, line 973
Cake\View\View::render() - CORE/src/View/View.php, line 597
Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 617
Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 127
Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 95
Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 83
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Routing\Middleware\RoutingMiddleware::__invoke() - CORE/src/Routing/Middleware/RoutingMiddleware.php, line 62
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Routing\Middleware\AssetMiddleware::__invoke() - CORE/src/Routing/Middleware/AssetMiddleware.php, line 88
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Error\Middleware\ErrorHandlerMiddleware::__invoke() - CORE/src/Error/Middleware/ErrorHandlerMiddleware.php, line 81
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Http\Runner::run() - CORE/src/Http/Runner.php, line 51
Cake\Http\Server::run() - CORE/src/Http/Server.php, line 90

Notice (8): Trying to get property 'city' of non-object [APP/Template/Offices/show.ctp, line 44]
Code Context
                <?= isset($office->location->adress1) && $office->location->adress1 != '' ? $office->location->adress1 . '<br>' : '' ?>
                <?= isset($office->location->adress2) && $office->location->adress2 != '' ? $office->location->adress2 . '<br>' : '' ?>
                <?= $office->location->city ?><br>
$viewFile = '/home/luxury_pulse/sites/luxury_old/www/src/Template/Offices/show.ctp'
$dataForView = [
	'title' => null,
	'menuType' => 'fixed',
	'page' => '20',
	'office' => null,
	'sales' => [
		'datas' => [],
		'count' => [
			'total' => (int) 0,
			'pages' => (int) 0
		]
	]
]
$title = null
$menuType = 'fixed'
$page = '20'
$office = null
$sales = [
	'datas' => [],
	'count' => [
		'total' => (int) 0,
		'pages' => (int) 0
	]
]
include - APP/Template/Offices/show.ctp, line 44
Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1014
Cake\View\View::_render() - CORE/src/View/View.php, line 973
Cake\View\View::render() - CORE/src/View/View.php, line 597
Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 617
Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 127
Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 95
Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 83
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Routing\Middleware\RoutingMiddleware::__invoke() - CORE/src/Routing/Middleware/RoutingMiddleware.php, line 62
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Routing\Middleware\AssetMiddleware::__invoke() - CORE/src/Routing/Middleware/AssetMiddleware.php, line 88
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Error\Middleware\ErrorHandlerMiddleware::__invoke() - CORE/src/Error/Middleware/ErrorHandlerMiddleware.php, line 81
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Http\Runner::run() - CORE/src/Http/Runner.php, line 51
Cake\Http\Server::run() - CORE/src/Http/Server.php, line 90

Notice (8): Trying to get property 'location' of non-object [APP/Template/Offices/show.ctp, line 46]
Code Context
                <?= $office->location->city ?><br>
                <?= isset($office->location->state) && $office->location->state != '' ? $office->location->state . '<br>' : '' ?>
                <?= $office->location->country->country_name ?><br><br>
$viewFile = '/home/luxury_pulse/sites/luxury_old/www/src/Template/Offices/show.ctp'
$dataForView = [
	'title' => null,
	'menuType' => 'fixed',
	'page' => '20',
	'office' => null,
	'sales' => [
		'datas' => [],
		'count' => [
			'total' => (int) 0,
			'pages' => (int) 0
		]
	]
]
$title = null
$menuType = 'fixed'
$page = '20'
$office = null
$sales = [
	'datas' => [],
	'count' => [
		'total' => (int) 0,
		'pages' => (int) 0
	]
]
include - APP/Template/Offices/show.ctp, line 46
Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1014
Cake\View\View::_render() - CORE/src/View/View.php, line 973
Cake\View\View::render() - CORE/src/View/View.php, line 597
Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 617
Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 127
Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 95
Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 83
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Routing\Middleware\RoutingMiddleware::__invoke() - CORE/src/Routing/Middleware/RoutingMiddleware.php, line 62
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Routing\Middleware\AssetMiddleware::__invoke() - CORE/src/Routing/Middleware/AssetMiddleware.php, line 88
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Error\Middleware\ErrorHandlerMiddleware::__invoke() - CORE/src/Error/Middleware/ErrorHandlerMiddleware.php, line 81
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Http\Runner::run() - CORE/src/Http/Runner.php, line 51
Cake\Http\Server::run() - CORE/src/Http/Server.php, line 90

Notice (8): Trying to get property 'country' of non-object [APP/Template/Offices/show.ctp, line 46]
Code Context
                <?= $office->location->city ?><br>
                <?= isset($office->location->state) && $office->location->state != '' ? $office->location->state . '<br>' : '' ?>
                <?= $office->location->country->country_name ?><br><br>
$viewFile = '/home/luxury_pulse/sites/luxury_old/www/src/Template/Offices/show.ctp'
$dataForView = [
	'title' => null,
	'menuType' => 'fixed',
	'page' => '20',
	'office' => null,
	'sales' => [
		'datas' => [],
		'count' => [
			'total' => (int) 0,
			'pages' => (int) 0
		]
	]
]
$title = null
$menuType = 'fixed'
$page = '20'
$office = null
$sales = [
	'datas' => [],
	'count' => [
		'total' => (int) 0,
		'pages' => (int) 0
	]
]
include - APP/Template/Offices/show.ctp, line 46
Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1014
Cake\View\View::_render() - CORE/src/View/View.php, line 973
Cake\View\View::render() - CORE/src/View/View.php, line 597
Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 617
Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 127
Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 95
Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 83
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Routing\Middleware\RoutingMiddleware::__invoke() - CORE/src/Routing/Middleware/RoutingMiddleware.php, line 62
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Routing\Middleware\AssetMiddleware::__invoke() - CORE/src/Routing/Middleware/AssetMiddleware.php, line 88
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Error\Middleware\ErrorHandlerMiddleware::__invoke() - CORE/src/Error/Middleware/ErrorHandlerMiddleware.php, line 81
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Http\Runner::run() - CORE/src/Http/Runner.php, line 51
Cake\Http\Server::run() - CORE/src/Http/Server.php, line 90

Notice (8): Trying to get property 'country_name' of non-object [APP/Template/Offices/show.ctp, line 46]
Code Context
                <?= $office->location->city ?><br>
                <?= isset($office->location->state) && $office->location->state != '' ? $office->location->state . '<br>' : '' ?>
                <?= $office->location->country->country_name ?><br><br>
$viewFile = '/home/luxury_pulse/sites/luxury_old/www/src/Template/Offices/show.ctp'
$dataForView = [
	'title' => null,
	'menuType' => 'fixed',
	'page' => '20',
	'office' => null,
	'sales' => [
		'datas' => [],
		'count' => [
			'total' => (int) 0,
			'pages' => (int) 0
		]
	]
]
$title = null
$menuType = 'fixed'
$page = '20'
$office = null
$sales = [
	'datas' => [],
	'count' => [
		'total' => (int) 0,
		'pages' => (int) 0
	]
]
include - APP/Template/Offices/show.ctp, line 46
Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1014
Cake\View\View::_render() - CORE/src/View/View.php, line 973
Cake\View\View::render() - CORE/src/View/View.php, line 597
Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 617
Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 127
Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 95
Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 83
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Routing\Middleware\RoutingMiddleware::__invoke() - CORE/src/Routing/Middleware/RoutingMiddleware.php, line 62
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Routing\Middleware\AssetMiddleware::__invoke() - CORE/src/Routing/Middleware/AssetMiddleware.php, line 88
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Error\Middleware\ErrorHandlerMiddleware::__invoke() - CORE/src/Error/Middleware/ErrorHandlerMiddleware.php, line 81
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Http\Runner::run() - CORE/src/Http/Runner.php, line 51
Cake\Http\Server::run() - CORE/src/Http/Server.php, line 90