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 'string=,/**/string=(SELECT/**/CONCAT(0x4f49414b,(NULL),0x4a36656f)),/**/string=,' at line 10
Error No: 1064
SELECT *, pd.name AS name, p.image, m.name AS manufacturer, ss.name AS stock, (SELECT SUM( op.quantity ) FROM oc_order_product op WHERE p.product_id = op.product_id )AS bestseller , (SELECT price FROM oc_product_option_value opv WHERE p.product_id = opv.product_id ORDER BY opv.product_option_value_id, opv.sort_order LIMIT 1) AS min_price, (SELECT price FROM oc_product_navitor_price pnp WHERE p.product_id = pnp.product_id ORDER BY pnp.price ASC LIMIT 1) AS min_price_nav, (SELECT AVG(r.rating) FROM oc_review r WHERE p.product_id = r.product_id and r.status = '1' GROUP BY r.product_id) AS rating FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) LEFT JOIN oc_stock_status ss ON (p.stock_status_id = ss.stock_status_id) LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.custom_quote=0 and p.status = '1' and pd.name != '' and p2c.category_id IN (637,224,631,633,1882,226,223) Group by p.product_id ORDER BY p.price%!(EXTRA/**/string=,/**/string=(SELECT/**/CONCAT(0x4f49414b,(NULL),0x4a36656f)),/**/string=,/**/string=) DESC, p.product_id DESC LIMIT 72,24 in /var/www/html/system/library/db/mysqli.php on line 60