Error: SELECT tbl_tmp_category.id, tbl_tmp_category.slug, tbl_tmp_category.maincategory, tbl_tmp_category.zip_area, tbl_tmp_category.`showforusps`, tbl_tmp_category.status, tbl_tmp_category.parent_id, tbl_tmp_category.sort_order FROM (SELECT tbl_maincategory.id, tbl_maincategory.slug, tbl_maincategory.maincategory, tbl_store_cate.zip_area, tbl_maincategory.`showforusps`, tbl_maincategory.status, tbl_maincategory.parent_id, tbl_maincategory.sort_order FROM tbl_maincategory INNER JOIN (SELECT `tbl_product`.cat_id, tbl_tmp_store.zip_area FROM `tbl_product` INNER JOIN (SELECT tbl_store_zip.storeid, tbl_store_zip.`zip_area` FROM tbl_store_zip left join stores on tbl_store_zip.storeid=stores.storeid WHERE (tbl_store_zip.zip = '95051' OR stores.by_pass_zipcode=1) GROUP BY tbl_store_zip.storeid) tbl_tmp_store ON tbl_tmp_store.storeid=`tbl_product`.`storeid` group by `tbl_product`.cat_id) tbl_store_cate ON tbl_store_cate.cat_id= tbl_maincategory.id LEFT OUTER JOIN tbl_categoryimage ON (tbl_maincategory.id = tbl_categoryimage.cat_id) )tbl_tmp_category WHERE if(tbl_tmp_category.zip_area='UPS',tbl_tmp_category.showforusps,if(tbl_tmp_category.zip_area!='UPS',0,1))=0 AND tbl_tmp_category.status=1 and tbl_tmp_category.parent_id!=0 and tbl_tmp_category.parent_id='' order by field(tbl_tmp_category.id, ) desc,field(tbl_tmp_category.parent_id, 4337,4001,4320,4062,4288,4068,4061) desc, sort_order asc

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 ') desc,field(tbl_tmp_category.parent_id, 4337,4001,4320,4062,4288,4068,4061) des' at line 42