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 ', (SELECT wcd.`unit` FROM `oc_weight_class_description` wcd WHERE p.`weight_c' at line 19
Error No: 1064
SELECT p.`product_id`, p.`model`, p.`sku`, p.`upc`, p.`ean`, p.`jan`, p.`isbn`, p.`mpn`, p.`image`, p.`manufacturer_id`, p.`tax_class_id`, p.`price`, p.`points`, p.`quantity`, p.`minimum`, p.`subtract`, p.`stock_status_id`, p.`weight`, p.`weight_class_id`, p.`length`, p.`width`, p.`height`, p.`length_class_id`, p.`sort_order`, p.`status`, p.`date_available`, p.`date_added`, p.`date_modified`, p.`viewed`, p.`master_id`, p.`variant`, p.`override`, p.`size`, p.`price_per_inch`, p.`custom_quote`, p.`tending_product`, p.`temp_price`, p.`product_min_qty`, p.`additional_text`, p.`product_tag`, p.`online_designer`, p.`navitor`, p.`affliate_product`, p.`affliate_product_link`, p.`aff_link`, p.`gd_design`, p.`gd_product`, p.`gr_status`, p.`readmore_description`, pd.`name`, pd.`description`, pd.`tag`, pd.`title`, pd.`prod_desc`, pd.`product_tab_name`, pd.`meta_title`, pd.`meta_description`, pd.`meta_description` AS meta_description_new, pd.`meta_keyword`, pd.`h1`, pd.`product_desc_tab_name`, m.`name` AS manufacturer, (SELECT `price` FROM `oc_product_discount` pd2 WHERE pd2.`product_id` = p.`product_id` AND pd2.`customer_group_id` = '8' 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) AS `discount`, (SELECT `price` FROM `oc_product_special` ps WHERE ps.`product_id` = p.`product_id` AND ps.`customer_group_id` = '8' AND ((ps.`date_start` = '0000-00-00' OR ps.`date_start` < NOW()) AND (ps.`date_end` = '0000-00-00' OR ps.`date_end` > NOW())) ORDER BY ps.`priority` ASC, ps.`price` ASC LIMIT 1) AS `special`, (SELECT `points` FROM `oc_product_reward` pr WHERE pr.`product_id` = p.`product_id` AND pr.`customer_group_id` = '8') AS `reward`, (SELECT ss.`name` FROM `oc_stock_status` ss WHERE ss.`stock_status_id` = p.`stock_status_id`, (SELECT wcd.`unit` FROM `oc_weight_class_description` wcd WHERE p.`weight_class_id` = wcd.`weight_class_id`, (SELECT lcd.`unit` FROM `oc_length_class_description` lcd WHERE p.`length_class_id` = lcd.`length_class_id`) AS `length_class`, (SELECT AVG(`rating`) FROM `oc_review` r1 WHERE r1.`product_id` = p.`product_id` AND r1.`status` = '1' GROUP BY r1.`product_id`) AS `rating`, (SELECT COUNT(*) FROM `oc_review` r2 WHERE r2.`product_id` = p.`product_id` AND r2.`status` = '1' GROUP BY r2.`product_id`) AS `reviews` 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`) WHERE p.`product_id` = '32852' AND p.`status` = '1' AND p.`date_available` <= NOW() in /var/www/html/system/library/db/mysqli.php on line 63