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 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`, Agents.id AS `Agents__id`, Agents.name AS `Agents__name`, Agents.firstname AS `Agents__firstname`, Agents.photo AS `Agents__photo`, Agents.bio AS `Agents__bio`, Agents.active AS `Agents__active`, Agents.location_id AS `Agents__location_id`, Agents.user_id AS `Agents__user_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`, Yachts.id AS `Yachts__id`, Yachts.flag AS `Yachts__flag`, Yachts.brand_name AS `Yachts__brand_name`, Yachts.length AS `Yachts__length`, Yachts.beam AS `Yachts__beam`, Yachts.bearth AS `Yachts__bearth`, Yachts.engines AS `Yachts__engines`, Yachts.engines_hp AS `Yachts__engines_hp`, Yachts.engine_hours AS `Yachts__engine_hours`, Yachts.engine_brand AS `Yachts__engine_brand`, Yachts.max_speed AS `Yachts__max_speed`, Yachts.fuel_tankage AS `Yachts__fuel_tankage`, Yachts.water_tankage AS `Yachts__water_tankage`, Yachts.naval_architect AS `Yachts__naval_architect`, Yachts.interior_designer AS `Yachts__interior_designer`, Yachts.boat_type AS `Yachts__boat_type`, Yachts.cabins AS `Yachts__cabins`, Yachts.conditions AS `Yachts__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`, Currencies.id AS `Currencies__id`, Currencies.name AS `Currencies__name`, Currencies.code AS `Currencies__code` FROM sales Sales INNER JOIN users Users ON Users.id = (Sales.user_id) LEFT JOIN agents Agents ON Agents.id = (Sales.agent_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 yachts Yachts ON Yachts.id = (Sales.yacht_id) LEFT JOIN offices Offices ON Offices.id = (Sales.office_id) LEFT JOIN currencies Currencies ON Currencies.id = (Sales.currency_id) WHERE Sales.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' => [
		'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',
		'Agents__id' => 'integer',
		'Agents.id' => 'integer',
		'Agents__name' => 'string',
		'Agents.name' => 'string',
		'Agents__firstname' => 'string',
		'Agents.firstname' => 'string',
		'Agents__photo' => 'string',
		'Agents.photo' => 'string',
		'photo' => 'string',
		'Agents__bio' => 'string',
		'Agents.bio' => 'string',
		'bio' => 'string',
		'Agents__active' => 'boolean',
		'Agents.active' => 'boolean',
		'Agents__location_id' => 'integer',
		'Agents.location_id' => 'integer',
		'Agents__user_id' => 'integer',
		'Agents.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',
		'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',
		'Yachts__id' => 'integer',
		'Yachts.id' => 'integer',
		'Yachts__flag' => 'string',
		'Yachts.flag' => 'string',
		'flag' => 'string',
		'Yachts__brand_name' => 'string',
		'Yachts.brand_name' => 'string',
		'Yachts__length' => 'string',
		'Yachts.length' => 'string',
		'length' => 'string',
		'Yachts__beam' => 'string',
		'Yachts.beam' => 'string',
		'beam' => 'string',
		'Yachts__bearth' => 'string',
		'Yachts.bearth' => 'string',
		'bearth' => 'string',
		'Yachts__engines' => 'string',
		'Yachts.engines' => 'string',
		'engines' => 'string',
		'Yachts__engines_hp' => 'string',
		'Yachts.engines_hp' => 'string',
		'engines_hp' => 'string',
		'Yachts__engine_hours' => 'string',
		'Yachts.engine_hours' => 'string',
		'engine_hours' => 'string',
		'Yachts__engine_brand' => 'string',
		'Yachts.engine_brand' => 'string',
		'engine_brand' => 'string',
		'Yachts__max_speed' => 'string',
		'Yachts.max_speed' => 'string',
		'max_speed' => 'string',
		'Yachts__fuel_tankage' => 'string',
		'Yachts.fuel_tankage' => 'string',
		'fuel_tankage' => 'string',
		'Yachts__water_tankage' => 'string',
		'Yachts.water_tankage' => 'string',
		'water_tankage' => 'string',
		'Yachts__naval_architect' => 'string',
		'Yachts.naval_architect' => 'string',
		'naval_architect' => 'string',
		'Yachts__interior_designer' => 'string',
		'Yachts.interior_designer' => 'string',
		'interior_designer' => 'string',
		'Yachts__boat_type' => 'string',
		'Yachts.boat_type' => 'string',
		'boat_type' => 'string',
		'Yachts__cabins' => 'string',
		'Yachts.cabins' => 'string',
		'cabins' => 'string',
		'Yachts__conditions' => 'string',
		'Yachts.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',
		'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',
		'Currencies__id' => 'integer',
		'Currencies.id' => 'integer',
		'Currencies__name' => 'string',
		'Currencies.name' => 'string',
		'Currencies__code' => 'string',
		'Currencies.code' => 'string',
		'code' => 'string'
	],
	'decorators' => (int) 0,
	'executed' => false,
	'hydrate' => true,
	'buffered' => true,
	'formatters' => (int) 0,
	'mapReducers' => (int) 0,
	'contain' => [
		'Users' => [[maximum depth reached]],
		'Agents' => [
			[maximum depth reached]
		],
		'Cars' => [[maximum depth reached]],
		'RealEstates' => [[maximum depth reached]],
		'Watches' => [[maximum depth reached]],
		'Yachts' => [[maximum depth reached]],
		'Pictures' => [
			[maximum depth reached]
		],
		'Offices' => [
			[maximum depth reached]
		],
		'Currencies' => [[maximum depth reached]]
	],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\SalesTable) {}

}
$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\SalesController::show() - APP/Controller/SalesController.php, line 26

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 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`, Agents.id AS `Agents__id`, Agents.name AS `Agents__name`, Agents.firstname AS `Agents__firstname`, Agents.photo AS `Agents__photo`, Agents.bio AS `Agents__bio`, Agents.active AS `Agents__active`, Agents.location_id AS `Agents__location_id`, Agents.user_id AS `Agents__user_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`, Yachts.id AS `Yachts__id`, Yachts.flag AS `Yachts__flag`, Yachts.brand_name AS `Yachts__brand_name`, Yachts.length AS `Yachts__length`, Yachts.beam AS `Yachts__beam`, Yachts.bearth AS `Yachts__bearth`, Yachts.engines AS `Yachts__engines`, Yachts.engines_hp AS `Yachts__engines_hp`, Yachts.engine_hours AS `Yachts__engine_hours`, Yachts.engine_brand AS `Yachts__engine_brand`, Yachts.max_speed AS `Yachts__max_speed`, Yachts.fuel_tankage AS `Yachts__fuel_tankage`, Yachts.water_tankage AS `Yachts__water_tankage`, Yachts.naval_architect AS `Yachts__naval_architect`, Yachts.interior_designer AS `Yachts__interior_designer`, Yachts.boat_type AS `Yachts__boat_type`, Yachts.cabins AS `Yachts__cabins`, Yachts.conditions AS `Yachts__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`, Currencies.id AS `Currencies__id`, Currencies.name AS `Currencies__name`, Currencies.code AS `Currencies__code` FROM sales Sales INNER JOIN users Users ON Users.id = (Sales.user_id) LEFT JOIN agents Agents ON Agents.id = (Sales.agent_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 yachts Yachts ON Yachts.id = (Sales.yacht_id) LEFT JOIN offices Offices ON Offices.id = (Sales.office_id) LEFT JOIN currencies Currencies ON Currencies.id = (Sales.currency_id) WHERE Sales.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' => [
		'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',
		'Agents__id' => 'integer',
		'Agents.id' => 'integer',
		'Agents__name' => 'string',
		'Agents.name' => 'string',
		'Agents__firstname' => 'string',
		'Agents.firstname' => 'string',
		'Agents__photo' => 'string',
		'Agents.photo' => 'string',
		'photo' => 'string',
		'Agents__bio' => 'string',
		'Agents.bio' => 'string',
		'bio' => 'string',
		'Agents__active' => 'boolean',
		'Agents.active' => 'boolean',
		'Agents__location_id' => 'integer',
		'Agents.location_id' => 'integer',
		'Agents__user_id' => 'integer',
		'Agents.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',
		'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',
		'Yachts__id' => 'integer',
		'Yachts.id' => 'integer',
		'Yachts__flag' => 'string',
		'Yachts.flag' => 'string',
		'flag' => 'string',
		'Yachts__brand_name' => 'string',
		'Yachts.brand_name' => 'string',
		'Yachts__length' => 'string',
		'Yachts.length' => 'string',
		'length' => 'string',
		'Yachts__beam' => 'string',
		'Yachts.beam' => 'string',
		'beam' => 'string',
		'Yachts__bearth' => 'string',
		'Yachts.bearth' => 'string',
		'bearth' => 'string',
		'Yachts__engines' => 'string',
		'Yachts.engines' => 'string',
		'engines' => 'string',
		'Yachts__engines_hp' => 'string',
		'Yachts.engines_hp' => 'string',
		'engines_hp' => 'string',
		'Yachts__engine_hours' => 'string',
		'Yachts.engine_hours' => 'string',
		'engine_hours' => 'string',
		'Yachts__engine_brand' => 'string',
		'Yachts.engine_brand' => 'string',
		'engine_brand' => 'string',
		'Yachts__max_speed' => 'string',
		'Yachts.max_speed' => 'string',
		'max_speed' => 'string',
		'Yachts__fuel_tankage' => 'string',
		'Yachts.fuel_tankage' => 'string',
		'fuel_tankage' => 'string',
		'Yachts__water_tankage' => 'string',
		'Yachts.water_tankage' => 'string',
		'water_tankage' => 'string',
		'Yachts__naval_architect' => 'string',
		'Yachts.naval_architect' => 'string',
		'naval_architect' => 'string',
		'Yachts__interior_designer' => 'string',
		'Yachts.interior_designer' => 'string',
		'interior_designer' => 'string',
		'Yachts__boat_type' => 'string',
		'Yachts.boat_type' => 'string',
		'boat_type' => 'string',
		'Yachts__cabins' => 'string',
		'Yachts.cabins' => 'string',
		'cabins' => 'string',
		'Yachts__conditions' => 'string',
		'Yachts.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',
		'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',
		'Currencies__id' => 'integer',
		'Currencies.id' => 'integer',
		'Currencies__name' => 'string',
		'Currencies.name' => 'string',
		'Currencies__code' => 'string',
		'Currencies.code' => 'string',
		'code' => 'string'
	],
	'decorators' => (int) 0,
	'executed' => false,
	'hydrate' => true,
	'buffered' => true,
	'formatters' => (int) 0,
	'mapReducers' => (int) 0,
	'contain' => [
		'Users' => [[maximum depth reached]],
		'Agents' => [
			[maximum depth reached]
		],
		'Cars' => [[maximum depth reached]],
		'RealEstates' => [[maximum depth reached]],
		'Watches' => [[maximum depth reached]],
		'Yachts' => [[maximum depth reached]],
		'Pictures' => [
			[maximum depth reached]
		],
		'Offices' => [
			[maximum depth reached]
		],
		'Currencies' => [[maximum depth reached]]
	],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\SalesTable) {}

}
$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\SalesController::show() - APP/Controller/SalesController.php, line 26

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 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`, Agents.id AS `Agents__id`, Agents.name AS `Agents__name`, Agents.firstname AS `Agents__firstname`, Agents.photo AS `Agents__photo`, Agents.bio AS `Agents__bio`, Agents.active AS `Agents__active`, Agents.location_id AS `Agents__location_id`, Agents.user_id AS `Agents__user_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`, Yachts.id AS `Yachts__id`, Yachts.flag AS `Yachts__flag`, Yachts.brand_name AS `Yachts__brand_name`, Yachts.length AS `Yachts__length`, Yachts.beam AS `Yachts__beam`, Yachts.bearth AS `Yachts__bearth`, Yachts.engines AS `Yachts__engines`, Yachts.engines_hp AS `Yachts__engines_hp`, Yachts.engine_hours AS `Yachts__engine_hours`, Yachts.engine_brand AS `Yachts__engine_brand`, Yachts.max_speed AS `Yachts__max_speed`, Yachts.fuel_tankage AS `Yachts__fuel_tankage`, Yachts.water_tankage AS `Yachts__water_tankage`, Yachts.naval_architect AS `Yachts__naval_architect`, Yachts.interior_designer AS `Yachts__interior_designer`, Yachts.boat_type AS `Yachts__boat_type`, Yachts.cabins AS `Yachts__cabins`, Yachts.conditions AS `Yachts__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`, Currencies.id AS `Currencies__id`, Currencies.name AS `Currencies__name`, Currencies.code AS `Currencies__code` FROM sales Sales INNER JOIN users Users ON Users.id = (Sales.user_id) LEFT JOIN agents Agents ON Agents.id = (Sales.agent_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 yachts Yachts ON Yachts.id = (Sales.yacht_id) LEFT JOIN offices Offices ON Offices.id = (Sales.office_id) LEFT JOIN currencies Currencies ON Currencies.id = (Sales.currency_id) WHERE Sales.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' => [
		'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',
		'Agents__id' => 'integer',
		'Agents.id' => 'integer',
		'Agents__name' => 'string',
		'Agents.name' => 'string',
		'Agents__firstname' => 'string',
		'Agents.firstname' => 'string',
		'Agents__photo' => 'string',
		'Agents.photo' => 'string',
		'photo' => 'string',
		'Agents__bio' => 'string',
		'Agents.bio' => 'string',
		'bio' => 'string',
		'Agents__active' => 'boolean',
		'Agents.active' => 'boolean',
		'Agents__location_id' => 'integer',
		'Agents.location_id' => 'integer',
		'Agents__user_id' => 'integer',
		'Agents.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',
		'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',
		'Yachts__id' => 'integer',
		'Yachts.id' => 'integer',
		'Yachts__flag' => 'string',
		'Yachts.flag' => 'string',
		'flag' => 'string',
		'Yachts__brand_name' => 'string',
		'Yachts.brand_name' => 'string',
		'Yachts__length' => 'string',
		'Yachts.length' => 'string',
		'length' => 'string',
		'Yachts__beam' => 'string',
		'Yachts.beam' => 'string',
		'beam' => 'string',
		'Yachts__bearth' => 'string',
		'Yachts.bearth' => 'string',
		'bearth' => 'string',
		'Yachts__engines' => 'string',
		'Yachts.engines' => 'string',
		'engines' => 'string',
		'Yachts__engines_hp' => 'string',
		'Yachts.engines_hp' => 'string',
		'engines_hp' => 'string',
		'Yachts__engine_hours' => 'string',
		'Yachts.engine_hours' => 'string',
		'engine_hours' => 'string',
		'Yachts__engine_brand' => 'string',
		'Yachts.engine_brand' => 'string',
		'engine_brand' => 'string',
		'Yachts__max_speed' => 'string',
		'Yachts.max_speed' => 'string',
		'max_speed' => 'string',
		'Yachts__fuel_tankage' => 'string',
		'Yachts.fuel_tankage' => 'string',
		'fuel_tankage' => 'string',
		'Yachts__water_tankage' => 'string',
		'Yachts.water_tankage' => 'string',
		'water_tankage' => 'string',
		'Yachts__naval_architect' => 'string',
		'Yachts.naval_architect' => 'string',
		'naval_architect' => 'string',
		'Yachts__interior_designer' => 'string',
		'Yachts.interior_designer' => 'string',
		'interior_designer' => 'string',
		'Yachts__boat_type' => 'string',
		'Yachts.boat_type' => 'string',
		'boat_type' => 'string',
		'Yachts__cabins' => 'string',
		'Yachts.cabins' => 'string',
		'cabins' => 'string',
		'Yachts__conditions' => 'string',
		'Yachts.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',
		'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',
		'Currencies__id' => 'integer',
		'Currencies.id' => 'integer',
		'Currencies__name' => 'string',
		'Currencies.name' => 'string',
		'Currencies__code' => 'string',
		'Currencies.code' => 'string',
		'code' => 'string'
	],
	'decorators' => (int) 0,
	'executed' => false,
	'hydrate' => true,
	'buffered' => true,
	'formatters' => (int) 0,
	'mapReducers' => (int) 0,
	'contain' => [
		'Users' => [[maximum depth reached]],
		'Agents' => [
			[maximum depth reached]
		],
		'Cars' => [[maximum depth reached]],
		'RealEstates' => [[maximum depth reached]],
		'Watches' => [[maximum depth reached]],
		'Yachts' => [[maximum depth reached]],
		'Pictures' => [
			[maximum depth reached]
		],
		'Offices' => [
			[maximum depth reached]
		],
		'Currencies' => [[maximum depth reached]]
	],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\SalesTable) {}

}
$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\SalesController::show() - APP/Controller/SalesController.php, line 26

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 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`, Agents.id AS `Agents__id`, Agents.name AS `Agents__name`, Agents.firstname AS `Agents__firstname`, Agents.photo AS `Agents__photo`, Agents.bio AS `Agents__bio`, Agents.active AS `Agents__active`, Agents.location_id AS `Agents__location_id`, Agents.user_id AS `Agents__user_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`, Yachts.id AS `Yachts__id`, Yachts.flag AS `Yachts__flag`, Yachts.brand_name AS `Yachts__brand_name`, Yachts.length AS `Yachts__length`, Yachts.beam AS `Yachts__beam`, Yachts.bearth AS `Yachts__bearth`, Yachts.engines AS `Yachts__engines`, Yachts.engines_hp AS `Yachts__engines_hp`, Yachts.engine_hours AS `Yachts__engine_hours`, Yachts.engine_brand AS `Yachts__engine_brand`, Yachts.max_speed AS `Yachts__max_speed`, Yachts.fuel_tankage AS `Yachts__fuel_tankage`, Yachts.water_tankage AS `Yachts__water_tankage`, Yachts.naval_architect AS `Yachts__naval_architect`, Yachts.interior_designer AS `Yachts__interior_designer`, Yachts.boat_type AS `Yachts__boat_type`, Yachts.cabins AS `Yachts__cabins`, Yachts.conditions AS `Yachts__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`, Currencies.id AS `Currencies__id`, Currencies.name AS `Currencies__name`, Currencies.code AS `Currencies__code` FROM sales Sales INNER JOIN users Users ON Users.id = (Sales.user_id) LEFT JOIN agents Agents ON Agents.id = (Sales.agent_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 yachts Yachts ON Yachts.id = (Sales.yacht_id) LEFT JOIN offices Offices ON Offices.id = (Sales.office_id) LEFT JOIN currencies Currencies ON Currencies.id = (Sales.currency_id) WHERE Sales.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' => [
		'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',
		'Agents__id' => 'integer',
		'Agents.id' => 'integer',
		'Agents__name' => 'string',
		'Agents.name' => 'string',
		'Agents__firstname' => 'string',
		'Agents.firstname' => 'string',
		'Agents__photo' => 'string',
		'Agents.photo' => 'string',
		'photo' => 'string',
		'Agents__bio' => 'string',
		'Agents.bio' => 'string',
		'bio' => 'string',
		'Agents__active' => 'boolean',
		'Agents.active' => 'boolean',
		'Agents__location_id' => 'integer',
		'Agents.location_id' => 'integer',
		'Agents__user_id' => 'integer',
		'Agents.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',
		'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',
		'Yachts__id' => 'integer',
		'Yachts.id' => 'integer',
		'Yachts__flag' => 'string',
		'Yachts.flag' => 'string',
		'flag' => 'string',
		'Yachts__brand_name' => 'string',
		'Yachts.brand_name' => 'string',
		'Yachts__length' => 'string',
		'Yachts.length' => 'string',
		'length' => 'string',
		'Yachts__beam' => 'string',
		'Yachts.beam' => 'string',
		'beam' => 'string',
		'Yachts__bearth' => 'string',
		'Yachts.bearth' => 'string',
		'bearth' => 'string',
		'Yachts__engines' => 'string',
		'Yachts.engines' => 'string',
		'engines' => 'string',
		'Yachts__engines_hp' => 'string',
		'Yachts.engines_hp' => 'string',
		'engines_hp' => 'string',
		'Yachts__engine_hours' => 'string',
		'Yachts.engine_hours' => 'string',
		'engine_hours' => 'string',
		'Yachts__engine_brand' => 'string',
		'Yachts.engine_brand' => 'string',
		'engine_brand' => 'string',
		'Yachts__max_speed' => 'string',
		'Yachts.max_speed' => 'string',
		'max_speed' => 'string',
		'Yachts__fuel_tankage' => 'string',
		'Yachts.fuel_tankage' => 'string',
		'fuel_tankage' => 'string',
		'Yachts__water_tankage' => 'string',
		'Yachts.water_tankage' => 'string',
		'water_tankage' => 'string',
		'Yachts__naval_architect' => 'string',
		'Yachts.naval_architect' => 'string',
		'naval_architect' => 'string',
		'Yachts__interior_designer' => 'string',
		'Yachts.interior_designer' => 'string',
		'interior_designer' => 'string',
		'Yachts__boat_type' => 'string',
		'Yachts.boat_type' => 'string',
		'boat_type' => 'string',
		'Yachts__cabins' => 'string',
		'Yachts.cabins' => 'string',
		'cabins' => 'string',
		'Yachts__conditions' => 'string',
		'Yachts.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',
		'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',
		'Currencies__id' => 'integer',
		'Currencies.id' => 'integer',
		'Currencies__name' => 'string',
		'Currencies.name' => 'string',
		'Currencies__code' => 'string',
		'Currencies.code' => 'string',
		'code' => 'string'
	],
	'decorators' => (int) 0,
	'executed' => false,
	'hydrate' => true,
	'buffered' => true,
	'formatters' => (int) 0,
	'mapReducers' => (int) 0,
	'contain' => [
		'Users' => [[maximum depth reached]],
		'Agents' => [
			[maximum depth reached]
		],
		'Cars' => [[maximum depth reached]],
		'RealEstates' => [[maximum depth reached]],
		'Watches' => [[maximum depth reached]],
		'Yachts' => [[maximum depth reached]],
		'Pictures' => [
			[maximum depth reached]
		],
		'Offices' => [
			[maximum depth reached]
		],
		'Currencies' => [[maximum depth reached]]
	],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\SalesTable) {}

}
$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\SalesController::show() - APP/Controller/SalesController.php, line 26

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`, Agents.id AS `Agents__id`, Agents.name AS `Agents__name`, Agents.firstname AS `Agents__firstname`, Agents.photo AS `Agents__photo`, Agents.bio AS `Agents__bio`, Agents.active AS `Agents__active`, Agents.location_id AS `Agents__location_id`, Agents.user_id AS `Agents__user_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`, Yachts.id AS `Yachts__id`, Yachts.flag AS `Yachts__flag`, Yachts.brand_name AS `Yachts__brand_name`, Yachts.length AS `Yachts__length`, Yachts.beam AS `Yachts__beam`, Yachts.bearth AS `Yachts__bearth`, Yachts.engines AS `Yachts__engines`, Yachts.engines_hp AS `Yachts__engines_hp`, Yachts.engine_hours AS `Yachts__engine_hours`, Yachts.engine_brand AS `Yachts__engine_brand`, Yachts.max_speed AS `Yachts__max_speed`, Yachts.fuel_tankage AS `Yachts__fuel_tankage`, Yachts.water_tankage AS `Yachts__water_tankage`, Yachts.naval_architect AS `Yachts__naval_architect`, Yachts.interior_designer AS `Yachts__interior_designer`, Yachts.boat_type AS `Yachts__boat_type`, Yachts.cabins AS `Yachts__cabins`, Yachts.conditions AS `Yachts__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`, Currencies.id AS `Currencies__id`, Currencies.name AS `Currencies__name`, Currencies.code AS `Currencies__code` FROM sales Sales INNER JOIN users Users ON Users.id = (Sales.user_id) LEFT JOIN agents Agents ON Agents.id = (Sales.agent_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 yachts Yachts ON Yachts.id = (Sales.yacht_id) LEFT JOIN offices Offices ON Offices.id = (Sales.office_id) LEFT JOIN currencies Currencies ON Currencies.id = (Sales.currency_id) WHERE Sales.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' => [
		'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',
		'Agents__id' => 'integer',
		'Agents.id' => 'integer',
		'Agents__name' => 'string',
		'Agents.name' => 'string',
		'Agents__firstname' => 'string',
		'Agents.firstname' => 'string',
		'Agents__photo' => 'string',
		'Agents.photo' => 'string',
		'photo' => 'string',
		'Agents__bio' => 'string',
		'Agents.bio' => 'string',
		'bio' => 'string',
		'Agents__active' => 'boolean',
		'Agents.active' => 'boolean',
		'Agents__location_id' => 'integer',
		'Agents.location_id' => 'integer',
		'Agents__user_id' => 'integer',
		'Agents.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',
		'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',
		'Yachts__id' => 'integer',
		'Yachts.id' => 'integer',
		'Yachts__flag' => 'string',
		'Yachts.flag' => 'string',
		'flag' => 'string',
		'Yachts__brand_name' => 'string',
		'Yachts.brand_name' => 'string',
		'Yachts__length' => 'string',
		'Yachts.length' => 'string',
		'length' => 'string',
		'Yachts__beam' => 'string',
		'Yachts.beam' => 'string',
		'beam' => 'string',
		'Yachts__bearth' => 'string',
		'Yachts.bearth' => 'string',
		'bearth' => 'string',
		'Yachts__engines' => 'string',
		'Yachts.engines' => 'string',
		'engines' => 'string',
		'Yachts__engines_hp' => 'string',
		'Yachts.engines_hp' => 'string',
		'engines_hp' => 'string',
		'Yachts__engine_hours' => 'string',
		'Yachts.engine_hours' => 'string',
		'engine_hours' => 'string',
		'Yachts__engine_brand' => 'string',
		'Yachts.engine_brand' => 'string',
		'engine_brand' => 'string',
		'Yachts__max_speed' => 'string',
		'Yachts.max_speed' => 'string',
		'max_speed' => 'string',
		'Yachts__fuel_tankage' => 'string',
		'Yachts.fuel_tankage' => 'string',
		'fuel_tankage' => 'string',
		'Yachts__water_tankage' => 'string',
		'Yachts.water_tankage' => 'string',
		'water_tankage' => 'string',
		'Yachts__naval_architect' => 'string',
		'Yachts.naval_architect' => 'string',
		'naval_architect' => 'string',
		'Yachts__interior_designer' => 'string',
		'Yachts.interior_designer' => 'string',
		'interior_designer' => 'string',
		'Yachts__boat_type' => 'string',
		'Yachts.boat_type' => 'string',
		'boat_type' => 'string',
		'Yachts__cabins' => 'string',
		'Yachts.cabins' => 'string',
		'cabins' => 'string',
		'Yachts__conditions' => 'string',
		'Yachts.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',
		'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',
		'Currencies__id' => 'integer',
		'Currencies.id' => 'integer',
		'Currencies__name' => 'string',
		'Currencies.name' => 'string',
		'Currencies__code' => 'string',
		'Currencies.code' => 'string',
		'code' => 'string'
	],
	'decorators' => (int) 0,
	'executed' => false,
	'hydrate' => true,
	'buffered' => true,
	'formatters' => (int) 0,
	'mapReducers' => (int) 0,
	'contain' => [
		'Users' => [[maximum depth reached]],
		'Agents' => [
			[maximum depth reached]
		],
		'Cars' => [[maximum depth reached]],
		'RealEstates' => [[maximum depth reached]],
		'Watches' => [[maximum depth reached]],
		'Yachts' => [[maximum depth reached]],
		'Pictures' => [
			[maximum depth reached]
		],
		'Offices' => [
			[maximum depth reached]
		],
		'Currencies' => [[maximum depth reached]]
	],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\SalesTable) {}

}
$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\SalesController::show() - APP/Controller/SalesController.php, line 26

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 Pictures.id AS `Pictures__id`, Pictures.name AS `Pictures__name`, Pictures.rang AS `Pictures__rang`, Pictures.sale_id AS `Pictures__sale_id` FROM pictures Pictures WHERE Pictures.sale_id in (: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' => [
		'Pictures__id' => 'integer',
		'Pictures.id' => 'integer',
		'id' => 'integer',
		'Pictures__name' => 'string',
		'Pictures.name' => 'string',
		'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' => [],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\PicturesTable) {}

}
$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\Association\HasMany::_buildResultMap() - CORE/src/ORM/Association/ExternalAssociationTrait.php, line 116
Cake\ORM\Association\HasMany::eagerLoader() - CORE/src/ORM/Association/SelectableAssociationTrait.php, line 49

Warning (2): count() [<a href='http://php.net/function.count'>function.count</a>]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]
Code Context
    {
        return function ($parts, $name) use (&$sql, $query, $generator) {
            if (!count($parts)) {
$parts = null
$name = 'limit'
$sql = 'SELECT Pictures.id AS `Pictures__id`, Pictures.name AS `Pictures__name`, Pictures.rang AS `Pictures__rang`, Pictures.sale_id AS `Pictures__sale_id` FROM pictures Pictures WHERE Pictures.sale_id in (:c0) ORDER BY Pictures.rang ASC'
$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' => [
		'Pictures__id' => 'integer',
		'Pictures.id' => 'integer',
		'id' => 'integer',
		'Pictures__name' => 'string',
		'Pictures.name' => 'string',
		'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' => [],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\PicturesTable) {}

}
$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\Association\HasMany::_buildResultMap() - CORE/src/ORM/Association/ExternalAssociationTrait.php, line 116
Cake\ORM\Association\HasMany::eagerLoader() - CORE/src/ORM/Association/SelectableAssociationTrait.php, line 49

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 Pictures.id AS `Pictures__id`, Pictures.name AS `Pictures__name`, Pictures.rang AS `Pictures__rang`, Pictures.sale_id AS `Pictures__sale_id` FROM pictures Pictures WHERE Pictures.sale_id in (:c0) ORDER BY Pictures.rang ASC'
$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' => [
		'Pictures__id' => 'integer',
		'Pictures.id' => 'integer',
		'id' => 'integer',
		'Pictures__name' => 'string',
		'Pictures.name' => 'string',
		'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' => [],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\PicturesTable) {}

}
$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\Association\HasMany::_buildResultMap() - CORE/src/ORM/Association/ExternalAssociationTrait.php, line 116
Cake\ORM\Association\HasMany::eagerLoader() - CORE/src/ORM/Association/SelectableAssociationTrait.php, line 49

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 Pictures.id AS `Pictures__id`, Pictures.name AS `Pictures__name`, Pictures.rang AS `Pictures__rang`, Pictures.sale_id AS `Pictures__sale_id` FROM pictures Pictures WHERE Pictures.sale_id in (:c0) ORDER BY Pictures.rang ASC'
$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' => [
		'Pictures__id' => 'integer',
		'Pictures.id' => 'integer',
		'id' => 'integer',
		'Pictures__name' => 'string',
		'Pictures.name' => 'string',
		'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' => [],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\PicturesTable) {}

}
$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\Association\HasMany::_buildResultMap() - CORE/src/ORM/Association/ExternalAssociationTrait.php, line 116
Cake\ORM\Association\HasMany::eagerLoader() - CORE/src/ORM/Association/SelectableAssociationTrait.php, line 49

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 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 locations Locations LEFT JOIN countries Countries ON Countries.id = (Locations.country_id) WHERE Locations.id in (: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' => [
		'Locations__id' => 'integer',
		'Locations.id' => 'integer',
		'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'
	],
	'decorators' => (int) 0,
	'executed' => false,
	'hydrate' => true,
	'buffered' => true,
	'formatters' => (int) 0,
	'mapReducers' => (int) 0,
	'contain' => [
		'Countries' => [[maximum depth reached]]
	],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\LocationsTable) {}

}
$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\Association\BelongsTo::_buildResultMap() - CORE/src/ORM/Association/BelongsTo.php, line 214
Cake\ORM\Association\BelongsTo::eagerLoader() - CORE/src/ORM/Association/SelectableAssociationTrait.php, line 49

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 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 locations Locations LEFT JOIN countries Countries ON Countries.id = (Locations.country_id) WHERE Locations.id in (: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' => [
		'Locations__id' => 'integer',
		'Locations.id' => 'integer',
		'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'
	],
	'decorators' => (int) 0,
	'executed' => false,
	'hydrate' => true,
	'buffered' => true,
	'formatters' => (int) 0,
	'mapReducers' => (int) 0,
	'contain' => [
		'Countries' => [[maximum depth reached]]
	],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\LocationsTable) {}

}
$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\Association\BelongsTo::_buildResultMap() - CORE/src/ORM/Association/BelongsTo.php, line 214
Cake\ORM\Association\BelongsTo::eagerLoader() - CORE/src/ORM/Association/SelectableAssociationTrait.php, line 49

Warning (2): count() [<a href='http://php.net/function.count'>function.count</a>]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]
Code Context
    {
        return function ($parts, $name) use (&$sql, $query, $generator) {
            if (!count($parts)) {
$parts = null
$name = 'limit'
$sql = 'SELECT 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 locations Locations LEFT JOIN countries Countries ON Countries.id = (Locations.country_id) WHERE Locations.id in (: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' => [
		'Locations__id' => 'integer',
		'Locations.id' => 'integer',
		'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'
	],
	'decorators' => (int) 0,
	'executed' => false,
	'hydrate' => true,
	'buffered' => true,
	'formatters' => (int) 0,
	'mapReducers' => (int) 0,
	'contain' => [
		'Countries' => [[maximum depth reached]]
	],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\LocationsTable) {}

}
$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\Association\BelongsTo::_buildResultMap() - CORE/src/ORM/Association/BelongsTo.php, line 214
Cake\ORM\Association\BelongsTo::eagerLoader() - CORE/src/ORM/Association/SelectableAssociationTrait.php, line 49

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 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 locations Locations LEFT JOIN countries Countries ON Countries.id = (Locations.country_id) WHERE Locations.id in (: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' => [
		'Locations__id' => 'integer',
		'Locations.id' => 'integer',
		'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'
	],
	'decorators' => (int) 0,
	'executed' => false,
	'hydrate' => true,
	'buffered' => true,
	'formatters' => (int) 0,
	'mapReducers' => (int) 0,
	'contain' => [
		'Countries' => [[maximum depth reached]]
	],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\LocationsTable) {}

}
$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\Association\BelongsTo::_buildResultMap() - CORE/src/ORM/Association/BelongsTo.php, line 214
Cake\ORM\Association\BelongsTo::eagerLoader() - CORE/src/ORM/Association/SelectableAssociationTrait.php, line 49

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 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 locations Locations LEFT JOIN countries Countries ON Countries.id = (Locations.country_id) WHERE Locations.id in (: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' => [
		'Locations__id' => 'integer',
		'Locations.id' => 'integer',
		'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'
	],
	'decorators' => (int) 0,
	'executed' => false,
	'hydrate' => true,
	'buffered' => true,
	'formatters' => (int) 0,
	'mapReducers' => (int) 0,
	'contain' => [
		'Countries' => [[maximum depth reached]]
	],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\LocationsTable) {}

}
$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\Association\BelongsTo::_buildResultMap() - CORE/src/ORM/Association/BelongsTo.php, line 214
Cake\ORM\Association\BelongsTo::eagerLoader() - CORE/src/ORM/Association/SelectableAssociationTrait.php, line 49

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 = 'UPDATE sales SET views = :c0 WHERE id = :c1'
$query = object(Cake\ORM\Query) {

	'(help)' => 'This is a Query object, to get the results execute or iterate it.',
	'sql' => 'SQL could not be generated for this query as it is incomplete.',
	'params' => [],
	'defaultTypes' => [
		'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' => true,
	'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]
		]
	]
	[protected] _bindingsCount => (int) 2
}
count - [internal], line ??
Cake\Database\QueryCompiler::Cake\Database\{closure}() - CORE/src/Database/QueryCompiler.php, line 128
Cake\Database\Query::traverse() - CORE/src/Database/Query.php, line 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\Table::_update() - CORE/src/ORM/Table.php, line 1739
Cake\ORM\Table::_processSave() - CORE/src/ORM/Table.php, line 1565
Cake\ORM\Table::Cake\ORM\{closure}() - CORE/src/ORM/Table.php, line 1491
Cake\Database\Connection::transactional() - CORE/src/Database/Connection.php, line 570
Cake\ORM\Table::save() - CORE/src/ORM/Table.php, line 1492

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`, 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`, 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 sales Sales 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) INNER JOIN locations Locations ON Locations.id = (Offices.location_id) LEFT JOIN countries Countries ON Countries.id = (Locations.country_id) WHERE (Sales.validate = :c0 AND (Sales.car_id) IS NOT NULL)'
$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',
		'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',
		'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',
		'email' => 'string',
		'Offices__website' => 'string',
		'Offices.website' => 'string',
		'website' => 'string',
		'Offices__active' => 'boolean',
		'Offices.active' => 'boolean',
		'Offices__location_id' => 'integer',
		'Offices.location_id' => 'integer',
		'location_id' => 'integer',
		'Offices__user_id' => 'integer',
		'Offices.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'
	],
	'decorators' => (int) 0,
	'executed' => false,
	'hydrate' => true,
	'buffered' => true,
	'formatters' => (int) 0,
	'mapReducers' => (int) 0,
	'contain' => [
		'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]
		]
	]
	[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::toArray() - CORE/src/Datasource/QueryTrait.php, line 293
App\Controller\SalesController::show() - APP/Controller/SalesController.php, line 65

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) 6
$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`, 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`, 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 sales Sales 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) INNER JOIN locations Locations ON Locations.id = (Offices.location_id) LEFT JOIN countries Countries ON Countries.id = (Locations.country_id) WHERE (Sales.validate = :c0 AND (Sales.car_id) IS NOT NULL) ORDER BY rand()'
$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',
		'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',
		'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',
		'email' => 'string',
		'Offices__website' => 'string',
		'Offices.website' => 'string',
		'website' => 'string',
		'Offices__active' => 'boolean',
		'Offices.active' => 'boolean',
		'Offices__location_id' => 'integer',
		'Offices.location_id' => 'integer',
		'location_id' => 'integer',
		'Offices__user_id' => 'integer',
		'Offices.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'
	],
	'decorators' => (int) 0,
	'executed' => false,
	'hydrate' => true,
	'buffered' => true,
	'formatters' => (int) 0,
	'mapReducers' => (int) 0,
	'contain' => [
		'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]
		]
	]
	[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::toArray() - CORE/src/Datasource/QueryTrait.php, line 293
App\Controller\SalesController::show() - APP/Controller/SalesController.php, line 65

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 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`, 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`, 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 sales Sales 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) INNER JOIN locations Locations ON Locations.id = (Offices.location_id) LEFT JOIN countries Countries ON Countries.id = (Locations.country_id) WHERE (Sales.validate = :c0 AND (Sales.car_id) IS NOT NULL) ORDER BY rand() LIMIT 6'
$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',
		'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',
		'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',
		'email' => 'string',
		'Offices__website' => 'string',
		'Offices.website' => 'string',
		'website' => 'string',
		'Offices__active' => 'boolean',
		'Offices.active' => 'boolean',
		'Offices__location_id' => 'integer',
		'Offices.location_id' => 'integer',
		'location_id' => 'integer',
		'Offices__user_id' => 'integer',
		'Offices.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'
	],
	'decorators' => (int) 0,
	'executed' => false,
	'hydrate' => true,
	'buffered' => true,
	'formatters' => (int) 0,
	'mapReducers' => (int) 0,
	'contain' => [
		'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]
		]
	]
	[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::toArray() - CORE/src/Datasource/QueryTrait.php, line 293
App\Controller\SalesController::show() - APP/Controller/SalesController.php, line 65

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`, 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`, 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 sales Sales 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) INNER JOIN locations Locations ON Locations.id = (Offices.location_id) LEFT JOIN countries Countries ON Countries.id = (Locations.country_id) WHERE (Sales.validate = :c0 AND (Sales.car_id) IS NOT NULL) ORDER BY rand() LIMIT 6'
$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',
		'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',
		'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',
		'email' => 'string',
		'Offices__website' => 'string',
		'Offices.website' => 'string',
		'website' => 'string',
		'Offices__active' => 'boolean',
		'Offices.active' => 'boolean',
		'Offices__location_id' => 'integer',
		'Offices.location_id' => 'integer',
		'location_id' => 'integer',
		'Offices__user_id' => 'integer',
		'Offices.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'
	],
	'decorators' => (int) 0,
	'executed' => false,
	'hydrate' => true,
	'buffered' => true,
	'formatters' => (int) 0,
	'mapReducers' => (int) 0,
	'contain' => [
		'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]
		]
	]
	[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::toArray() - CORE/src/Datasource/QueryTrait.php, line 293
App\Controller\SalesController::show() - APP/Controller/SalesController.php, line 65

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 Pictures.id AS `Pictures__id`, Pictures.name AS `Pictures__name`, Pictures.rang AS `Pictures__rang`, Pictures.sale_id AS `Pictures__sale_id` FROM pictures Pictures WHERE Pictures.sale_id in (:c0,:c1,:c2,:c3,:c4,:c5)'
$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' => [
		'Pictures__id' => 'integer',
		'Pictures.id' => 'integer',
		'id' => 'integer',
		'Pictures__name' => 'string',
		'Pictures.name' => 'string',
		'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' => [],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\PicturesTable) {}

}
$generator = object(Cake\Database\ValueBinder) {
	[protected] _bindings => [
		':c0' => [
			[maximum depth reached]
		],
		':c1' => [
			[maximum depth reached]
		],
		':c2' => [
			[maximum depth reached]
		],
		':c3' => [
			[maximum depth reached]
		],
		':c4' => [
			[maximum depth reached]
		],
		':c5' => [
			[maximum depth reached]
		]
	]
	[protected] _bindingsCount => (int) 6
}
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\Association\HasMany::_buildResultMap() - CORE/src/ORM/Association/ExternalAssociationTrait.php, line 116
Cake\ORM\Association\HasMany::eagerLoader() - CORE/src/ORM/Association/SelectableAssociationTrait.php, line 49

Warning (2): count() [<a href='http://php.net/function.count'>function.count</a>]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]
Code Context
    {
        return function ($parts, $name) use (&$sql, $query, $generator) {
            if (!count($parts)) {
$parts = null
$name = 'limit'
$sql = 'SELECT Pictures.id AS `Pictures__id`, Pictures.name AS `Pictures__name`, Pictures.rang AS `Pictures__rang`, Pictures.sale_id AS `Pictures__sale_id` FROM pictures Pictures WHERE Pictures.sale_id in (:c0,:c1,:c2,:c3,:c4,:c5) ORDER BY Pictures.rang ASC'
$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' => [
		'Pictures__id' => 'integer',
		'Pictures.id' => 'integer',
		'id' => 'integer',
		'Pictures__name' => 'string',
		'Pictures.name' => 'string',
		'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' => [],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\PicturesTable) {}

}
$generator = object(Cake\Database\ValueBinder) {
	[protected] _bindings => [
		':c0' => [
			[maximum depth reached]
		],
		':c1' => [
			[maximum depth reached]
		],
		':c2' => [
			[maximum depth reached]
		],
		':c3' => [
			[maximum depth reached]
		],
		':c4' => [
			[maximum depth reached]
		],
		':c5' => [
			[maximum depth reached]
		]
	]
	[protected] _bindingsCount => (int) 6
}
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\Association\HasMany::_buildResultMap() - CORE/src/ORM/Association/ExternalAssociationTrait.php, line 116
Cake\ORM\Association\HasMany::eagerLoader() - CORE/src/ORM/Association/SelectableAssociationTrait.php, line 49

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 Pictures.id AS `Pictures__id`, Pictures.name AS `Pictures__name`, Pictures.rang AS `Pictures__rang`, Pictures.sale_id AS `Pictures__sale_id` FROM pictures Pictures WHERE Pictures.sale_id in (:c0,:c1,:c2,:c3,:c4,:c5) ORDER BY Pictures.rang ASC'
$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' => [
		'Pictures__id' => 'integer',
		'Pictures.id' => 'integer',
		'id' => 'integer',
		'Pictures__name' => 'string',
		'Pictures.name' => 'string',
		'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' => [],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\PicturesTable) {}

}
$generator = object(Cake\Database\ValueBinder) {
	[protected] _bindings => [
		':c0' => [
			[maximum depth reached]
		],
		':c1' => [
			[maximum depth reached]
		],
		':c2' => [
			[maximum depth reached]
		],
		':c3' => [
			[maximum depth reached]
		],
		':c4' => [
			[maximum depth reached]
		],
		':c5' => [
			[maximum depth reached]
		]
	]
	[protected] _bindingsCount => (int) 6
}
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\Association\HasMany::_buildResultMap() - CORE/src/ORM/Association/ExternalAssociationTrait.php, line 116
Cake\ORM\Association\HasMany::eagerLoader() - CORE/src/ORM/Association/SelectableAssociationTrait.php, line 49

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 Pictures.id AS `Pictures__id`, Pictures.name AS `Pictures__name`, Pictures.rang AS `Pictures__rang`, Pictures.sale_id AS `Pictures__sale_id` FROM pictures Pictures WHERE Pictures.sale_id in (:c0,:c1,:c2,:c3,:c4,:c5) ORDER BY Pictures.rang ASC'
$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' => [
		'Pictures__id' => 'integer',
		'Pictures.id' => 'integer',
		'id' => 'integer',
		'Pictures__name' => 'string',
		'Pictures.name' => 'string',
		'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' => [],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\PicturesTable) {}

}
$generator = object(Cake\Database\ValueBinder) {
	[protected] _bindings => [
		':c0' => [
			[maximum depth reached]
		],
		':c1' => [
			[maximum depth reached]
		],
		':c2' => [
			[maximum depth reached]
		],
		':c3' => [
			[maximum depth reached]
		],
		':c4' => [
			[maximum depth reached]
		],
		':c5' => [
			[maximum depth reached]
		]
	]
	[protected] _bindingsCount => (int) 6
}
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\Association\HasMany::_buildResultMap() - CORE/src/ORM/Association/ExternalAssociationTrait.php, line 116
Cake\ORM\Association\HasMany::eagerLoader() - CORE/src/ORM/Association/SelectableAssociationTrait.php, line 49

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

Related luxury products

McLaren W1

$ 2,100,000

Ferrari Roma

$ 195,752

Bentley Flying Spur FIRST EDITION

$ 239,800

FERRARI 488 GTB

$ 212,600

Ferrari Purosangue

$ 820,000

Mercedes-Benz G 63 AMG

$ 184,900