( ! ) Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '))WHERE p.status = '1' AND p.disable = '0' AND p2b.product_id IN(53,58,61,75,...' at line 3 in /var/www/site-dev/system/library/db/mysqli.php on line 18
( ! ) mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '))WHERE p.status = '1' AND p.disable = '0' AND p2b.product_id IN(53,58,61,75,...' at line 3 in /var/www/site-dev/system/library/db/mysqli.php on line 18
Call Stack
#TimeMemoryFunctionLocation
10.0000359576{main}( ).../index.php:0
20.0004371720start( $application_config = 'catalog' ).../index.php:11
30.0004373128require_once( '/var/www/site-dev/system/framework.php ).../startup.php:105
40.0020475320Front->dispatch( $action = class Action { private $id = 'startup/router'; private $route = 'startup/router'; private $method = 'index' }, $error = class Action { private $id = 'error/not_found'; private $route = 'error/not_found'; private $method = 'index' } ).../framework.php:71
50.0078802936Front->execute( $action = class Action { private $id = 'startup/router'; private $route = 'startup/router'; private $method = 'index' } ).../front.php:29
60.0078802936Action->execute( $registry = class Registry { private $data = ['config' => class Config { ... }, 'load' => class Loader { ... }, 'request' => class Request { ... }, 'response' => class Response { ... }, 'db' => class DB { ... }, 'session' => class Session { ... }, 'cache' => class Cache { ... }, 'language' => class Language { ... }, 'document' => class Document { ... }, 'translit' => class Translit { ... }, 'model_localisation_language' => class Proxy { ... }, 'http_scheme' => 'https', 'http_host' => 'www.danswinkel.nl', 'url' => class Url { ... }, 'model_tool_common' => class Proxy { ... }, 'model_tool_image' => class Proxy { ... }, 'customer' => class Cart\Customer { ... }, 'currency' => class Cart\Currency { ... }, 'tax' => class Tax { ... }, 'cart' => class Cart\Cart { ... }, 'total' => class Cart\Total { ... }, 'model_catalog_product_clear' => class Proxy { ... }, 'product' => class Service\Product { ... }, 'model_checkout_order_clear' => class Proxy { ... }, 'order' => class Service\Order { ... }, 'encryption' => class Encryption { ... }, 'length' => class Length { ... }, 'log' => class Log { ... }, 'model_catalog_page_param' => class Proxy { ... }] }, $args = ??? ).../front.php:34
70.0079803144ControllerStartupRouter->index( ).../action.php:55
80.0079803392Action->execute( $registry = class Registry { private $data = ['config' => class Config { ... }, 'load' => class Loader { ... }, 'request' => class Request { ... }, 'response' => class Response { ... }, 'db' => class DB { ... }, 'session' => class Session { ... }, 'cache' => class Cache { ... }, 'language' => class Language { ... }, 'document' => class Document { ... }, 'translit' => class Translit { ... }, 'model_localisation_language' => class Proxy { ... }, 'http_scheme' => 'https', 'http_host' => 'www.danswinkel.nl', 'url' => class Url { ... }, 'model_tool_common' => class Proxy { ... }, 'model_tool_image' => class Proxy { ... }, 'customer' => class Cart\Customer { ... }, 'currency' => class Cart\Currency { ... }, 'tax' => class Tax { ... }, 'cart' => class Cart\Cart { ... }, 'total' => class Cart\Total { ... }, 'model_catalog_product_clear' => class Proxy { ... }, 'product' => class Service\Product { ... }, 'model_checkout_order_clear' => class Proxy { ... }, 'order' => class Service\Order { ... }, 'encryption' => class Encryption { ... }, 'length' => class Length { ... }, 'log' => class Log { ... }, 'model_catalog_page_param' => class Proxy { ... }] }, $args = ??? ).../router.php:18
90.0079803720ControllerProductPageParam->index( ).../action.php:55
100.3425849408Service\Product->getProductPageParamBadges( $data = ['page_param_id' => '44', 'category_ids' => [], 'pv_ids' => [0 => '9', 1 => '110', 2 => '479'], 'p_count' => 1, 'multiple_params' => [], 'badges' => [], 'price_from' => '', 'price_to' => '', 'sort' => 'default', 'order' => 'desc', 'page' => 1, 'limit' => '24'], $badges = ['bestseller' => ['code' => 'bestseller', 'color' => '#d1c5c5', 'css_class' => '', 'name' => 'Bestseller', 'short_description' => 'Bestseller', 'is_filter' => '1', 'is_sort' => '1', 'image' => 'https://www.danswinkel.nl/image/badge/bestseller/bestseller.svg', 'description' => 'Bestseller', 'sort_order' => '2'], 'eco' => ['code' => 'eco', 'color' => '#b6d1bb', 'css_class' => '', 'name' => 'ECO', 'short_description' => 'ECO', 'is_filter' => '1', 'is_sort' => '1', 'image' => 'https://www.danswinkel.nl/image/badge/eco/eco.svg', 'description' => 'ECO', 'sort_order' => '3'], 'rad' => ['code' => 'rad', 'color' => '#e0cee0', 'css_class' => '', 'name' => 'RAD', 'short_description' => 'RAD geschikte balletkleding', 'is_filter' => '1', 'is_sort' => '1', 'image' => 'https://www.danswinkel.nl/image/badge/rad/rad.svg', 'description' => 'Geschikte balletkleding voor Royal Academy of Dance (RAD) lessen.', 'sort_order' => '4'], 'uitverkocht' => ['code' => 'uitverkocht', 'color' => '#f4cccc', 'css_class' => '', 'name' => 'Uitverkocht', 'short_description' => 'Uitverkocht', 'is_filter' => '0', 'is_sort' => '0', 'image' => 'https://www.danswinkel.nl/image/badge/uitverkocht/uitverkocht.svg', 'description' => 'Uitverkocht', 'sort_order' => '4']] ).../page_param.php:303
110.3425849784Proxy->__call( $key = 'getProductPageParamBadges', $args = [0 => ['page_param_id' => '44', 'category_ids' => [...], 'pv_ids' => [...], 'p_count' => 1, 'multiple_params' => [...], 'badges' => [...], 'price_from' => '', 'price_to' => '', 'sort' => 'default', 'order' => 'desc', 'page' => 1, 'limit' => '24'], 1 => ['bestseller' => [...], 'eco' => [...], 'rad' => [...], 'uitverkocht' => [...]]] ).../product.php:71
120.3425850568Loader->{closure:/var/www/site-dev/system/engine/loader.php:108-138}( $args = [0 => ['page_param_id' => '44', 'category_ids' => [...], 'pv_ids' => [...], 'p_count' => 1, 'multiple_params' => [...], 'badges' => [...], 'price_from' => '', 'price_to' => '', 'sort' => 'default', 'order' => 'desc', 'page' => 1, 'limit' => '24'], 1 => ['bestseller' => [...], 'eco' => [...], 'rad' => [...], 'uitverkocht' => [...]]], [0 => ['page_param_id' => '44', 'category_ids' => [...], 'pv_ids' => [...], 'p_count' => 1, 'multiple_params' => [...], 'badges' => [...], 'price_from' => '', 'price_to' => '', 'sort' => 'default', 'order' => 'desc', 'page' => 1, 'limit' => '24'], 1 => ['bestseller' => [...], 'eco' => [...], 'rad' => [...], 'uitverkocht' => [...]]] ).../proxy.php:25
130.3425851896ModelCatalogProductClear->getProductPageParamBadges( $criteria = ['page_param_id' => '44', 'category_ids' => [], 'pv_ids' => [0 => '9', 1 => '110', 2 => '479'], 'p_count' => 1, 'multiple_params' => [], 'badges' => [], 'price_from' => '', 'price_to' => '', 'sort' => 'default', 'order' => 'desc', 'page' => 1, 'limit' => '24'], $db_badges = ['bestseller' => ['code' => 'bestseller', 'color' => '#d1c5c5', 'css_class' => '', 'name' => 'Bestseller', 'short_description' => 'Bestseller', 'is_filter' => '1', 'is_sort' => '1', 'image' => 'https://www.danswinkel.nl/image/badge/bestseller/bestseller.svg', 'description' => 'Bestseller', 'sort_order' => '2'], 'eco' => ['code' => 'eco', 'color' => '#b6d1bb', 'css_class' => '', 'name' => 'ECO', 'short_description' => 'ECO', 'is_filter' => '1', 'is_sort' => '1', 'image' => 'https://www.danswinkel.nl/image/badge/eco/eco.svg', 'description' => 'ECO', 'sort_order' => '3'], 'rad' => ['code' => 'rad', 'color' => '#e0cee0', 'css_class' => '', 'name' => 'RAD', 'short_description' => 'RAD geschikte balletkleding', 'is_filter' => '1', 'is_sort' => '1', 'image' => 'https://www.danswinkel.nl/image/badge/rad/rad.svg', 'description' => 'Geschikte balletkleding voor Royal Academy of Dance (RAD) lessen.', 'sort_order' => '4'], 'uitverkocht' => ['code' => 'uitverkocht', 'color' => '#f4cccc', 'css_class' => '', 'name' => 'Uitverkocht', 'short_description' => 'Uitverkocht', 'is_filter' => '0', 'is_sort' => '0', 'image' => 'https://www.danswinkel.nl/image/badge/uitverkocht/uitverkocht.svg', 'description' => 'Uitverkocht', 'sort_order' => '4']] ).../loader.php:132
140.49371003976DB->query( $sql = 'SELECT p2b.badge_code, COUNT(DISTINCT p2b.product_id) AS p_count\n FROM product_to_badge p2b\n INNER JOIN product p ON (p2b.product_id = p.product_id) INNER JOIN product_to_category p2c ON (p2c.product_id = p.product_id AND p2c.category_id IN())WHERE p.status = \'1\' AND p.disable = \'0\' AND p2b.product_id IN(53,58,61,75,76,96,98,103,113,138,145,147,148,150,172,185,186,192,208,211,219,227,230,233,234,235,241,243,244,255,259,267,268,270,272,273,274,279,301,303,309,314,315,316,319,323,324,32'..., $params = ??? ).../product_clear.php:5181
150.49371003976DB\MySQLi->query( $sql = 'SELECT p2b.badge_code, COUNT(DISTINCT p2b.product_id) AS p_count\n FROM product_to_badge p2b\n INNER JOIN product p ON (p2b.product_id = p.product_id) INNER JOIN product_to_category p2c ON (p2c.product_id = p.product_id AND p2c.category_id IN())WHERE p.status = \'1\' AND p.disable = \'0\' AND p2b.product_id IN(53,58,61,75,76,96,98,103,113,138,145,147,148,150,172,185,186,192,208,211,219,227,230,233,234,235,241,243,244,255,259,267,268,270,272,273,274,279,301,303,309,314,315,316,319,323,324,32'..., [] ).../db.php:16
160.49371003976query( $query = 'SELECT p2b.badge_code, COUNT(DISTINCT p2b.product_id) AS p_count\n FROM product_to_badge p2b\n INNER JOIN product p ON (p2b.product_id = p.product_id) INNER JOIN product_to_category p2c ON (p2c.product_id = p.product_id AND p2c.category_id IN())WHERE p.status = \'1\' AND p.disable = \'0\' AND p2b.product_id IN(53,58,61,75,76,96,98,103,113,138,145,147,148,150,172,185,186,192,208,211,219,227,230,233,234,235,241,243,244,255,259,267,268,270,272,273,274,279,301,303,309,314,315,316,319,323,324,32'... ).../mysqli.php:18