SELECT dcr.*
			  FROM Data_Custom_Render dcr, CustomElementModules cem
			 WHERE (dcr.PageID IN (55290,57290,58291)) 
				AND dcr.VersionState=?
				AND (dcr.ModuleID = cem.ID OR dcr.ModuleID <= 0)
		 ORDER BY dcr.ControlID, dcr.PageID DESC, dcr.VersionID DESC
		

			SELECT ControlID,ControlName
			  FROM ControlInstance
			 WHERE (PageID IN (55290,57290,58291)) 
		 ORDER BY PageID DESC
		

		SELECT d1.ID,
				 d1.FormName,
				 d1.Method,
				 d1.Action,
				 d1.JSHandler,
				 d1.DateCreated,
				 d1.DateLastModified,
				 d1.Params,
				 d1.OwnerID,
			
				 d4.ClassConstant as Class,
				 d4.ClassID,
			
				 d2.ID as inputID,
				 d2.fieldName,
				 d2.shared,
				 d3.formID,
				 d3.itemPos,
				 d3.TabID,
				 d5.TabDisplayName,
				 d5.TabSortName,
				 d2.type as inputType,
				 d2.params as inputParams,
				 d2.dateCreated as inputCreated,
				 d2.description,
				 d2.dateLastModified as inputLastModified
		  FROM formControl d1, formInputControl d2, formInputControlMap d3,
		  formControlMap d4, FormControlTabs d5
		 WHERE d3.fieldID = d2.ID
			AND d1.ID = d3.formID
		
			AND d1.ID = d4.formID
		
			AND d5.ID = d3.TabID
				and d4.classConstant in ( 7 ) and d4.classID = 7655 order by d1.id, d2.id 

			SELECT *
			  FROM RestrictedSecurity
			 WHERE PageID IN (57290,55290) 

		SELECT DISTINCT ControlID
		  FROM ItemSecurity
		 WHERE
			(
				((ApplyTo=?)
					AND (PageID=?))
				OR
				((ApplyTo=?)
					AND (PageID IN (57290,55290)))
			)
			AND ControlID<>0
	

			SELECT ControlID,
					 Max(pRead) AS maxRead,
					 Max(pAuthor) AS maxAuthor,
					 Max(pEdit) AS maxEdit,
					 Max(pDesign) AS maxDesign,
					 Max(pStyle) AS maxStyle,
					 Max(pAdmin) AS maxAdmin,
					 Max(pApprove) AS maxApprove
			  FROM ItemSecurity
			 WHERE ( (UserGroupID = ?) )
		      AND
				(
					((ApplyTo=?)
						AND (PageID=?))
					OR
					((ApplyTo=?)
						AND (PageID IN (57290,55290)))
				)
				AND ControlID<>0
		 GROUP BY ControlID
		

			SELECT ID, Name, InheritedTemplateList, PageType
			  FROM SitePages
			 WHERE ID = ? 

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ?
		AND (PageID IN (58291,57290,55290)  AND (VersionState = 2)) AND ((((PageID=58291) AND (VersionState >= 2)) OR (PageID IN (57290,55290) AND (VersionState = 2))))
 ORDER BY PageID DESC, VersionID DESC, Sort1, Sort2 

		SELECT *
		  FROM Param_WDDX
		 WHERE PageID=0
			AND ControlID=0
			AND ItemID=? 

	SELECT *
	  FROM Data_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ?
		AND (PageID IN (58291,57290,55290)  AND (VersionState = 2)) AND ((PageID=58291 OR (PageID IN (57290,55290) AND (VersionState = 2))))
 ORDER BY PageID DESC, VersionID DESC, Sort1, Sort2 

	SELECT ID, ParentID
	  FROM SubSites
	 WHERE ParentID = ?
		AND SiteState = 1

		SELECT expDate
		  FROM SitePages
		 WHERE expDate IS NOT NULL
			AND expDate > ?
	 ORDER BY expDate
	

		SELECT PublicReleaseDate
		  FROM SitePages
		 WHERE PublicReleaseDate IS NOT NULL
			AND PublicReleaseDate > ?
	 ORDER BY PublicReleaseDate
	

		    SELECT
		SitePages.*, DocCategories.Category  FROM DocCategories,SitePages
 WHERE (DocCategories.ID = SitePages.CategoryID)  AND  AudienceID = 0
	AND (((SitePages.ApprovalStatus=0 AND SitePages.AudienceID=0 AND sitePages.subSiteID <> 0 AND SitePages.PageSetID = 0)
			AND ((SitePages.PageType = 0) OR (SitePages.PageType IN (6,8))) AND SitePages.PageType NOT IN (4,9) AND (  SitePages.ID in (select pageID from Data_FieldValue where Data_FieldValue.fieldID = 51999 AND Data_FieldValue.formID = 6855 AND Data_FieldValue.VersionState >= 2 AND (Data_FieldValue.fieldValue = '- Parental Choice'))  and  SitePages.ID NOT in (select pageID from Data_FieldValue where Data_FieldValue.fieldID = 6864 AND Data_FieldValue.formID = 6855 AND Data_FieldValue.VersionState >= 2 AND (Data_FieldValue.fieldValue = 'Executive Summary'))  ) AND (SitePages.IsPublic IN (1,3,5,7,9,11,13,15)))) AND (SitePages.ExpDate >= '2008-05-17 00:00:00' OR SitePages.ExpDate IS NULL) AND (SitePages.PublicReleaseDate < '2008-05-17 13:15:12') AND (SitePages.ID <> 58291) 
	 ORDER BY SitePages.Title asc 

		SELECT DISTINCT LastName, FirstName, ContactID
		  FROM Contacts
		 WHERE (ContactID  IN (1000002,1000016,1000047,1000074,1000123)) 

		SELECT *
		  FROM Formats
	

	select sitepages.id, 
			   subsites.subsiteurl, 
			   sitepages.filename,
			   data_fieldvalue.fieldvalue,
			   sitepages.description
	from sitepages, subsites, data_fieldvalue, forminputcontrol
	where sitepages.subsiteid = subsites.id
	and sitepages.id = data_fieldvalue.pageid
	and data_fieldvalue.fieldid = forminputcontrol.ID
	and data_fieldvalue.versionstate = 2
	and forminputcontrol.fieldname = 'FIC_Date'
	and sitepages.id in (76468,55334,97846,4761,102291,77490,55017,46113,46452,8512,52520,7732,16946,166437,61811,68519,198524,48304,77138,209482,19359,72724,39047,96126,59471,114071,220877,7580,7716,144522,68449,72868,0)
	order by fieldvalue desc

	SELECT 	
					Data_FieldValue.pageid, 
					Data_fieldvalue.formid,
					Data_fieldvalue.fieldid,
					data_fieldvalue.fieldvalue,
					forminputcontrol.fieldname
					
	  FROM 	data_fieldvalue,
					forminputcontrol
					
	 WHERE 
	 				data_fieldvalue.fieldid = forminputcontrol.id
					and data_fieldvalue.versionstate = 2
					AND Data_fieldvalue.formid in (6855,4500) 
					and data_fieldvalue.pageid in (76468,55334,97846,4761,102291,77490,55017,46113,46452,8512,52520,7732,16946,166437,61811,68519,198524,48304,77138,209482,19359,72724,39047,96126,59471,114071,220877,7580,7716,144522,68449,72868,0)
					and forminputcontrol.fieldname in ('FIC_Date','FIC_Title','FIC_Author','FIC_papertype','FIC_papernum')
					order by pageid,formid,fieldid

				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 

