Welcome to Salt Lake City, Utah
Salt Lake City, Utah Zip Codes: 84044,84101,84102,84103,84104,84105,84106,84108,84109,84110,84111,84112,84113,84114,84115,84116,84119,84120,84122,84128,84132,84133,84134,84136,84138,84139,84143,84144,84145,84147,84148,84150,84151,84152,84158,84180,84189
select cat from directory where is_archived=0 and site_url != '' and (city='salt lake city' OR city='salt_lake_city') and (state='UT' OR state='Utah')
select cat from directory where is_archived=0 and site_url != '' and (city='salt lake city' OR city='salt_lake_city') and (state='UT' OR state='Utah')
union
select cat from affiliate_directory where is_archived=0 and site_url != '' and (FIND_IN_SET('salt_lake_city', city) OR city='all' ) and (state='UT' OR state='Utah' OR state='all')
56,181,119,1,107,227,75,163,168,867,156,66,790,197,80,1224,791,1242,1255
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='south end' OR city='south_end') and (state='MN' OR state='Minnesota') 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('south_end', city) OR city='all' ) and (state='MN' OR state='Minnesota' 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='south end' OR city='south_end') and (state='MN' OR state='Minnesota') 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('south_end', city) OR city='all' ) and (state='MN' OR state='Minnesota' 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
