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#
http://www.earthislandprojects.org/project/viewProject.cfm?subSiteID=7
www.earthislandprojects.org
crawl=CC-MAIN-2017-13
10128
application/http; msgtype=response
sha1:KR2OIF7HJR22MIVKNF2O253I3DHTFD6P
<urn:uuid:c8ad8083-0008-4c7b-b937-642ef96dada2>
2017-03-27T14:31:11Z
69.163.163.245
sha1:2FOPS5H2RX44Z3SPJYPEF4VRX4VC5NZ4
<urn:uuid:874b89a9-14ea-4e71-a151-f64446f9d9cf>
http://www.earthislandprojects.org/project/viewProject.cfm?subSiteID=7
response
<urn:uuid:6eda1965-7f70-43a4-af79-686c6982ce34>
robots: classic
hostname: ip-10-233-31-227.ec2.internal
software: Nutch 1.6 (CC)/CC WarcExport 1.0
isPartOf: CC-MAIN-2017-13
operator: CommonCrawl Admin
description: Wide crawl of the web for March 2017
publisher: CommonCrawl
format: WARC File Format 1.0
conformsTo: http://bibnum.bnf.fr/WARC/WARC_ISO_28500_version1_latestdraft.pdf