Shopping in

60611

Change your location

Hello, User

Your account
0

Cart items

Fresh farm Min. Order $10

Delivery Van Free Delivery Over $30

[Name1]

[Name2]

$[Price] - [qty] +

[Remarks]

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 WHERE (tbl_store_zip.zip = '60611') 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, sort_order asc

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') desc, sort_order asc' at line 42