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 'weave) GROUP BY product_id HAVING COUN' at line 31<br />Error No: 1064<br />SELECT COUNT(*) AS total FROM ( SELECT DISTINCT p.product_id FROM oc_product p LEFT JOIN ( SELECT op.product_id, SUM(op.quantity) AS sales_volume FROM oc_order_product op GROUP BY op.product_id) op ON (op.product_id = p.product_id) LEFT JOIN ( SELECT op.product_id, SUM(op.quantity) AS month_volume FROM oc_order_product op LEFT JOIN oc_order o ON o.`order_id`=op.`order_id` WHERE DATE(o.date_payment) >= '2019-04-21' GROUP BY op.product_id ) oop ON (oop.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) in /var/www/max/system/database/mysqli.php on line 41