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 '-9 , 9' at line 1

SELECT * FROM (SELECT a.nid as nid , a.nhot_product as nhot_product, a.ccode as ccode, a.cnote_vni as cnote_vni, a.cnote_eng as cnote_eng, a.cview as cview, a.norder as norder, a.ccarton_size as ccarton_size, a.cpacking as cpacking, a.cloading as cloading, a.cmaterial as cmaterial, a.cview_sale_off as cview_sale_off, a.cview_now as cview_now, a.cindex as cindex, a.corigin_vni as corigin_vni, a.corigin_eng as corigin_eng, a.cshort_detail_vni as cshort_detail_vni, a.cshort_detail_eng as cshort_detail_eng, a.csale_off as csale_off, a.nsale_off as nsale_off, a.cproducts_vni as cproducts_vni, a.cproducts_eng as cproducts_eng, a.nspecial_products as nspecial_products, a.nnew_products as nnew_products, a.nnow_products as nnow_products, a.nbest_buy_products as nbest_buy_products, a.nid_material_products as nid_material_products, a.nid_cat_products as nid_cat_products, a.csize as csize, a.cimage as cimage, a.cimage_resize as cimage_resize, a.cimage_1 as cimage_1, a.cimage_1_resize as cimage_1_resize, a.cimage_2 as cimage_2, a.cimage_2_resize as cimage_2_resize, a.cimage_3 as cimage_3, a.cimage_3_resize as cimage_3_resize, a.fprice as fprice, a.nquantity as nquantity, a.cdescription as cdescription, a.cdetail_eng as cdetail_eng, a.cdetail_vni as cdetail_vni, a.nstatus as nstatus, concat(b.cfirstname, " " , b.cmiddlename, " " , b.clastname) as cfullname , a.niduser01 as niduser01 , a.niduser02 as niduser02 , a.ddate01 as ddate01 , a.ddate02 as ddate02 FROM cms_tproducts as a ,cms_tuser as b WHERE a.niduser01=b.nid AND a.nstatus = 1 ) as view WHERE nid is not null AND nid_material_products IN (81,117,118,119) ORDER BY IFNULL(cindex,99999) desc limit -9 , 9