Fatal error: Uncaught exception 'ErrorException' with message 'Error: 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 ') GROUP BY p.product_id) as t) as total, p.product_id FROM ( SELECT * ' at line 35<br />Error No: 1064<br />SELECT (SELECT count(*) FROM (SELECT p.product_id FROM ( SELECT * FROM ( SELECT p.product_id,p.upc,p.ean,p.jan,p.isbn,p.mpn,p.model,por.sku,IFNULL(sks.total,0) AS quantity,p.date_available,p.date_added,por.active AS STATUS,por.image,p.manufacturer_id,por.price,p.points,por.weight,pov.option_id,pov.option_value_id,p.sort_order,p.viewed FROM oc_product p INNER JOIN oc_product_option AS po ON p.product_id = po.product_id INNER JOIN oc_product_option_value AS pov ON po.product_option_id = pov.product_option_id INNER JOIN oc_product_option_relation AS por ON por.product_id = p.product_id AND por.var = pov.product_option_value_id LEFT JOIN (SELECT product_option_id, SUM( in /var/www/html/system/database/mysqli.php on line 41