Oakland, California Zip Codes: 94502,94601,94602,94603,94604,94605,94606,94607,94608,94609,94610,94611,94612,94613,94614,94615,94617,94618,94619,94620,94621,94622,94623,94624,94625,94649,94659,94660,94661,94666,94704,94705
select cat from directory where is_archived=0 and site_url != '' and (city='oakland' OR city='oakland') and (state='CA' OR state='California')
select cat from directory where is_archived=0 and site_url != '' and (city='oakland' OR city='oakland') and (state='CA' OR state='California')
union
select cat from affiliate_directory where is_archived=0 and site_url != '' and (FIND_IN_SET('oakland', city) OR city='all' ) and (state='CA' OR state='California' OR state='all')