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 'ranked_products AS ( SELECT CASE WHEN p.master_id =' at line 1
Error No: 1064
WITH ranked_products AS ( SELECT CASE WHEN p.master_id = 0 THEN p.product_id ELSE p.master_id END AS group_id, pd.name, pd.description, p.*, (SELECT `pd2`.`price` FROM `ds_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 `ps`.`price` FROM `ds_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 `pr`.`points` FROM `ds_product_reward` `pr` WHERE `pr`.`product_id` = `p`.`product_id` AND `pr`.`customer_group_id` = '8') AS `reward` , (SELECT COUNT(*) FROM `ds_review` `r` WHERE `r`.`product_id` = `p`.`product_id` AND `r`.`status` = '1' GROUP BY `r`.`product_id`) AS `reviews` , ROW_NUMBER() OVER (PARTITION BY CASE WHEN p.master_id = 0 THEN p.product_id ELSE p.master_id END ORDER BY p.default_variant DESC ) AS rn FROM `ds_product` p LEFT JOIN `ds_product_description` pd ON (p.product_id = pd.product_id) LEFT JOIN `ds_product_to_store` p2s ON (p2s.product_id = p.product_id) LEFT JOIN `ds_product_filter` pf ON (pf.product_id = p.product_id) LEFT JOIN `ds_product_to_category` p2c ON (p2c.product_id = p.product_id) LEFT JOIN `ds_category_to_store` c2s ON (c2s.category_id = p2c.category_id) WHERE p.status = '1' AND p.date_available <= NOW() AND pd.language_id = '1' AND p2c.category_id = '81') SELECT * FROM ranked_products WHERE rn = 1 ORDER BY sort_order ASC, LCASE(name) ASC LIMIT 0, 3 in /home2/tsprojec/dogshop.tsprojects.net/system/library/db/mysqli.php on line 68