San Diego, California Zip Codes: 91911,91915,91942,92014,92025,92027,92029,92037,92038,92039,92064,92065,92067,92071,92092,92093,92101,92102,92103,92104,92105,92106,92107,92108,92109,92110,92111,92112,92113,92114,92115,92116,92117,92118,92119,92120,92121,92122,92123,92124,92126,92127,92128,92129,92130,92131,92132,92133,92134,92137,92138,92139,92140,92142,92143,92145,92147,92149,92150,92152,92153,92154,92158,92159,92160,92161,92162,92163,92164,92165,92166,92167,92168,92169,92170,92171,92172,92173,92174,92175,92176,92177,92179,92182,92184,92186,92187,92190,92191,92192,92193,92194,92196,92197,92198,92199
select cat from directory where is_archived=0 and site_url != '' and (city='san diego' OR city='san_diego') and (state='CA' OR state='California')
select cat from directory where is_archived=0 and site_url != '' and (city='san diego' OR city='san_diego') and (state='CA' OR state='California')
union
select cat from affiliate_directory where is_archived=0 and site_url != '' and (FIND_IN_SET('san_diego', city) OR city='all' ) and (state='CA' OR state='California' OR state='all')