Welcome to Charleston, West Virginia
Charleston, West Virginia Zip Codes: 25301,25302,25303,25304,25305,25306,25309,25311,25312,25313,25314,25315,25317,25320,25321,25322,25323,25324,25325,25326,25327,25328,25329,25330,25331,25332,25333,25334,25335,25336,25337,25338,25339,25350,25356,25357,25358,25360,25361,25362,25364,25365,25375,25387,25389,25392,25396
select cat from directory where is_archived=0 and site_url != '' and (city='charleston' OR city='charleston') and (state='WV' OR state='West Virginia')
select cat from directory where is_archived=0 and site_url != '' and (city='charleston' OR city='charleston') and (state='WV' OR state='West Virginia')
union
select cat from affiliate_directory where is_archived=0 and site_url != '' and (FIND_IN_SET('charleston', city) OR city='all' ) and (state='WV' OR state='West Virginia' OR state='all')
56,181,119,107,227,75,163,168,867,1,66,790,80,1224,791,197,1242
select id,category_name,cat_img,catslug from directory_category where is_archived=0 and category_type='1' and id IN (56,1) ORDER BY `catorder` ASC Limit 0,2
(select id,site_url,local_address,com_name, COUNT(site_url) as com_num from directory
where is_archived=0 and site_url != '' and (city='medary' OR city='medary') and (state='SD' OR state='South Dakota') and cat='1' and sub_cat='24' and (sub_sub IS NULL OR sub_sub=0 )
Group by site_url order by com_name asc limit 0,100)
union
(select id,site_url,local_address,affiliate_name as com_name, COUNT(site_url) as com_num from affiliate_directory
where is_archived=0 and site_url != '' and (FIND_IN_SET('medary', city) OR city='all' ) and (state='SD' OR state='South Dakota' OR state='all') and cat='1' and sub_cat='24' and (sub_sub IS NULL OR sub_sub=0 )
GROUP BY site_url order by com_name asc)
-
Advertising Agencies
(select id,site_url,local_address,com_name, COUNT(site_url) as com_num from directory
where is_archived=0 and site_url != '' and (city='medary' OR city='medary') and (state='SD' OR state='South Dakota') and cat='56' and sub_cat='869' and (sub_sub IS NULL OR sub_sub=0 )
Group by site_url order by com_name asc limit 0,100)
union
(select id,site_url,local_address,affiliate_name as com_name, COUNT(site_url) as com_num from affiliate_directory
where is_archived=0 and site_url != '' and (FIND_IN_SET('medary', city) OR city='all' ) and (state='SD' OR state='South Dakota' OR state='all') and cat='56' and sub_cat='869' and (sub_sub IS NULL OR sub_sub=0 )
GROUP BY site_url order by com_name asc)
-
Educational Games
