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]

JAI HIND FOODS
JAI HIND FOODS

Jai Hind Foods

1023 W Golf Rd, Hoffman Estates, IL 60169

Grocery shopping has never been easier. Order Indian groceries online in Schaumburg or nearby areas at great prices and get same-day delivery with Jai Hind Foods. Spend more time cooking and less time shopping.

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, 4001,4062) 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, 4001,4062) desc, sort_order asc' at line 42