Fatal error: Uncaught Exception: 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 'ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FRO' at line 1<br />Error No: 1064<br />SELECT p.product_id, p.manufacturer_id, p.quantity, p.sale_quantity, p.sale_quantity_status, p.tax_class_id, p.minimum, p.model, p.status, p.price, pd.name AS name, pd.description, pd.product_label, p.image, p.rating, p.sort_order, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2020-12-01') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2020-12-01') ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2020-12-01') AND (p in /var/www/html/system/library/db/mysqli.php on line 55