SELECT * FROM homepage WHERE subSiteID = #subSiteID# AND live = TRUE SELECT * FROM news WHERE subSite = #subSiteID# AND liveSub = TRUE AND newsDate <= #now()# AND archiveDate >= #now()# ORDER BY dateCreated DESC SELECT pageTitle, pageID FROM page WHERE subSiteID = #subSiteID# AND (page = 24 OR page = 25 OR page = 26) SELECT * FROM gen WHERE subSite = #subSiteID# AND liveSub = TRUE AND archiveDate >= #now()# ORDER BY dateCreated DESC SELECT * FROM articles WHERE subSite = #subSiteID# AND liveSub = TRUE AND archiveDate >= #now()# ORDER BY dateCreated DESC SELECT * FROM reports WHERE subSiteID = #subSiteID# AND live = TRUE AND archiveDate >= #now()# ORDER BY datePosted DESC SELECT pageTitle, pageID FROM page WHERE subSiteID = #subSiteID# AND (page = 20 OR page = 28 OR page = 30) SELECT * FROM aa WHERE subSite = #subSiteID# AND liveSub = TRUE AND aaArchiveDate >= #now()# ORDER BY dateCreated DESC SELECT pageTitle, pageID FROM page WHERE subSiteID = #subSiteID# AND (page = 3 OR page = 4 OR page = 5 OR page = 11 OR page = 32) SELECT * FROM journal WHERE subSiteID = #subSiteID# AND liveSub = TRUE AND current = TRUE







 


#content#
SELECT pageid, page, pageTitle FROM page WHERE subSiteID=#subSiteID# AND page IN (24,25,26) AND live=TRUE SELECT pageid, page, pageTitle FROM page WHERE subSiteID=#subSiteID# AND page IN (3,4,5,11,32) AND live=TRUE SELECT pageid, page, pageTitle FROM page WHERE subSiteID=#subSiteID# AND page IN (20,28,30) AND live=TRUE
whiteblack">Special Features

#DateFormat(dateCreated, "mmmm d, yyyy")# - #generalTitle#: #generalSubtitle#
whiteblack">#getNewsTitle.pageTitle#

#DateFormat(newsDate, "mm/dd/yy")# - #newsTitle#: #newsSubtitle#
whiteblack">#getAATitle.pageTitle#

#DateFormat(dateCreated, "mm/dd/yy")# - #aaTitle#: #aaSubtitle#
whiteblack">#getArticleTitle.pageTitle#

Current Newsletter

#journalTitle#: #journalDate#, Vol. #journalVol#, No. #journalNo#

Reports

#DateFormat(datePosted, "mm/dd/yy")# - #title#: #subtitle#