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 'AND status = 1 AND quantity > 0' at line 1
Error No: 1064
SELECT MAX(p.price) AS price_max, MIN(p.price) AS price_min, p.tax_class_id, SUM(p.price) AS total_cost, COUNT(p.product_id) AS total_items FROM `oc_product` AS p INNER JOIN `oc_product_to_category` AS pc ON (pc.product_id = p.product_id) WHERE pc.category_id = AND status = 1 AND quantity > 0 in /home/live/web/bigmag.ae/public_html/system/library/db/mysqli.php:40 Stack trace: #0 /home/live/web/bigmag.ae/public_html/system/library/db.php(45): DB\MySQLi->query(' SELECT MAX(p....') #1 /home/live/web/bigmag.ae/public_html/catalog/model/extension/module/price_table.php(16): DB->query(' SELECT MAX(p....') #2 /home/live/web/bigmag.ae/public_html/system/storage/modification/system/engine/loader.php(248): ModelExtensionModulePriceTable->getCategoryPrices(NULL) #3 /home/live/we in /home/live/web/bigmag.ae/public_html/system/library/db/mysqli.php on line 40