Hoffman Estates, Illinois Zip Codes: 60010,60067,60107,60118,60120,60169,60179,60192,60195
select cat from directory where is_archived=0 and site_url != '' and (city='hoffman estates' OR city='hoffman_estates') and (state='IL' OR state='Illinois')
select cat from directory where is_archived=0 and site_url != '' and (city='hoffman estates' OR city='hoffman_estates') and (state='IL' OR state='Illinois')
union
select cat from affiliate_directory where is_archived=0 and site_url != '' and (FIND_IN_SET('hoffman_estates', city) OR city='all' ) and (state='IL' OR state='Illinois' OR state='all')