Shopping in

60004

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]

Fresh Farms
Fresh Farms

Fresh Farms

2626 W Devon Ave, Chicago, IL 60659

Fresh Farms, a popular and well-loved international brand based in Chicago has been with us for more than a decade. Our collaboration with Fresh Farms international market has let us provide our customers with fresh Indian and Asian produce. Just like our customers, our trust in Fresh Farms has made your favorite Indian grocery store in Chicago

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