Charlottesville, Virginia Zip Codes: 22901,22902,22903,22904,22905,22906,22907,22908,22909,22910,22911
select cat from directory where is_archived=0 and site_url != '' and (city='charlottesville' OR city='charlottesville') and (state='VA' OR state='Virginia')
select cat from directory where is_archived=0 and site_url != '' and (city='charlottesville' OR city='charlottesville') and (state='VA' OR state='Virginia')
union
select cat from affiliate_directory where is_archived=0 and site_url != '' and (FIND_IN_SET('charlottesville', city) OR city='all' ) and (state='VA' OR state='Virginia' OR state='all')