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 ', 10' at line 8

SELECT `product`.*, `productcategory`.`productcategory_categoryid`, `product_shortdesc`, `company_name`, `company_basename`, `company_basenamecount`, `category_name`, `category_basename` FROM (`product`) JOIN `productcategory` ON `product`.`id` = `productcategory`.`productcategory_productid` JOIN `category` ON `productcategory`.`productcategory_categoryid` = `category`.`id` JOIN `company` ON `product`.`product_companyid` = `company`.`id` WHERE `product_publishstatusid` = 1 and product_companyid = 983 ORDER BY `product_isprime` desc LIMIT, 10