Fatal error: Uncaught Exception: Error: 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 '12082  and p.stockid in (select stockid from product_to_manufacturer where ma...' at line 2<br />Error No: 1064<br />SELECT COUNT(DISTINCT p.stockid) AS total FROM product_to_category pc
							INNER JOIN stockmaster p on p.stockid = pc.stockid and pc.category_id in (12082)  LEFT JOIN product_description d on p.stockid = d.stockid  WHERE 1 and discontinued ='0' and enabled='1'  and d.loggedin = 0   AND p.categoryid in 12082  and p.stockid in (select stockid from product_to_manufacturer where manufacturer_id='80')  AND p.stockid IN (SELECT p2.stockid FROM stockmaster p2 INNER JOIN prices pr ON pr.stockid = p2.stockid AND pr.typeabbrev = 'A' AND DATE(NOW()) BETWEEN pr.startdate AND pr.enddate GROUP BY p2.stockid, p2.mbflag HAVING (MIN(pr.price) > 0 OR (p2.mbflag = 'C' AND MIN(pr.price) IS NOT NULL))) in /var/www/b2b/moov/system/library/db/mysqli.php on line 40

Exception: Error: 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 '12082  and p.stockid in (select stockid from product_to_manufacturer where ma...' at line 2<br />Error No: 1064<br />SELECT COUNT(DISTINCT p.stockid) AS total FROM product_to_category pc
							INNER JOIN stockmaster p on p.stockid = pc.stockid and pc.category_id in (12082)  LEFT JOIN product_description d on p.stockid = d.stockid  WHERE 1 and discontinued ='0' and enabled='1'  and d.loggedin = 0   AND p.categoryid in 12082  and p.stockid in (select stockid from product_to_manufacturer where manufacturer_id='80')  AND p.stockid IN (SELECT p2.stockid FROM stockmaster p2 INNER JOIN prices pr ON pr.stockid = p2.stockid AND pr.typeabbrev = 'A' AND DATE(NOW()) BETWEEN pr.startdate AND pr.enddate GROUP BY p2.stockid, p2.mbflag HAVING (MIN(pr.price) > 0 OR (p2.mbflag = 'C' AND MIN(pr.price) IS NOT NULL))) in /var/www/b2b/moov/system/library/db/mysqli.php on line 40

Call Stack:
    0.0001     403104   1. {main}() /var/www/b2b/moov/index.php:0
    0.0067     745704   2. start() /var/www/b2b/moov/index.php:32
    0.0069     767688   3. require_once('/var/www/b2b/moov/system/framework.php') /var/www/b2b/moov/system/startup.php:130
    0.0167    1284000   4. Front->dispatch() /var/www/b2b/moov/system/framework.php:120
    0.0461    3408912   5. Front->execute() /var/www/b2b/moov/system/engine/front.php:28
    0.0461    3408912   6. Action->execute() /var/www/b2b/moov/system/engine/front.php:33
    0.0462    3414336   7. ControllerStartupRouter->index() /var/www/b2b/moov/system/engine/action.php:51
    0.0464    3414584   8. Action->execute() /var/www/b2b/moov/catalog/controller/startup/router.php:25
    0.0513    4009320   9. ControllerProductCategory->guest() /var/www/b2b/moov/system/engine/action.php:51
    0.0811    4700296  10. Proxy->getTotalProducts() /var/www/b2b/moov/catalog/controller/product/category.php:1650
    0.0811    4700672  11. Proxy->__call() /var/www/b2b/moov/catalog/controller/product/category.php:1650
    0.0811    4701456  12. Loader->{closure:/var/www/b2b/moov/system/engine/loader.php:153-197}() /var/www/b2b/moov/system/engine/proxy.php:25
    0.0812    4702592  13. ModelCatalogProduct->getTotalProducts() /var/www/b2b/moov/system/engine/loader.php:184
    0.0813    4703392  14. DB->query() /var/www/b2b/moov/catalog/model/catalog/product.php:526
    0.0813    4703392  15. DB\MySQLi->query() /var/www/b2b/moov/system/library/db.php:16