Application Variables:
activesubsites=1,3,4,5,6,7,8,9,10,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,61,62,63,64,66,68,69,70,72,73,74,75,76,77,78,79,80,81,82,83,84,85,87,88,89,90,91,92,93,94,95,96,97,98,99,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144
anonitemsecurity=Struct (8)
anonrights=Struct (7)
anonsubsiteperms=Struct (135)
anonsubsitesecurity=Struct (135)
applicationname=site2
cachedimages=Struct (96)
cacheinfo=Struct (14784)
cachevalid=1
confidentiality=Array (5)
controlinstance_toplevel=Struct (2)
cs=Struct (11)
cs_element_cache=Struct (0)
defaultconfidentiality=5
defaultstructs=Struct (6)
docsdump=Complex type
dodump=Complex type
dolog=Complex type
getid=Struct (4)
gettaxonomyannotlookup=Complex type
imagegallerylists=Struct (0)
languages=Struct (11)
lastknownchange=Struct (19)
lastupdate=Struct (15)
lookuptaxonomyannot=Complex type
masterrendersequence=77435
metadatacache=Struct (0)
nextcheck=Struct (1)
serverclockcheck=2008-05-16 17:27:22
servervalidationcode=1029RTN7H3C5C265DONPR3CT2
site=Struct (47)
styleids=Struct (206)
stylenames=Struct (206)
subsitecache=Struct (135)
templaterenderoptions=Struct (70)
transactionlog=Struct (112)
translations=Struct (4)

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\websites\heritage.org\Research\Education\Parchoice.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=Accept: application/xhtml+xml,text/html;q=0.9,text/plain;
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=author.heritage.org
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=/research/education/parchoice.cfm
PATH_TRANSLATED=D:\websites\heritage.org\Research\Education\Parchoice.cfm
QUERY_STRING=
REMOTE_ADDR=10.10.41.254
REMOTE_HOST=10.10.41.254
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/research/education/parchoice.cfm
SERVER_NAME=author.heritage.org
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=

