Fatal error: Uncaught ErrorException: 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 ps.`product_id` ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT ' at line 1<br />Error No: 1064<br />SELECT DISTINCT ps.`product_id`, (SELECT AVG(rating) FROM `review` r1 WHERE r1.`product_id` = ps.`product_id` AND r1.`status` = '1' GROUP BY r1.`product_id`) AS rating FROM `product_special` ps LEFT JOIN `product` p ON (ps.`product_id` = p.`product_id`) LEFT JOIN `product_description` pd ON (p.`product_id` = pd.`product_id`) WHERE p.`status` = '1' AND ps.`customer_group_id` = '1')) GROUP BY ps.`product_id` ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,100 in /home/mypoloni/mebel-star.net/www/system/database/mysqli.php:43 Stack trace: #0 /home/mypoloni/mebel-star.net/www/system/library/db.php(18): DBMySQLi->query('SELECT DISTINCT...') #1 /home/mypoloni/mebel-star.net/www/catalog/model/catalog/product.php(297): DB->query('SE in /home/mypoloni/mebel-star.net/www/system/database/mysqli.php on line 43