Query: SELECT COUNT(*) AS `count` FROM `adverteers` AS `Adverteer` LEFT JOIN `categories` AS `Category` ON (`Adverteer`.`category_id` = `Category`.`id`) LEFT JOIN `reasons` AS `Reason` ON (`Adverteer`.`reason_id` = `Reason`.`id`) LEFT JOIN `users` AS `User` ON (`Adverteer`.`user_id` = `User`.`id`) LEFT JOIN `regio` AS `Regio` ON (`Adverteer`.`regio_id` = `Regio`.`id`) WHERE `Adverteer`.`activado` = 1 and `Adverteer`.`user_status` = 1 and `Adverteer`.`featured_category` = 1 and `Adverteer`.`category_id` in )
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 ')' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 501]
$sql = "SELECT COUNT(*) AS `count` FROM `adverteers` AS `Adverteer` LEFT JOIN `categories` AS `Category` ON (`Adverteer`.`category_id` = `Category`.`id`) LEFT JOIN `reasons` AS `Reason` ON (`Adverteer`.`reason_id` = `Reason`.`id`) LEFT JOIN `users` AS `User` ON (`Adverteer`.`user_id` = `User`.`id`) LEFT JOIN `regio` AS `Regio` ON (`Adverteer`.`regio_id` = `Regio`.`id`) WHERE `Adverteer`.`activado` = 1 and `Adverteer`.`user_status` = 1 and `Adverteer`.`featured_category` = 1 and `Adverteer`.`category_id` in ) "
$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 ')' at line 1"
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 501
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 202
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 338
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 616
Model::find() - CORE/cake/libs/model/model.php, line 1785
Controller::paginate() - CORE/cake/libs/controller/controller.php, line 998
CerebroController::category() - APP/controllers/cerebro_controller.php, line 1570
Object::dispatchMethod() - CORE/cake/libs/object.php, line 116
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 261
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 233
[main] - APP/webroot/index.php, line 85
Query: SELECT `Adverteer`.`id`, `Adverteer`.`user_id`, `Adverteer`.`category_id`, `Adverteer`.`reason_id`, `Adverteer`.`titel`, `Adverteer`.`prijs`, `Adverteer`.`vraagprijs`, `Adverteer`.`regio_id`, `Adverteer`.`img`, `Adverteer`.`img2`, `Adverteer`.`img3`, `Adverteer`.`img4`, `Adverteer`.`promoties`, `Adverteer`.`activado`, `Adverteer`.`beschrijving`, `Adverteer`.`created`, `Adverteer`.`order`, `Adverteer`.`featured`, `Adverteer`.`visitas`, `Adverteer`.`votes_pos`, `Adverteer`.`votes_neg`, `Adverteer`.`user_status`, `Adverteer`.`featured_category`, `Adverteer`.`expired`, `Adverteer`.`slug`, `Adverteer`.`show_in_iframe`, `Adverteer`.`pay_spotlight`, `Category`.`id`, `Category`.`admin_id`, `Category`.`father`, `Category`.`name`, `Category`.`photo`, `Category`.`photo_desc`, `Category`.`created`, `Category`.`enabled`, `Category`.`order`, `Category`.`img`, `Category`.`icon`, `Category`.`introduction`, `Category`.`palabra`, `Reason`.`id`, `Reason`.`titulo`, `Reason`.`descripcion`, `Reason`.`created`, `Reason`.`estado`, `User`.`id`, `User`.`nombre`, `User`.`apellido`, `User`.`email`, `User`.`usuario`, `User`.`password`, `User`.`empresa`, `User`.`direccion`, `User`.`ciudad`, `User`.`cp`, `User`.`pais`, `User`.`telefono`, `User`.`newsletter`, `User`.`estado`, `User`.`id_idioma`, `User`.`gender`, `User`.`profiel`, `User`.`verjaardag`, `Regio`.`id`, `Regio`.`name` FROM `adverteers` AS `Adverteer` LEFT JOIN `categories` AS `Category` ON (`Adverteer`.`category_id` = `Category`.`id`) LEFT JOIN `reasons` AS `Reason` ON (`Adverteer`.`reason_id` = `Reason`.`id`) LEFT JOIN `users` AS `User` ON (`Adverteer`.`user_id` = `User`.`id`) LEFT JOIN `regio` AS `Regio` ON (`Adverteer`.`regio_id` = `Regio`.`id`) WHERE `Adverteer`.`activado` = 1 and `Adverteer`.`user_status` = 1 and `Adverteer`.`featured_category` = 1 and `Adverteer`.`category_id` in ) ORDER BY `Adverteer`.`id` desc LIMIT 24
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 ') ORDER BY `Adverteer`.`id` desc LIMIT 24' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 501]
$sql = "SELECT `Adverteer`.`id`, `Adverteer`.`user_id`, `Adverteer`.`category_id`, `Adverteer`.`reason_id`, `Adverteer`.`titel`, `Adverteer`.`prijs`, `Adverteer`.`vraagprijs`, `Adverteer`.`regio_id`, `Adverteer`.`img`, `Adverteer`.`img2`, `Adverteer`.`img3`, `Adverteer`.`img4`, `Adverteer`.`promoties`, `Adverteer`.`activado`, `Adverteer`.`beschrijving`, `Adverteer`.`created`, `Adverteer`.`order`, `Adverteer`.`featured`, `Adverteer`.`visitas`, `Adverteer`.`votes_pos`, `Adverteer`.`votes_neg`, `Adverteer`.`user_status`, `Adverteer`.`featured_category`, `Adverteer`.`expired`, `Adverteer`.`slug`, `Adverteer`.`show_in_iframe`, `Adverteer`.`pay_spotlight`, `Category`.`id`, `Category`.`admin_id`, `Category`.`father`, `Category`.`name`, `Category`.`photo`, `Category`.`photo_desc`, `Category`.`created`, `Category`.`enabled`, `Category`.`order`, `Category`.`img`, `Category`.`icon`, `Category`.`introduction`, `Category`.`palabra`, `Reason`.`id`, `Reason`.`titulo`, `Reason`.`descripcion`, `Reason`.`created`, `Reason`.`estado`, `User`.`id`, `User`.`nombre`, `User`.`apellido`, `User`.`email`, `User`.`usuario`, `User`.`password`, `User`.`empresa`, `User`.`direccion`, `User`.`ciudad`, `User`.`cp`, `User`.`pais`, `User`.`telefono`, `User`.`newsletter`, `User`.`estado`, `User`.`id_idioma`, `User`.`gender`, `User`.`profiel`, `User`.`verjaardag`, `Regio`.`id`, `Regio`.`name` FROM `adverteers` AS `Adverteer` LEFT JOIN `categories` AS `Category` ON (`Adverteer`.`category_id` = `Category`.`id`) LEFT JOIN `reasons` AS `Reason` ON (`Adverteer`.`reason_id` = `Reason`.`id`) LEFT JOIN `users` AS `User` ON (`Adverteer`.`user_id` = `User`.`id`) LEFT JOIN `regio` AS `Regio` ON (`Adverteer`.`regio_id` = `Regio`.`id`) WHERE `Adverteer`.`activado` = 1 and `Adverteer`.`user_status` = 1 and `Adverteer`.`featured_category` = 1 and `Adverteer`.`category_id` in ) ORDER BY `Adverteer`.`id` desc LIMIT 24"
$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 ') ORDER BY `Adverteer`.`id` desc LIMIT 24' at line 1"
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 501
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 202
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 338
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 616
Model::find() - CORE/cake/libs/model/model.php, line 1785
Controller::paginate() - CORE/cake/libs/controller/controller.php, line 1015
CerebroController::category() - APP/controllers/cerebro_controller.php, line 1570
Object::dispatchMethod() - CORE/cake/libs/object.php, line 116
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 261
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 233
[main] - APP/webroot/index.php, line 85