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 ')) LEFT JOIN mac_category c ON (p2c.category_id=c.category_id) LEFT JOIN mac_pro' at line 1<br />Error No: 1064<br />SELECT product_id, ind_sort, sort_order FROM(SELECT DISTINCT p.product_id, pd.name, p.model, p.quantity, p.price, p2cs.sort_order AS ind_sort, p.sort_order, p.date_added, p.date_available , coalesce((SELECT price FROM mac_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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (SELECT price FROM mac_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 < NOW()) AND (ps.date_end = '0000-00-00' OR ps.d in /var/www/top3dshop/data/www/top3dshop.ru/system/database/mysqli.php on line 48
Array ( [type] => 1 [message] => 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 ')) LEFT JOIN mac_category c ON (p2c.category_id=c.category_id) LEFT JOIN mac_pro' at line 1
Error No: 1064
SELECT product_id, ind_sort, sort_order FROM(SELECT DISTINCT p.product_id, pd.name, p.model, p.quantity, p.price, p2cs.sort_order AS ind_sort, p.sort_order, p.date_added, p.date_available , coalesce((SELECT price FROM mac_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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (SELECT price FROM mac_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 < NOW()) AND (ps.date_end = '0000-00-00' OR ps.d [file] => /var/www/top3dshop/data/www/top3dshop.ru/system/database/mysqli.php [line] => 48 )