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 'b ON a.customer_group_id = pp.customer_group_id WHERE product_id ' at line 4
Error No: 1064
SELECT a.*, b.name as customer_name,pp.show_banner,pp.banner_text FROM oc_product_discount as a LEFT JOIN oc_customer_group_description as b ON a.customer_group_id = b.customer_group_id LEFT JOIN oc_pricesetup_prices pp b ON a.customer_group_id = pp.customer_group_id WHERE product_id = '155754' AND a.customer_group_id IN (6,5,4,2,1,3) AND quantity >= 0 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY quantity ASC, priority ASC, price ASC in /home/b/batareika/batareika36.ru/public_html/system/library/db/mysqli.php:50 Stack trace: #0 /home/b/batareika/batareika36.ru/public_html/system/library/db.php(4 in /home/b/batareika/batareika36.ru/public_html/system/library/db/mysqli.php on line 50