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 '\n p.`length`, p.`width`, p.`tending_product`, p.`custom_quote`, p.`temp_price' at line 1
Error No: 1064
SELECT p.`product_id`, p.`image`, p.`price`, p.`tax_class_id`, p.`minimum`, p.`model`,\n p.`length`, p.`width`, p.`tending_product`, p.`custom_quote`, p.`temp_price`, p.`navitor`,\n pd.`name`, pd.`description`, pd.`prod_desc`,\n p2c.`category_id`,\n m.`name` AS manufacturer,\n ss.`name` AS stock,\n (SELECT SUM(op.quantity) FROM `oc_order_product` op WHERE p.product_id = op.product_id) AS bestseller,\n (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,\n (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,\n (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\n FROM `oc_product` p\n LEFT JOIN `oc_product_description` pd ON (p.product_id = pd.product_id)\n LEFT JOIN `oc_manufacturer` m ON (p.manufacturer_id = m.manufacturer_id)\n LEFT JOIN `oc_stock_status` ss ON (p.stock_status_id = ss.stock_status_id)\n LEFT JOIN `oc_product_to_category` p2c ON (p.product_id = p2c.product_id)\n WHERE p.custom_quote=0 AND p.status = \'1\' AND pd.name != \'\' AND p2c.category_id IN (1836,1847,1835,1837,1838,167,169,170,51,52,675,524,53) GROUP BY p.product_id ORDER BY rating DESC, p.product_id DESC LIMIT 156,12 in /var/www/html/system/library/db/mysqli.php on line 61