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
Are You Interested about This Lamborghini Murcielago SV – 1 of 186 ?
For sale : Lamborghini Murcielago SV – 1 of 186
Model Year 2010
Mileage 2,280 KMs
Exterior Black
Interior Black
Engine 6.5L V12
Power 670 Hp
Price AED 2,750,000
Interest about this Luxury cars ?
Feel free to contact any of our staff members with questions, or business inquiries.
Our staff members are available 24 hours a day to answer your questions and serve your needs.
WELCOME TO AL AIN CLASS MOTORS
Welcome to Al Ain Class Motors, the world’s most exclusive automobile showroom.
Over 20 years experience in the exotic and luxury car business. Our mission is to provide our customers worldwide the best selection of new and pre owned vehicles available in the market.
As a car enthusiast and collector, Mr. Abdulla Al ketbi started trading luxury cars in the year 1992. He mainly started importing Mercedes Benz from Germany and selling to close relatives and friends. By 1995 the first Alain Class Motors Showroom was open in his city in Alain, U.A.E.
For over 20 years we have provided our discerning customers with exotic and luxury vehicles. Our wide selection of new and pre-owned cars include the world’s most exciting and exclusive brands.
We are renowned for our range, always maintaining 100 outstanding automobiles in stock at any given time. Our main aim is to establish long term business relationships with our customers by providing the best quality vehicles, excellent after-sale service, value for money and assistance with delivery arrangements to any port or airport worldwide.
We invite you to browse through our website for new and pre owned cars or visit us at any of our branches.
Showroom locations : Al Ain Class Motors
Alain Class Motors is owned and operated by experienced professionals with a passion for great automobiles. Our dedication to great service means the buying experience is smooth, easy and worry free.
We have 5 branches in the U.A.E.
Main Branch Dubai
Sheikh Zayed Road
Phone: +971-4-3782222
Fax: +971-4-3790337
Email: info@alainclass.com
Notice (8): Trying to get property 'country_name' of non-object [APP/Template/Sales/show.ctp, line 325]Code Context<li><?= $sale->office->location->city ?></li>
<li><?= $sale->office->location->state ?></li>
<li><?= $sale->office->location->country->country_name ?></li>
$viewFile = '/home/luxury_pulse/sites/luxury_old/www/src/Template/Sales/show.ctp' $dataForView = [ 'metaImage' => 'https://luxurypulse.com/img/pictures/6330b73c6ed1c99891.jpeg', 'sale' => object(App\Model\Entity\Sale) { 'id' => (int) 3523, 'price' => (int) 748699, 'usd_price' => (int) 748699, 'title' => 'Lamborghini Murcielago SV – 1 of 186', 'slug' => 'lamborghini-murcielago-sv-1-of-186', 'description' => '<p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Are You Interested about This <b>Lamborghini Murcielago SV – 1 of 186</b> ?</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;"><br></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">For sale : <b>Lamborghini Murcielago SV – 1 of 186</b></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Model Year <span style="font-family: "Open Sans", sans-serif, -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, sans-serif;">2010</span></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Mileage <span style="font-family: "Open Sans", sans-serif, -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, sans-serif;">2,280 KMs</span></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Exterior <span style="font-family: "Open Sans", sans-serif, -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, sans-serif;">Black</span></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Interior <span style="font-family: "Open Sans", sans-serif, -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, sans-serif;">Black</span></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Engine <span style="font-family: "Open Sans", sans-serif, -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, sans-serif;">6.5L V12</span></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Power <span style="font-family: "Open Sans", sans-serif, -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, sans-serif;">670 Hp</span></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Price <span style="font-family: "Open Sans", sans-serif, -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, sans-serif;">AED 2,750,000</span></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;"><br></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Interest about this Luxury cars ?</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;"><br></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Feel free to contact any of our staff members with questions, or business inquiries.</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Our staff members are available 24 hours a day to answer your questions and serve your needs.</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;"><br></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;"><br></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">WELCOME TO AL AIN CLASS MOTORS</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;"><br></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Welcome to Al Ain Class Motors, the world’s most exclusive automobile showroom.</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;"><br></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Over 20 years experience in the exotic and luxury car business. Our mission is to provide our customers worldwide the best selection of new and pre owned vehicles available in the market.</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;"><br></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">As a car enthusiast and collector, Mr. Abdulla Al ketbi started trading luxury cars in the year 1992. He mainly started importing Mercedes Benz from Germany and selling to close relatives and friends. By 1995 the first Alain Class Motors Showroom was open in his city in Alain, U.A.E.</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;"><br></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">For over 20 years we have provided our discerning customers with exotic and luxury vehicles. Our wide selection of new and pre-owned cars include the world’s most exciting and exclusive brands.</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;"><br></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">We are renowned for our range, always maintaining 100 outstanding automobiles in stock at any given time. Our main aim is to establish long term business relationships with our customers by providing the best quality vehicles, excellent after-sale service, value for money and assistance with delivery arrangements to any port or airport worldwide.</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;"><br></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">We invite you to browse through our website for new and pre owned cars or visit us at any of our branches.</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;"><br></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Showroom locations : Al Ain Class Motors</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Alain Class Motors is owned and operated by experienced professionals with a passion for great automobiles. Our dedication to great service means the buying experience is smooth, easy and worry free.</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;"><br></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">We have 5 branches in the U.A.E.</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;"><br></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Main Branch Dubai</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Sheikh Zayed Road</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Phone: +971-4-3782222</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Fax: +971-4-3790337</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Email: info@alainclass.com</p>', 'year' => '2010', 'location' => 'United Arab Emirates', 'adress' => null, 'internal_reference' => '', 'validate' => true, 'active' => true, 'views' => (int) 1579, 'created' => object(Cake\I18n\FrozenTime) {}, 'currency_id' => (int) 2, 'car_id' => (int) 3286, 'real_estate_id' => null, 'watche_id' => null, 'yacht_id' => null, 'office_id' => (int) 9, 'agent_id' => null, 'user_id' => (int) 2, 'currency' => object(Cake\ORM\Entity) {}, 'office' => object(App\Model\Entity\Office) {}, 'pictures' => [ [maximum depth reached] ], 'yacht' => null, 'watch' => null, 'real_estate' => null, 'car' => object(App\Model\Entity\Car) {}, 'agent' => null, 'user' => object(App\Model\Entity\User) {}, 'modified' => object(Cake\I18n\Time) {}, '[new]' => false, '[accessible]' => [ [maximum depth reached] ], '[dirty]' => [[maximum depth reached]], '[original]' => [[maximum depth reached]], '[virtual]' => [[maximum depth reached]], '[errors]' => [[maximum depth reached]], '[invalid]' => [[maximum depth reached]], '[repository]' => 'Sales' }, 'selectedSales' => [ (int) 0 => object(App\Model\Entity\Sale) {}, (int) 1 => object(App\Model\Entity\Sale) {}, (int) 2 => object(App\Model\Entity\Sale) {}, (int) 3 => object(App\Model\Entity\Sale) {}, (int) 4 => object(App\Model\Entity\Sale) {}, (int) 5 => object(App\Model\Entity\Sale) {} ] ] $metaImage = 'https://luxurypulse.com/img/pictures/6330b73c6ed1c99891.jpeg' $sale = object(App\Model\Entity\Sale) { 'id' => (int) 3523, 'price' => (int) 748699, 'usd_price' => (int) 748699, 'title' => 'Lamborghini Murcielago SV – 1 of 186', 'slug' => 'lamborghini-murcielago-sv-1-of-186', 'description' => '<p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Are You Interested about This <b>Lamborghini Murcielago SV – 1 of 186</b> ?</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;"><br></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">For sale : <b>Lamborghini Murcielago SV – 1 of 186</b></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Model Year <span style="font-family: "Open Sans", sans-serif, -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, sans-serif;">2010</span></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Mileage <span style="font-family: "Open Sans", sans-serif, -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, sans-serif;">2,280 KMs</span></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Exterior <span style="font-family: "Open Sans", sans-serif, -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, sans-serif;">Black</span></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Interior <span style="font-family: "Open Sans", sans-serif, -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, sans-serif;">Black</span></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Engine <span style="font-family: "Open Sans", sans-serif, -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, sans-serif;">6.5L V12</span></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Power <span style="font-family: "Open Sans", sans-serif, -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, sans-serif;">670 Hp</span></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Price <span style="font-family: "Open Sans", sans-serif, -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, sans-serif;">AED 2,750,000</span></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;"><br></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Interest about this Luxury cars ?</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;"><br></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Feel free to contact any of our staff members with questions, or business inquiries.</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Our staff members are available 24 hours a day to answer your questions and serve your needs.</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;"><br></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;"><br></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">WELCOME TO AL AIN CLASS MOTORS</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;"><br></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Welcome to Al Ain Class Motors, the world’s most exclusive automobile showroom.</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;"><br></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Over 20 years experience in the exotic and luxury car business. Our mission is to provide our customers worldwide the best selection of new and pre owned vehicles available in the market.</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;"><br></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">As a car enthusiast and collector, Mr. Abdulla Al ketbi started trading luxury cars in the year 1992. He mainly started importing Mercedes Benz from Germany and selling to close relatives and friends. By 1995 the first Alain Class Motors Showroom was open in his city in Alain, U.A.E.</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;"><br></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">For over 20 years we have provided our discerning customers with exotic and luxury vehicles. Our wide selection of new and pre-owned cars include the world’s most exciting and exclusive brands.</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;"><br></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">We are renowned for our range, always maintaining 100 outstanding automobiles in stock at any given time. Our main aim is to establish long term business relationships with our customers by providing the best quality vehicles, excellent after-sale service, value for money and assistance with delivery arrangements to any port or airport worldwide.</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;"><br></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">We invite you to browse through our website for new and pre owned cars or visit us at any of our branches.</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;"><br></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Showroom locations : Al Ain Class Motors</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Alain Class Motors is owned and operated by experienced professionals with a passion for great automobiles. Our dedication to great service means the buying experience is smooth, easy and worry free.</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;"><br></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">We have 5 branches in the U.A.E.</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;"><br></p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Main Branch Dubai</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Sheikh Zayed Road</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Phone: +971-4-3782222</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Fax: +971-4-3790337</p><p lang="en-US" style="text-align: center; margin-bottom: 0cm; font-size: medium;">Email: info@alainclass.com</p>', 'year' => '2010', 'location' => 'United Arab Emirates', 'adress' => null, 'internal_reference' => '', 'validate' => true, 'active' => true, 'views' => (int) 1579, 'created' => object(Cake\I18n\FrozenTime) {}, 'currency_id' => (int) 2, 'car_id' => (int) 3286, 'real_estate_id' => null, 'watche_id' => null, 'yacht_id' => null, 'office_id' => (int) 9, 'agent_id' => null, 'user_id' => (int) 2, 'currency' => object(Cake\ORM\Entity) {}, 'office' => object(App\Model\Entity\Office) {}, 'pictures' => [ (int) 0 => object(App\Model\Entity\Picture) {}, (int) 1 => object(App\Model\Entity\Picture) {}, (int) 2 => object(App\Model\Entity\Picture) {}, (int) 3 => object(App\Model\Entity\Picture) {}, (int) 4 => object(App\Model\Entity\Picture) {}, (int) 5 => object(App\Model\Entity\Picture) {}, (int) 6 => object(App\Model\Entity\Picture) {}, (int) 7 => object(App\Model\Entity\Picture) {}, (int) 8 => object(App\Model\Entity\Picture) {}, (int) 9 => object(App\Model\Entity\Picture) {}, (int) 10 => object(App\Model\Entity\Picture) {}, (int) 11 => object(App\Model\Entity\Picture) {}, (int) 12 => object(App\Model\Entity\Picture) {}, (int) 13 => object(App\Model\Entity\Picture) {}, (int) 14 => object(App\Model\Entity\Picture) {}, (int) 15 => object(App\Model\Entity\Picture) {}, (int) 16 => object(App\Model\Entity\Picture) {}, (int) 17 => object(App\Model\Entity\Picture) {}, (int) 18 => object(App\Model\Entity\Picture) {}, (int) 19 => object(App\Model\Entity\Picture) {} ], 'yacht' => null, 'watch' => null, 'real_estate' => null, 'car' => object(App\Model\Entity\Car) {}, 'agent' => null, 'user' => object(App\Model\Entity\User) {}, 'modified' => object(Cake\I18n\Time) {}, '[new]' => false, '[accessible]' => [ '*' => true ], '[dirty]' => [], '[original]' => [], '[virtual]' => [], '[errors]' => [], '[invalid]' => [], '[repository]' => 'Sales' } $selectedSales = [ (int) 0 => object(App\Model\Entity\Sale) { 'id' => (int) 4704, 'price' => (int) 1006235, 'usd_price' => (int) 1006235, 'title' => 'Ferrari 812 GTS by NOVITEC N-LARGO S', 'slug' => 'ferrari-812-gts-by-novitec-n-largo-s', 'description' => '<p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">Are you interested about this<b> Novitec Ferrari 812 N-Largo S<o:p></o:p></b></span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">For sale: <b>2023</b> <b>Ferrari 812 GTS by NOVITEC N-LARGO S<o:p></o:p></b></span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><b><span lang="EN-US"> </span></b></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">Interest about this <b>Novitec 812 N-Largo S</b>?<b><o:p></o:p></b></span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">Feel free to contact any of our staff members with questions, or business inquiries.<o:p></o:p></span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">Our staff members are available 24 hours a day to answer your questions and serve your needs.<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">Price: €1,130,500.00 Gross<o:p></o:p></span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">€950,000.00 Net (Export)<o:p></o:p></span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">Description of the car:<o:p></o:p></span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">Limited Edition 1 of 3: NOVITEC N-LARGO S Ferrari 812 GTS<o:p></o:p></span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">Introducing the extraordinary NOVITEC N-LARGO S, a limited edition transformation of the Ferrari 812 GTS. This unique masterpiece features a striking Grigio Silverstone exterior and an interior finished with NOVITEC Royal Blue & White upholstery. It rides on exclusive NOVITEC NF10 ZV Hightech Vossen Wheels.<o:p></o:p></span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">Key Features and Options:<o:p></o:p></span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">Performance and Style: The NOVITEC N-LARGO S conversion is a limited edition, with only three available worldwide. It includes an extensive list of carbon fiber enhancements, including front and rear bumpers, side skirts, and more.<o:p></o:p></span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">Custom Wheels: The vehicle comes with a set of forged wheels, type NF10 NL, giving it a distinct appearance. It also features a performance-optimized exhaust system made of stainless steel for improved sound and reduced weight.<o:p></o:p></span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">Interior Customization: The interior is meticulously customized with fine-leather trim in Royal Blue with white accents. The dashboard, middle console, armrest, and steering wheel feature unique blue and white inserts, creating a luxurious and personalized atmosphere.<o:p></o:p></span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">Additional Options: The car includes a range of Ferrari and NOVITEC options, such as adaptive headlights, carbon fiber accents, racing seats, Scuderia Ferrari shields, a parking camera, and a high-power hi-fi system.<o:p></o:p></span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">Worldwide Delivery and Financing:<o:p></o:p></span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">This exceptional vehicle is available for worldwide delivery, and financing can be arranged through partner banks. Visits are by appointment only, and the provided images are for illustration purposes.<o:p></o:p></span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">Disclaimer:<o:p></o:p></span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">Please note that the information provided is accurate to the best of our knowledge at the time of posting. We encourage any corrections or additional information. While we advertise in good faith, we do not guarantee the accuracy of the details and assume no liability for errors or omissions.<o:p></o:p></span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US"> </span></p><p class="MsoNormal" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US"> </span></p><p class="MsoNormal" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><b><span lang="EN-US"> </span></b></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><b><span lang="EN-US">Hollmann International GmbH & Co. KG<o:p></o:p></span></b></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><b><span lang="EN-US"> </span></b></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><b><span lang="EN-US">Charlotte-Auerbach-Str. 4<o:p></o:p></span></b></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><b><span lang="EN-US">28816 Stuhr<o:p></o:p></span></b></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><b><span lang="EN-US">Germany<o:p></o:p></span></b></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><b><span lang="EN-US"> </span></b></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><b><span lang="EN-US">+49 421 80608210<o:p></o:p></span></b></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><b><span lang="EN-US">info@hollmann.international<o:p></o:p></span></b></p>', 'year' => '2023', 'location' => 'Germany', 'adress' => null, 'internal_reference' => '', 'validate' => true, 'active' => true, 'views' => (int) 3986, 'created' => object(Cake\I18n\FrozenTime) {}, 'currency_id' => (int) 2, 'car_id' => (int) 4465, 'real_estate_id' => null, 'watche_id' => null, 'yacht_id' => null, 'office_id' => (int) 8, 'agent_id' => null, 'user_id' => (int) 2, 'office' => object(App\Model\Entity\Office) {}, 'pictures' => [ [maximum depth reached] ], 'watch' => null, 'real_estate' => null, 'car' => object(App\Model\Entity\Car) {}, '[new]' => false, '[accessible]' => [ [maximum depth reached] ], '[dirty]' => [[maximum depth reached]], '[original]' => [[maximum depth reached]], '[virtual]' => [[maximum depth reached]], '[errors]' => [[maximum depth reached]], '[invalid]' => [[maximum depth reached]], '[repository]' => 'Sales' }, (int) 1 => object(App\Model\Entity\Sale) { 'id' => (int) 4646, 'price' => (int) 4199500, 'usd_price' => (int) 4199500, 'title' => 'Bugatti Chiron Sport', 'slug' => 'bugatti-chiron-sport', 'description' => '<p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">Are you interested about this<b> Bugatti Chiron Sport</b>?<b><o:p></o:p></b></span></p><p class="MsoNormal" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">For sale: <b>2020 Bugatti Chiron Sport<o:p></o:p></b></span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><b><span lang="EN-US"> </span></b></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">Interest about this <b>Chiron Sport</b>?<b><o:p></o:p></b></span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">Feel free to contact any of our staff members with questions, or business inquiries.<o:p></o:p></span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">Our staff members are available 24 hours a day to answer your questions and serve your needs.<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">Price: $4,199,500<o:p></o:p></span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US"> </span></p><p class="MsoNormal" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">Description of the car:<o:p></o:p></span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">2020 Bugatti Chiron Sport Black Clean CARFAX. CARFAX One-Owner. Automatic **LOW MILES**, **MOONROOF / SUNROOF**, **NAVIGATION**, **STILL UNDER FACTORY WARRANTY**.<o:p></o:p></span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">Recent Arrival!<b><o:p></o:p></b></span></p><p class="MsoNormal" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><b><span lang="EN-US"> </span></b></p><p class="MsoNormal" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><b><span lang="EN-US"> </span></b></p><p class="MsoNormal" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><b><span lang="EN-US"> </span></b></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><b><span lang="EN-US">Lamborghini Broward<o:p></o:p></span></b></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><b><span lang="EN-US"> </span></b></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><b><span lang="EN-US">4645 Volunteer Rd - Davie, FL 33330<o:p></o:p></span></b></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><b><span lang="EN-US"> </span></b></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><b><span lang="EN-US">(954) 618-0150<o:p></o:p></span></b></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><b><span lang="EN-US">sales@lbc.edealerhub.com<o:p></o:p></span></b></p>', 'year' => '2020', 'location' => 'United States', 'adress' => null, 'internal_reference' => '', 'validate' => true, 'active' => true, 'views' => (int) 2353, 'created' => object(Cake\I18n\FrozenTime) {}, 'currency_id' => (int) 2, 'car_id' => (int) 4407, 'real_estate_id' => null, 'watche_id' => null, 'yacht_id' => null, 'office_id' => (int) 122, 'agent_id' => null, 'user_id' => (int) 6, 'office' => object(App\Model\Entity\Office) {}, 'pictures' => [ [maximum depth reached] ], 'watch' => null, 'real_estate' => null, 'car' => object(App\Model\Entity\Car) {}, '[new]' => false, '[accessible]' => [ [maximum depth reached] ], '[dirty]' => [[maximum depth reached]], '[original]' => [[maximum depth reached]], '[virtual]' => [[maximum depth reached]], '[errors]' => [[maximum depth reached]], '[invalid]' => [[maximum depth reached]], '[repository]' => 'Sales' }, (int) 2 => object(App\Model\Entity\Sale) { 'id' => (int) 343, 'price' => (int) 159849, 'usd_price' => (int) 178248, 'title' => 'Mercedes-Maybach S 560 4M', 'slug' => 'mercedes-maybach-s-560-4m', 'description' => '<p>Mercedes-Maybach S 560 4M Marketed by <a href="https://www.luxurycarshamburg.de/fahrzeuge/mercedes-benz-s-560-maybach-4m-2019-white-beige-4-seats-vip/" target="_blank"><b>Luxury Cars Hamburg</b></a></p><p><br></p><p><b>Luxury Pulse, the best Luxury Marketplace for sale and buy your Luxury Car, Yacht, Jet, Villa, Real Estate, Watches ... !</b><br></p><p><br></p>', 'year' => '2019', 'location' => 'Germany', 'adress' => null, 'internal_reference' => '', 'validate' => true, 'active' => true, 'views' => (int) 2932, 'created' => object(Cake\I18n\FrozenTime) {}, 'currency_id' => (int) 1, 'car_id' => (int) 207, 'real_estate_id' => null, 'watche_id' => null, 'yacht_id' => null, 'office_id' => (int) 2, 'agent_id' => null, 'user_id' => (int) 2, 'office' => object(App\Model\Entity\Office) {}, 'pictures' => [ [maximum depth reached] ], 'watch' => null, 'real_estate' => null, 'car' => object(App\Model\Entity\Car) {}, '[new]' => false, '[accessible]' => [ [maximum depth reached] ], '[dirty]' => [[maximum depth reached]], '[original]' => [[maximum depth reached]], '[virtual]' => [[maximum depth reached]], '[errors]' => [[maximum depth reached]], '[invalid]' => [[maximum depth reached]], '[repository]' => 'Sales' }, (int) 3 => object(App\Model\Entity\Sale) { 'id' => (int) 1425, 'price' => (int) 235036, 'usd_price' => (int) 235036, 'title' => 'For sale : Ferrari 488 Spider', 'slug' => 'for-sale-ferrari-488-spider', 'description' => '<p class="MsoNormal" style="text-align: center; margin: 0cm 0cm 0.0001pt;">Are You Interested About this Ferrari ?<o:p></o:p></p><p class="MsoNormal" style="text-align: center; margin: 0cm 0cm 0.0001pt;"><o:p> </o:p><span style="font-family: Calibri, sans-serif; font-size: 12pt;">Interest about this luxury cars ? </span></p><p class="MsoNormal" style="margin: 0cm; font-size: 12pt; text-align: center; font-family: Calibri, sans-serif;"><span lang="EN-US">Feel free to contact any of our staff members with questions, or business inquiries.<o:p></o:p></span></p><p class="MsoNormal" style="box-sizing: border-box; margin: 0cm; font-size: 12pt; text-align: center; color: rgb(127, 127, 127); font-family: Calibri, sans-serif;"><br></p><p class="MsoNormal" style="margin: 0cm; font-size: 12pt; text-align: center; font-family: Calibri, sans-serif;"><span lang="EN-US">Our staff members are available 24 hours a day to answer your questions and serve your needs.</span></p><p class="MsoNormal" style="text-align: center; margin: 0cm 0cm 0.0001pt;">Our vehicle experts are standing by to answer any questions:<o:p></o:p></p><p class="MsoNormal" style="text-align: center; margin: 0cm 0cm 0.0001pt;"><o:p> </o:p></p><p class="MsoNormal" style="text-align: center; margin: 0cm 0cm 0.0001pt;"> <o:p></o:p></p><p class="MsoNormal" style="text-align: center; margin: 0cm 0cm 0.0001pt;"><o:p> </o:p></p><p class="MsoNormal" style="text-align: center; margin: 0cm 0cm 0.0001pt;">Contact Info<o:p></o:p></p><p class="MsoNormal" style="text-align: center; margin: 0cm 0cm 0.0001pt;"><o:p> </o:p></p><p class="MsoNormal" style="text-align: center; margin: 0cm 0cm 0.0001pt;">Feel free to contact any of our staff members with questions, or business inquiries.<o:p></o:p></p><p class="MsoNormal" style="text-align: center; margin: 0cm 0cm 0.0001pt;"><o:p> </o:p></p><p class="MsoNormal" style="text-align: center; margin: 0cm 0cm 0.0001pt;">Our staff members are available 24 hours a day to answer your questions and serve your needs.<o:p></o:p></p><p class="MsoNormal" style="text-align: center; margin: 0cm 0cm 0.0001pt;"><o:p> </o:p></p><p class="MsoNormal" style="text-align: center; margin: 0cm 0cm 0.0001pt;">Tel: 0333 240 8815<o:p></o:p></p><p class="MsoNormal" style="text-align: center; margin: 0cm 0cm 0.0001pt;"><o:p> </o:p></p><p class="MsoNormal" style="text-align: center; margin: 0cm 0cm 0.0001pt;">The 488 Spider, Ferrari’s most powerful ever mid-rear-engine V8 car to feature the patented retractable hard top along with the highest level of technological innovation and with cutting-edge design. Its performance levels are nothing short of extraordinary: a maximum power output of 670 CV combined with maximum torque of 760 Nm at 3000 rpm send the 488 Spider sprinting from 0 to 100 km/h in 3 seconds flat. In the cabin, the seamless integration of the new satellite control clusters, angled air vents and instrument panel heightens the sense that the cockpit is completely tailored around the driver. Complimentary 7 Year routine maintenance programme for the first 7 years of the life of the car.<font face="Calibri, sans-serif"><span style="font-size: 12pt;"><o:p></o:p></span></font></p>', 'year' => '2019', 'location' => 'United Kingdom', 'adress' => null, 'internal_reference' => '', 'validate' => true, 'active' => true, 'views' => (int) 2092, 'created' => object(Cake\I18n\FrozenTime) {}, 'currency_id' => (int) 1, 'car_id' => (int) 1216, 'real_estate_id' => null, 'watche_id' => null, 'yacht_id' => null, 'office_id' => (int) 60, 'agent_id' => null, 'user_id' => (int) 2, 'office' => object(App\Model\Entity\Office) {}, 'pictures' => [ [maximum depth reached] ], 'watch' => null, 'real_estate' => null, 'car' => object(App\Model\Entity\Car) {}, '[new]' => false, '[accessible]' => [ [maximum depth reached] ], '[dirty]' => [[maximum depth reached]], '[original]' => [[maximum depth reached]], '[virtual]' => [[maximum depth reached]], '[errors]' => [[maximum depth reached]], '[invalid]' => [[maximum depth reached]], '[repository]' => 'Sales' }, (int) 4 => object(App\Model\Entity\Sale) { 'id' => (int) 1538, 'price' => (int) 465000, 'usd_price' => (int) 465000, 'title' => 'Rolls-Royce Cullinan by NOVITEC', 'slug' => 'rolls-royce-cullinan-by-novitec', 'description' => '<p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">Are You Interested about This Rolls-Royce Cullinan by NOVITEC ?<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US"> <o:p></o:p></span><span style="font-size: 12pt;">Our vehicle experts are standing by to answer any questions:</span></p><p class="MsoNormal" style="margin: 0cm; font-size: 12pt; text-align: center; font-family: Calibri, sans-serif;"><span lang="EN-US">Contact Info<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0cm; font-size: 12pt; text-align: center; font-family: Calibri, sans-serif;"><span lang="EN-US">Feel free to contact any of our staff members with questions, or business inquiries.<o:p></o:p></span></p><p class="MsoNormal" style="box-sizing: border-box; margin: 0cm; font-size: 12pt; text-align: center; color: rgb(127, 127, 127); font-family: Calibri, sans-serif;">Contact our luxury concierge<br></p><p class="MsoNormal" style="margin: 0cm; font-size: 12pt; text-align: center; font-family: Calibri, sans-serif;"><span lang="EN-US">Our staff members are available 24 hours a day to answer your questions and serve your needs.</span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US"> </span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">ONLY FOR EXPORT // NUR FÜR EXPORT<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">Gesamtpreis, MwSt nicht ausweisbar<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US"> </span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US"> </span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">NEW ROLLS ROYCE CULLINAN by NOVITEC OVERDOSE<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US"> </span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US"> </span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">Color: Jubilee Silver + Gunmetal Duo Tone<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">Upholstery: Ardent Red LL1<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">Veneer: Open Pore Blackwood RUU<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US"> </span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US"> </span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">OPTIONS:<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US"> </span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">402 + Panorama Glass Sunroof<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">RPE + Rolls Royce Bespoke Audio<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">RA1 + Picnic Tables<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">Z9C + Spirit of Ecstasy<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">L2R + Boot Preparation<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">4T7 + Front Massage Seats<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">5AS + Driving Assistant<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">420 + Rear Privacy Glass<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">319 + Universal Garage Door Opener<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">Z9B + Lounge Seat<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">RL3 + Coloured Steering Wheel<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">RAE + Extended Leather Headliner<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">LAN + RR Monogram to all Headrests<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">RA4 + Enhanced Clock Face<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">LLM + Mono Interior Scheme<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">LAV + Instrument Panel with Top Stitch<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">LAS + Coloured Stitching<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">LAP + Contrast Seat Piping<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">453 + Front Ventilated Seats<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">LM9 + Carpet Floor Mats<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">LM3 + Console Lids In Ardent Red<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">LM8 + Seatbelts In Grenadine<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">RM3 + Chrome Plated Visible Exhausts<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">LFC + Wheel Centres Matched to Wheel<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">RBY + Automatic Door Close<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">RLB + Loading Assistant<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">L0E + Signature Key in Dark Spice<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">5AC + High Beam Assistance<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">610 + Head Up Display<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">6AE + Teleservices<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">6CP + Apple CarPlay<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US"> </span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US"> </span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">NOVITEC Aerodynamic OVERDOSE<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">NOVITEC Engine performance 504kW (685 hp) / 5.400 rpm<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">NOVITEC Exhaust power-optimized exhaust<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">NOVITEC SWITCHTRONIC<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">NOVITEC Sports suspension<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">NOVITEC Forged SPOFEC 24 inch Wheels<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">NOVITEC Special Painting of all chrom parts<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">NOVITEC Duo tone Painting<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US"> </span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">Our vehicle experts are standing by to answer any questions:<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">Contact Info<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">Feel free to contact any of our staff members with questions, or business inquiries.<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US"> <o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">Our staff members are available 24 hours a day to answer your questions and serve your needs.<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US" style="font-family: "MS Gothic";"> </span><span lang="EN-US"><o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US" style="font-family: "MS Gothic";"> </span><span lang="EN-US"><o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">For more details, call us now :<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">Charlotte-Auerbach-Str. 4<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">28816 Stuhr<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">Germany<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US"> <o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US">+49 421 80608210<o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US"> <o:p></o:p></span></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;">info@hollmann.international<o:p></o:p></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"> <o:p></o:p></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;">Business Hours<o:p></o:p></p><p class="MsoNormal" style="text-align: center; margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;">Mon.-Fri.: 9:00 AM - 6:30 PM<o:p></o:p></p>', 'year' => '2020', 'location' => 'Germany', 'adress' => null, 'internal_reference' => '', 'validate' => true, 'active' => true, 'views' => (int) 16243, 'created' => object(Cake\I18n\FrozenTime) {}, 'currency_id' => (int) 1, 'car_id' => (int) 1329, 'real_estate_id' => null, 'watche_id' => null, 'yacht_id' => null, 'office_id' => (int) 8, 'agent_id' => null, 'user_id' => (int) 2, 'office' => object(App\Model\Entity\Office) {}, 'pictures' => [ [maximum depth reached] ], 'watch' => null, 'real_estate' => null, 'car' => object(App\Model\Entity\Car) {}, '[new]' => false, '[accessible]' => [ [maximum depth reached] ], '[dirty]' => [[maximum depth reached]], '[original]' => [[maximum depth reached]], '[virtual]' => [[maximum depth reached]], '[errors]' => [[maximum depth reached]], '[invalid]' => [[maximum depth reached]], '[repository]' => 'Sales' }, (int) 5 => object(App\Model\Entity\Sale) { 'id' => (int) 2550, 'price' => (int) 399995, 'usd_price' => (int) 399995, 'title' => 'Aston Martin DBS Superleggera', 'slug' => 'aston-martin-dbs-superleggera', 'description' => '<p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">Are you interested about this<b> Aston Martin DBS Superleggera </b>?<b><o:p></o:p></b></span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">For sale : <b>2021 Aston Martin DBS Superleggera 2-Door Convertible<o:p></o:p></b></span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">Interest about this <b>Aston Martin DBS Superleggera </b>?<b><o:p></o:p></b></span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">Feel free to contact any of our staff members with questions, or business inquiries.<o:p></o:p></span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">Our staff members are available 24 hours a day to answer your questions and serve your needs.<o:p></o:p></span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">Price: $399,995<o:p></o:p></span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><span lang="EN-US">Onyx Black Exterior with Obsidian Black Leather and Spicy Red Leather. 5.2L V12 Twin Turbo, 715hp and an 8 Speed Automatic Transmission. Optional Equipment Includes: Power Seat Bolsters, Bang & Olufsen BeoSound Audio, Bodypack - Carbon Tinted Gloss Black, Brake Calipers in Red, Ventilated Front Seats, Contemporary Leather Optional Color, Contemporary Extra Cost Exterior Paint, Gloss Black Exterior Badge Package, Aston Martin Wings Embroidery on Headrest, Leather Headling, Optional Geode Quilt, Heated Steering Wheel, Smoked Rear Taillights, Optional Duotone, Convertible Wind Deflector, Ten Twin Spoke Gloss Black Wheels. - Options: HEATED & VENTILATED SEATS, CONTEMPORARY PAINT, ASTON MARTIN WINGS EMBOSSED SEAT DETAILING, Q-GEODE QUILTING, BANG & OLUFSEN BEOSOUND INFOTAINMENT SYSTEM, GT HEATED STEERING WHEEL, SMOKED TAIL LIGHTS, RED PAINTED BRAKE CALIPERS, ASTON MARTIN BLACK BADGES, DUOTONE SPLIT LEATHER, POWERED SEAT BOLSTER ADJUSTMENT, GAS GUZZLER TAX, ONYX BLACK, WHEELS: 21 GLOSS BLACK DIAMOND TURNED FORGED<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US"> </span></p><p class="MsoNormal" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US"> </span></p><p class="MsoNormal" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;"><span lang="EN-US"> </span></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><b><span lang="EN-US">Naples Motorsports, Inc.<o:p></o:p></span></b></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><b><span lang="EN-US">1250 Airport Pulling Road South<o:p></o:p></span></b></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><b><span lang="EN-US">Naples, FL 34104<o:p></o:p></span></b></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><b><span lang="EN-US"> </span></b></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><b><span lang="EN-US">(239) 356-1885 <o:p></o:p></span></b></p><p class="MsoNormal" align="center" style="margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif; text-align: center;"><b><span lang="EN-US">nms@naplesmotorsports.com<o:p></o:p></span></b></p>', 'year' => '2021', 'location' => 'United States', 'adress' => null, 'internal_reference' => '22-T02459', 'validate' => true, 'active' => true, 'views' => (int) 1193, 'created' => object(Cake\I18n\FrozenTime) {}, 'currency_id' => (int) 2, 'car_id' => (int) 2317, 'real_estate_id' => null, 'watche_id' => null, 'yacht_id' => null, 'office_id' => (int) 57, 'agent_id' => null, 'user_id' => (int) 2, 'office' => object(App\Model\Entity\Office) {}, 'pictures' => [ [maximum depth reached] ], 'watch' => null, 'real_estate' => null, 'car' => object(App\Model\Entity\Car) {}, '[new]' => false, '[accessible]' => [ [maximum depth reached] ], '[dirty]' => [[maximum depth reached]], '[original]' => [[maximum depth reached]], '[virtual]' => [[maximum depth reached]], '[errors]' => [[maximum depth reached]], '[invalid]' => [[maximum depth reached]], '[repository]' => 'Sales' } ] $picture = object(App\Model\Entity\Picture) { 'id' => (int) 63714, 'name' => '6330b73cc5eb1786-1.jpeg', 'rang' => (int) 20, 'sale_id' => (int) 3523, '[new]' => false, '[accessible]' => [ '*' => true ], '[dirty]' => [], '[original]' => [], '[virtual]' => [], '[errors]' => [], '[invalid]' => [], '[repository]' => 'Pictures' }include - APP/Template/Sales/show.ctp, line 325 Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1014 Cake\View\View::_render() - CORE/src/View/View.php, line 973 Cake\View\View::render() - CORE/src/View/View.php, line 597 Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 617 Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 127 Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 95 Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 83 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Routing\Middleware\RoutingMiddleware::__invoke() - CORE/src/Routing/Middleware/RoutingMiddleware.php, line 62 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Routing\Middleware\AssetMiddleware::__invoke() - CORE/src/Routing/Middleware/AssetMiddleware.php, line 88 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Error\Middleware\ErrorHandlerMiddleware::__invoke() - CORE/src/Error/Middleware/ErrorHandlerMiddleware.php, line 81 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Http\Runner::run() - CORE/src/Http/Runner.php, line 51 Cake\Http\Server::run() - CORE/src/Http/Server.php, line 90
Send your message to Al Ain Class Motors | The Premier Luxury Car Showroom in UAE