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 ') GROUP BY IF(`hpl`.`parent_id` IS NOT NULL AND `h2s`.`store_id` IS NOT NULL AND' at line 1<br />Error No: 1064<br />SELECT `p`.*, `pd`.*, (SELECT AVG(`rating`) AS `total` FROM `oc_review` `r1` WHERE `r1`.`product_id` = `p`.`product_id` AND `r1`.`status` = '1' GROUP BY `r1`.`product_id`) AS `rating`, (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` < '2025-05-11 19:30:00') AND (`ps`.`date_end` = '0000-00-00' OR `ps`.`date_end` > '2025-05-11 19:30:00')) ORDER BY `ps`.`priority` ASC, `ps`.`price` ASC LIMIT 1) AS `special`, (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 in /www/wwwroot/vista.ua/system/storage/modification/system/library/db/mysqli.php on line 67