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 'GROUP BY p.product_id ORDER BY p.sort_order DESC, LCASE(`pd`.`name`) DESC LIMIT' at line 2
Error No: 1064
SELECT DISTINCT *, `pd`.`name`, `p`.`image`, `p`.`price`, (SELECT `pd2`.`price` FROM `oc35rx_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) AS `discount`, (SELECT `ps`.`price` FROM `oc35rx_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`.`date_end` > NOW())) ORDER BY `ps`.`priority` ASC, `ps`.`price` ASC LIMIT 1) AS `special`, (SELECT `pr`.`points` FROM `oc35rx_product_reward` `pr` WHERE `pr`.`product_id` = `p`.`product_id` AND `pr`.`customer_group_id` = '1') AS `reward`, (SELECT COUNT(*) FROM `oc35rx_review` `r` WHERE `r`.`product_id` = `p`.`product_id` AND `r`.`status` = '1' GROUP BY `r`.`product_id`) AS `reviews` FROM `oc35rx_product_special` `ps2` LEFT JOIN `oc35rx_product_to_store` `p2s` ON (`ps2`.`product_id` = `p2s`.`product_id` AND `p2s`.`store_id` = '0' AND `ps2`.`customer_group_id` = '1' AND ((`ps2`.`date_start` = '0000-00-00' OR `ps2`.`date_start` < NOW()) AND (`ps2`.`date_end` = '0000-00-00' OR `ps2`.`date_end` > NOW()))) LEFT JOIN `oc35rx_product` `p` ON (`p`.`product_id` = `p2s`.`product_id` AND `p`.`status` = '1' AND `p`.`date_available` <= NOW()) LEFT JOIN `oc35rx_product_description` `pd` ON (`pd`.`product_id` = `p`.`product_id`) LEFT JOIN `oc35rx_report_purchased` `rp` ON (`p`.`product_id` = `rp`.`product_id`) WHERE `pd`.`language_id` = '1' GROUP BY `ps2`.`product_id` GROUP BY p.product_id ORDER BY p.sort_order DESC, LCASE(`pd`.`name`) DESC LIMIT 0,50: in /home/darbring43dx/public_html/system/library/db/mysqli.php on line 76