#0 Db::query( SELECT `p`.`id`, `pcs`.`discount_price`, `pcs`.`count` as `stock_count`, `p`.`id_supplier`, `p`.`price`,`p`.on_order FROM `products` as `p` INNER JOIN `category_product` as `cp` ON `p`.`id`=`cp`.`id_product` INNER JOIN `product_suppliers` as `ps` ON `p`.`id_supplier`=`ps`.`id` LEFT JOIN `product_count_instock` as `pcs` ON `pcs`.`id_product` = `p`.`id` WHERE `cp`.`id_category` IN () and `p`.`active`=1 AND `p`.`is_sale`=0 GROUP BY `p`.`id` ORDER BY ps.archive,`p`.`on_order` ASC, `p`.`sort` ASC, `p`.`prioritystorage` DESC, `p`.`price` ASC, `p`.`id` DESC , Array (), /home/poshvu.ru/public_html/www/class/Product.php, 1171) called at [/home/poshvu.ru/public_html/www/class/Product.php:1171] #1 site_Product::get_list_products_by_filters(Array ([opt] => Array ([0] => 1),[1] => Array ([0] => 799)), Array (), , , 1, 0, category, Array (), , , 60, , , 1) called at [/home/poshvu.ru/public_html/www/services/opt_cat.php:235] #2 include_once(/home/poshvu.ru/public_html/www/services/opt_cat.php) called at [/home/poshvu.ru/public_html/www/index.php:190]
MySQL mini debug
MySQL query error in file /home/poshvu.ru/public_html/www/index.php:190.
MySQL 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 ') and `p`.`active`=1 AND `p`.`is_sale`=0 GROUP BY `p`.`' at line 7
Callstack:

SELECT `p`.`id`, `pcs`.`discount_price`, `pcs`.`count` as `stock_count`, `p`.`id_supplier`, `p`.`price`,`p`.on_order FROM `products` as `p` INNER JOIN `category_product` as `cp` ON `p`.`id`=`cp`.`id_product` INNER JOIN `product_suppliers` as `ps` ON `p`.`id_supplier`=`ps`.`id` LEFT JOIN `product_count_instock` as `pcs` ON `pcs`.`id_product` = `p`.`id` WHERE `cp`.`id_category` IN () and `p`.`active`=1 AND `p`.`is_sale`=0 GROUP BY `p`.`id` ORDER BY ps.archive,`p`.`on_order` ASC, `p`.`sort` ASC, `p`.`prioritystorage` DESC, `p`.`price` ASC, `p`.`id` DESC #0 Db::query( SELECT `p`.`id`, `pcs`.`discount_price`, `pcs`.`count` as `stock_count`, `p`.`id_supplier`, `p`.`price`,`p`.on_order FROM `products` as `p` INNER JOIN `category_product` as `cp` ON `p`.`id`=`cp`.`id_product` INNER JOIN `product_suppliers` as `ps` ON `p`.`id_supplier`=`ps`.`id` LEFT JOIN `product_count_instock` as `pcs` ON `pcs`.`id_product` = `p`.`id` WHERE `cp`.`id_category` IN () and `p`.`active`=1 AND `p`.`is_sale`=0 GROUP BY `p`.`id` ORDER BY ps.archive,`p`.`on_order` ASC, `p`.`sort` ASC, `p`.`prioritystorage` DESC, `p`.`price` ASC, `p`.`id` DESC , Array (), /home/poshvu.ru/public_html/www/class/Product.php, 1171) called at [/home/poshvu.ru/public_html/www/class/Product.php:1171] #1 site_Product::get_list_products_by_filters(Array ([opt] => Array ([0] => 1),[1] => Array ([0] => 799)), Array (), , , 1, 0, category, Array (), , , 60, , , 1) called at [/home/poshvu.ru/public_html/www/services/opt_cat.php:235] #2 include_once(/home/poshvu.ru/public_html/www/services/opt_cat.php) called at [/home/poshvu.ru/public_html/www/index.php:190]