Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY `BrandsLanguage`.`id`' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 684]
$sql = "SELECT COUNT(*) AS `count` FROM `brands_languages` AS `BrandsLanguage` LEFT JOIN brands AS `Brand` ON (`Brand`.`id` = `BrandsLanguage`.`brand_id`) LEFT JOIN manufacturers AS `Manufacturer` ON (`Brand`.`manufacturer_id` = `Manufacturer`.`id`) LEFT JOIN manufacturer_languages AS `ManufacturerLanguage` ON (`Manufacturer`.`id` = `ManufacturerLanguage`.`manufacturer_id` AND `ManufacturerLanguage`.`language_id` = '1') LEFT JOIN brands_countries AS `BrandsCountry` ON (`Brand`.`id` = `BrandsCountry`.`brand_id`) WHERE `BrandsLanguage`.`language_id` = 1 AND `Brand`.`status` = 1 AND `Brand`.`approved_status` = 1 AND `Brand`.`season` HAVING 5 GROUP BY `BrandsLanguage`.`id` "
$error = "1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY `BrandsLanguage`.`id`' at line 1"
$out = null
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 684
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 266
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 410
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 823
Model::find() - CORE/cake/libs/model/model.php, line 2127
Controller::paginate() - CORE/cake/libs/controller/controller.php, line 1204
BrandsController::index() - APP/controllers/brands_controller.php, line 3082
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
Query: SELECT COUNT(*) AS `count` FROM `brands_languages` AS `BrandsLanguage` LEFT JOIN brands AS `Brand` ON (`Brand`.`id` = `BrandsLanguage`.`brand_id`) LEFT JOIN manufacturers AS `Manufacturer` ON (`Brand`.`manufacturer_id` = `Manufacturer`.`id`) LEFT JOIN manufacturer_languages AS `ManufacturerLanguage` ON (`Manufacturer`.`id` = `ManufacturerLanguage`.`manufacturer_id` AND `ManufacturerLanguage`.`language_id` = '1') LEFT JOIN brands_countries AS `BrandsCountry` ON (`Brand`.`id` = `BrandsCountry`.`brand_id`) WHERE `BrandsLanguage`.`language_id` = 1 AND `Brand`.`status` = 1 AND `Brand`.`approved_status` = 1 AND `Brand`.`season` HAVING 5 GROUP BY `BrandsLanguage`.`id`
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY `BrandsLanguage`.`id` ORDER BY `BrandsLanguage`.`brand_name` ASC LIMI' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 684]
$sql = "SELECT `BrandsLanguage`.`id`, `Brand`.`id`, `Brand`.`image_name`, `Brand`.`region_id`, `Brand`.`brand_no`, `BrandsLanguage`.`brand_name`, `ManufacturerLanguage`.`manufacturer_id`, `ManufacturerLanguage`.`manufacturer_name`, `BrandsLanguage`.`form` FROM `brands_languages` AS `BrandsLanguage` LEFT JOIN brands AS `Brand` ON (`Brand`.`id` = `BrandsLanguage`.`brand_id`) LEFT JOIN manufacturers AS `Manufacturer` ON (`Brand`.`manufacturer_id` = `Manufacturer`.`id`) LEFT JOIN manufacturer_languages AS `ManufacturerLanguage` ON (`Manufacturer`.`id` = `ManufacturerLanguage`.`manufacturer_id` AND `ManufacturerLanguage`.`language_id` = '1') LEFT JOIN brands_countries AS `BrandsCountry` ON (`Brand`.`id` = `BrandsCountry`.`brand_id`) WHERE `BrandsLanguage`.`language_id` = 1 AND `Brand`.`status` = 1 AND `Brand`.`approved_status` = 1 AND `Brand`.`season` HAVING 5 GROUP BY `BrandsLanguage`.`id` ORDER BY `BrandsLanguage`.`brand_name` ASC LIMIT 900000"
$error = "1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY `BrandsLanguage`.`id` ORDER BY `BrandsLanguage`.`brand_name` ASC LIMI' at line 1"
$out = null
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 684
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 266
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 410
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 823
Model::find() - CORE/cake/libs/model/model.php, line 2127
Controller::paginate() - CORE/cake/libs/controller/controller.php, line 1224
BrandsController::index() - APP/controllers/brands_controller.php, line 3082
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
Query: SELECT `BrandsLanguage`.`id`, `Brand`.`id`, `Brand`.`image_name`, `Brand`.`region_id`, `Brand`.`brand_no`, `BrandsLanguage`.`brand_name`, `ManufacturerLanguage`.`manufacturer_id`, `ManufacturerLanguage`.`manufacturer_name`, `BrandsLanguage`.`form` FROM `brands_languages` AS `BrandsLanguage` LEFT JOIN brands AS `Brand` ON (`Brand`.`id` = `BrandsLanguage`.`brand_id`) LEFT JOIN manufacturers AS `Manufacturer` ON (`Brand`.`manufacturer_id` = `Manufacturer`.`id`) LEFT JOIN manufacturer_languages AS `ManufacturerLanguage` ON (`Manufacturer`.`id` = `ManufacturerLanguage`.`manufacturer_id` AND `ManufacturerLanguage`.`language_id` = '1') LEFT JOIN brands_countries AS `BrandsCountry` ON (`Brand`.`id` = `BrandsCountry`.`brand_id`) WHERE `BrandsLanguage`.`language_id` = 1 AND `Brand`.`status` = 1 AND `Brand`.`approved_status` = 1 AND `Brand`.`season` HAVING 5 GROUP BY `BrandsLanguage`.`id` ORDER BY `BrandsLanguage`.`brand_name` ASC LIMIT 900000