Cookie Variables:
CFID=7952845
CFTOKEN=95785978

Request Parameters:
applockname=CS_App_Site2_1
approvalneededlist=
approvedlist=
author_approve_whereclause=(VersionState = 2)
authormode=0
authorok=1
basehref=/
blupfront=
browser=Struct (9)
browserisie=0
buildingcache=0
cacheinfo=Struct (8)
constants=Struct (185)
controlswhereuserisowner=
cp=Struct (110)
ctrl_data=Struct (173)
ctrlinstupfront=Query (173)
customerinfo=Struct (25)
debugmode=0
dhtmlmenuitemsprefetch=
disablehideformenus=0
editmode=0
element=Struct (10)
elementadminlist=
elementapprovelist=
elementauthorlist=
elementcommentlist=
elementdesignlist=
elementeditlist=
elementreadlist=
elementrestrictedadminlist=0
elementrestrictedauthorlist=0
elementrestricteddesignlist=0
elementrestrictedstylelist=0
elementstylelist=
fnsequence=1
formattedtimestamp=2008-05-17 13:15:12
getghost=
gvpageid=58291
ignoreauthuser=0
imageupfront=
includedmodules=
includedobjects=nwjs,pgIndexJS
initialsiteid=2
initialsubsiteid=7
itemsecurity=Struct (8)
jswarnmessage=
knownsecurecontrols=
linkdataupfront_itempos=
linkdataupfront_itemtitle=
lockid=0
master_cfm_used=1
masterrendersequence=77435
maxadmin=0
maxapprove=0
maxauthor=0
maxcomment=0
maxdesign=0
maxedit=0
maxhistory=0
maxperms=Struct (9)
maxstyle=0
minperms=Struct (9)
modeorderbyclause=VersionID Desc
modeorderbyclause_page=VersionID Desc
modewhereclause=(VersionState = 2)
modewhereclause_page=(VersionState = 2)
multisectionupfront=
nocacheelementtypes=
openelements=
page=Struct (92)
pagedata=Struct (8)
pagedhtmlitems=
pagedhtmlmenus=
pageperms=Struct (9)
pagerestrictedadmin=0
pagerestrictedauthor=0
pagerestricteddesign=0
pagerestrictedstyle=0
previewon=1
readmodewhereclause=(VersionState = 2)
renderedelements=Struct (0)
renderelementdata=Struct (0)
renderfordiff=0
renderforprint=0
renderstate=Struct (2)
requestedversiontimestamp=
scheduleupfront=
securitydetailrun=1
sequenceid=388402
sessionlockname=Session_1_7952845_95785978
sessionstring=1_7952845_95785978
sicupfront=
sicupfrontparam=
site=Struct (47)
siteid=2
structdoctypes=Struct (76)
structowners=Struct (5)
styleids=Struct (206)
stylenames=Struct (206)
subsite=Struct (56)
subsitecache=Struct (135)
subsiteid=7
subsiteperms=Struct (135)
subsiterights=Struct (14)
subsitesecurity=Struct (2)
subsitesecuritycache=Struct (135)
taiupfrontparam=
tbupfront=
tbupfrontparam=
thecontrolid=57300
timestamp={ts '2008-05-17 13:15:12'}
udslockname=CS_Customer_commonspot-users
uipath=/ui/
updatingschemas=0
usedelementnames=
user=Struct (18)
usersdatasource=commonspot-users
vcontrolid=57300
vinheritancelist=58291,57290,55290
wanterrorsrethrown=0
warnmessage=
xhighlightcontrol=

Server Variables:
COLDFUSION=Struct (8)
COMMONSPOT=Struct (2)
OS=Struct (5)

Session Variables:
authormode=0
browser=Struct (9)
cfid=7952845
cftoken=95785978
currentpageid=58291
debugmode=0
debugmode_control=0
editmode=0
hasusertempfiles=0
lastupdate=Struct (6)
lastuserupdate=1211044512359
lockid=0
lockobjectid=0
lockobjecttype=page
locktype=temp
logintime=
pagedata=
pendingapprovalpages=
pendingapprovals=
previewon=1
requestedversioncounter=
requestedversiontimestamp=
sessionid=SITE2_7952845_95785978
urltoken=CFID=7952845&CFTOKEN=95785978
usagelist=
user=Struct (18)