Staten Island, New York Zip Codes: 10301,10302,10303,10304,10305,10306,10307,10308,10309,10310,10311,10312,10313,10314
select cat from directory where is_archived=0 and site_url != '' and (city='staten island' OR city='staten_island') and (state='NY' OR state='New York')
select cat from directory where is_archived=0 and site_url != '' and (city='staten island' OR city='staten_island') and (state='NY' OR state='New York')
union
select cat from affiliate_directory where is_archived=0 and site_url != '' and (FIND_IN_SET('staten_island', city) OR city='all' ) and (state='NY' OR state='New York' OR state='all')