A Database Error Occurred

Error Number: 1064

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 '-7728, 12' at line 11

SELECT merchant_products.currency="$", ROUND(merchant_products.selling_price, 2) AS `selling_price`, ROUND(merchant_products.cost_price, 2) AS cost_price, `ci_products`.`id`, `ci_products`.`slug`, `ci_products`.`name`, `ci_products`.`image`, `ci_products`.`description`, `ci_brand`.`brand_name`, `ci_brand`.`alias`, `ci_brand`.`is_image`, `ci_brand`.`image` as `brandimage`, `ci_category`.`id` as `category_id`, `ci_category`.`name` as `category_name`, `ci_category`.`slug` as `category_slug` FROM `ci_products` LEFT JOIN `ci_brand` ON `ci_brand`.`id` = `ci_products`.`brand_id` LEFT JOIN `merchant_products` ON `merchant_products`.`name_wp` = `ci_products`.`name_wp` LEFT JOIN `ci_merchant` ON `ci_merchant`.`id` = `merchant_products`.`merchant_id` LEFT JOIN `ci_category` ON `ci_category`.`id` = `ci_products`.`category_id` WHERE `ci_products`.`category_id` = '24' AND `selling_price` > 0.01 GROUP BY `ci_products`.`name_wp` ORDER BY `selling_price` ASC LIMIT -7728, 12

Filename: models/frontend/Products_model.php

Line Number: 45