SELECT TOP 10 dbo.Partners.PartnerName AS MFGname, dbo.reviewitem.mfg AS MFG_ID FROM dbo.reviewitem INNER JOIN dbo.Partners ON dbo.reviewitem.mfg = dbo.Partners.PartnerID GROUP BY dbo.Partners.Points, dbo.Partners.PartnerName, dbo.reviewitem.mfg ORDER BY dbo.Partners.Points desc SELECT TOP 10 dbo.Partners.PartnerName AS MFGname, dbo.reviewitem.mfg AS MFG_ID FROM reviewitem INNER JOIN dbo.Partners ON dbo.reviewitem.mfg = dbo.Partners.PartnerID GROUP BY dbo.Partners.Points, dbo.Partners.PartnerName, dbo.reviewitem.mfg ORDER BY dbo.Partners.Points desc select top 7 * from photoalbums where startdate <= #CreateODBCDate(now())# and (enddate >= #CreateODBCDate(now())# or enddate is NULL) order by startdate desc select top 7 * from photoalbums where startdate <= #CreateODBCDate(now())# and (enddate >= #CreateODBCDate(now())# or enddate is NULL) order by startdate desc SELECT Section.SectionName, dbo.articleplacement.placementID, dbo.articles.title,dbo.articles.aid, dbo.articles.ImageLoc, dbo.articles.shortsummary, dbo.articles.summary FROM Section INNER JOIN dbo.articleplacement ON Section.SectionID = dbo.articleplacement.section INNER JOIN dbo.articles ON dbo.articleplacement.articleID = dbo.articles.aid where articleplacement.section = 62 and (articleplacement.startdate <= #CreateODBCDate(now())# and articleplacement.enddate >= #CreateODBCDate(now())#) and articleplacement.subassoc = 94 Order by articleplacement.startdate desc, articleplacement.placementID desc SELECT Section.SectionName, dbo.articleplacement.placementID, dbo.articles.title, dbo.articles.aid, dbo.articles.shortsummary, dbo.articles.ImageLoc, dbo.articles.summary FROM Section INNER JOIN dbo.articleplacement ON Section.SectionID = dbo.articleplacement.section INNER JOIN dbo.articles ON dbo.articleplacement.articleID = dbo.articles.aid where articleplacement.section = 62 and (articleplacement.startdate <= #CreateODBCDate(now())# and articleplacement.enddate >= #CreateODBCDate(now())#) and articleplacement.subassoc = 94 Order by articleplacement.startdate desc, articleplacement.placementID desc SELECT top 20 Section.SectionName, dbo.articleplacement.placementID, dbo.articles.title, dbo.articles.ImageLoc, dbo.articles.summary, dbo.articles.shortname FROM Section INNER JOIN dbo.articleplacement ON Section.SectionID = dbo.articleplacement.section INNER JOIN dbo.articles ON dbo.articleplacement.articleID = dbo.articles.aid where articleplacement.section = 62 and (articleplacement.startdate <= #CreateODBCDate(now())# and (articleplacement.enddate >= #CreateODBCDate(now())#) or articleplacement.enddate is NULL) and articles.aid NOT IN #usedArticles# Order by articleplacement.startdate desc SELECT top 20 Section.SectionName, dbo.articleplacement.placementID, dbo.articles.title, dbo.articles.ImageLoc, dbo.articles.summary, dbo.articles.shortname FROM Section INNER JOIN dbo.articleplacement ON Section.SectionID = dbo.articleplacement.section INNER JOIN dbo.articles ON dbo.articleplacement.articleID = dbo.articles.aid where articleplacement.section = 62 and (articleplacement.startdate <= #CreateODBCDate(now())# and (articleplacement.enddate >= #CreateODBCDate(now())#) or articleplacement.enddate is NULL) and articles.aid NOT IN #usedArticles# Order by articleplacement.startdate desc SELECT TOP 1 Section.SectionName, dbo.articleplacement.placementID, dbo.articles.title, dbo.articles.ImageLoc FROM Section INNER JOIN dbo.articleplacement ON Section.SectionID = dbo.articleplacement.section INNER JOIN dbo.articles ON dbo.articleplacement.articleID = dbo.articles.aid INNER JOIN dbo.users ON dbo.articles.author = dbo.users.uid where articleplacement.section = 85 and (articleplacement.startdate <= #CreateODBCDate(now())#) Order by articleplacement.startdate desc SELECT TOP 1 Section.SectionName, dbo.articleplacement.placementID, dbo.articles.title, dbo.articles.ImageLoc FROM Section INNER JOIN dbo.articleplacement ON Section.SectionID = dbo.articleplacement.section INNER JOIN dbo.articles ON dbo.articleplacement.articleID = dbo.articles.aid INNER JOIN dbo.users ON dbo.articles.author = dbo.users.uid where articleplacement.section = 85 and (articleplacement.startdate <= #CreateODBCDate(now())#) Order by articleplacement.startdate desc SELECT Section.SectionName, dbo.articleplacement.articleID, dbo.articles.title, articles.body, dbo.articles.ImageLoc FROM Section INNER JOIN dbo.articleplacement ON Section.SectionID = dbo.articleplacement.section INNER JOIN dbo.articles ON dbo.articleplacement.articleID = dbo.articles.aid where articleplacement.section = 65 and (articleplacement.startdate <= #CreateODBCDate(now())# and articleplacement.enddate >= #CreateODBCDate(now())#) SELECT DISTINCT Section.SectionName, Section.SectionID, Section.DisplayOrder FROM reviewitem INNER JOIN Section ON reviewitem.sectionID = Section.SectionID ORDER BY section.displayorder, Section.SectionID SELECT DISTINCT Section.SectionName, Section.SectionID, reviewitem.id, Section.DisplayOrder FROM reviewitem INNER JOIN Section ON reviewitem.sectionID = Section.SectionID ORDER BY section.displayorder, Section.SectionID SELECT top 7 Section.SectionName, dbo.articleplacement.placementID, dbo.articles.title, dbo.users.user_id, dbo.articles.ImageLoc FROM Section INNER JOIN dbo.articleplacement ON Section.SectionID = dbo.articleplacement.section INNER JOIN dbo.articles ON dbo.articleplacement.articleID = dbo.articles.aid INNER JOIN dbo.users ON dbo.articles.author = dbo.users.uid where (articleplacement.section = 68) and (articleplacement.subassoc = 105) and (articleplacement.startdate <= #CreateODBCDate(now())#) and ((articleplacement.enddate >= #CreateODBCDate(now())#) or articleplacement.enddate is NULL) Order by articleplacement.startdate desc SELECT top 7 Section.SectionName, dbo.articleplacement.placementID, dbo.articles.title, dbo.users.user_id, dbo.articles.ImageLoc FROM Section INNER JOIN dbo.articleplacement ON Section.SectionID = dbo.articleplacement.section INNER JOIN dbo.articles ON dbo.articleplacement.articleID = dbo.articles.aid INNER JOIN dbo.users ON dbo.articles.author = dbo.users.uid where (articleplacement.section = 68) and (articleplacement.subassoc = 105) and (articleplacement.startdate <= #CreateODBCDate(now())#) and ((articleplacement.enddate >= #CreateODBCDate(now())#) or articleplacement.enddate is NULL) Order by articleplacement.startdate desc SELECT area, item_id, approved, enddate, link_click, link_photo, text FROM dbo.hot_items Where startdate <= #CreateODBCDate(now())# and enddate >= #CreateODBCDate(now())# ORDER by AREA SELECT area, item_id, approved, enddate, link_click, link_photo, text FROM dbo.hot_items Where startdate <= #CreateODBCDate(now())# and enddate >= #CreateODBCDate(now())# ORDER by AREA SELECT TOP 1 area, item_id, approved, enddate, link_click, link_photo, text FROM dbo.hot_items Where area = 5 ORDER by enddate desc SELECT top 6 dbo.articleplacement.section, dbo.articleplacement.placementid, dbo.articleplacement.subassoc, dbo.articleplacement.detailassoc, dbo.articles.title, dbo.articles.summary, dbo.articles.body, dbo.articleplacement.startdate, dbo.articleplacement.enddate, dbo.articles.author, articles.aid FROM dbo.articleplacement INNER JOIN dbo.articles ON dbo.articleplacement.articleID = dbo.articles.aid WHERE articleplacement.StartDate <= #CreateODBCDate(now())# and articleplacement.section = 73 ORDER by articleplacement.StartDate desc SELECT top 6 dbo.articleplacement.section, dbo.articleplacement.placementid, dbo.articleplacement.subassoc, dbo.articleplacement.detailassoc, dbo.articles.title, dbo.articles.summary, dbo.articles.body, dbo.articleplacement.startdate, dbo.articleplacement.enddate, dbo.articles.author, articles.aid FROM dbo.articleplacement INNER JOIN dbo.articles ON dbo.articleplacement.articleID = dbo.articles.aid WHERE articleplacement.StartDate <= #CreateODBCDate(now())# and articleplacement.section = 73 ORDER by articleplacement.StartDate desc

	Welcome #session.name#!		Headlines for #dateformat(now(),"mm/dd/yy")#
	#hot_items.text#		#dailybuzz.title# #dailybuzz.summary# Full Story  More News #dailybuzz.title# #dailybuzz.shortsummary# Full Story More News Mailbag:·#title# More Letters

Guns & Gear: #hot_items.text# WEEKLY GEAR REVIEW: #WeeklyGearReview.title# #WeeklyGearReview.summary# Full Story More Reviews Product Reviews: , #trim(SectionName)#

Feature Stories: #hot_items.text# ·#Title# More Features

News: ·#shortname# ·#shortname#   More News Mailbag: ·#title#   More Letters

Events: #hot_items.text# ·#title# More Events International Tournament Series: Millennium, NPPL & PSP Regional Events & Series: XPSL, NWTS, PES, WPF & Others

Photo Galleries: #hot_items.text# ·#title# More Galleries

Field of the Week: #fieldoftheweek.Title# - #fieldoftheweek.body#

#cfid# - session:#session.cfid# cookie:#cookie.cfid#none#session.name#

#myrand#