SELECT dcr.*
			  FROM Data_Custom_Render dcr, CustomElementModules cem
			 WHERE (dcr.PageID IN (1,2,7,801)) 
				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 (1,2,7,801)) 
		 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 (7,2,1) 

		SELECT DISTINCT ControlID
		  FROM ItemSecurity
		 WHERE
			(
				((ApplyTo=?)
					AND (PageID=?))
				OR
				((ApplyTo=?)
					AND (PageID IN (7,2,1)))
			)
			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 (7,2,1)))
				)
				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 (801,7,2,1)  AND (VersionState = 2)) AND ((((PageID=801) AND (VersionState >= 2)) OR (PageID IN (7,2,1) 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 (801,7,2,1)  AND (VersionState = 2)) AND ((PageID=801 OR (PageID IN (7,2,1) 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 = 6858 AND Data_FieldValue.formID = 6855 AND Data_FieldValue.VersionState >= 2 AND Data_FieldValue.fieldValue >= '2008-05-12 00:00:00' AND Data_FieldValue.fieldValue <= '2008-05-20 15:07:22')  and  ((SitePages.CategoryID not in (8)) OR (SitePages.CategoryID = 0))  ) AND (SitePages.IsPublic IN (1,3,5,7,9,11,13,15)))) AND (SitePages.ExpDate >= '2008-05-20 00:00:00' OR SitePages.ExpDate IS NULL) AND (SitePages.PublicReleaseDate < '2008-05-20 15:07:22') 
	 ORDER BY SitePages.Title asc 

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

		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 (240422,240102,241001,240922,241042,240295,239904,240603,239981,240140,240081,240543,240463,240648,240018,240382,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 (240422,240102,241001,240922,241042,240295,239904,240603,239981,240140,240081,240543,240463,240648,240018,240382,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 = ? 

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

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ?
		AND (PageID IN (801,7,2,1)  AND (VersionState = 2)) AND ((((PageID=801) AND (VersionState >= 2)) OR (PageID IN (7,2,1) 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 (801,7,2,1)  AND (VersionState = 2)) AND ((PageID=801 OR (PageID IN (7,2,1) AND (VersionState = 2))))
 ORDER BY PageID DESC, VersionID DESC, Sort1, Sort2 

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

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

	SELECT *
	  FROM Data_CustomCF
	 WHERE (PageID=801 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY ControlID, PageID DESC, VersionID DESC 

			SELECT DISTINCT ControlID
			  FROM ItemSecurity
			 WHERE ((PageID = ? AND ApplyTo=0)
						OR ( (PageID IN (1,2,7,801)) 
							AND ApplyTo = 1))
			   AND ControlID <> 0
			   AND pRead=0
				AND pAuthor=0
				AND pEdit=0
				AND pDesign=0
				AND pApprove=0
				AND pAdmin=0
		

				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 (103)
cacheinfo=Struct (14798)
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=113146
metadatacache=Struct (0)
nextcheck=Struct (1)
serverclockcheck=2008-05-20 14:56:26
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\Press\index.cfm
CONTENT_LENGTH=0
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=/press/index.cfm
PATH_TRANSLATED=D:\websites\heritage.org\Press\index.cfm
QUERY_STRING=
REMOTE_ADDR=10.10.41.254
REMOTE_HOST=10.10.41.254
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/press/index.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=8101459
CFTOKEN=67256816

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 (18)
constants=Struct (185)
controlswhereuserisowner=
cp=Struct (110)
ctrl_data=Struct (464)
ctrlinstupfront=Query (464)
customcf_data=Struct (1)
customcfupfront=Query (5)
customerinfo=Struct (25)
debugmode=0
dhtmlmenuitemsprefetch=
disablehideformenus=0
editmode=0
element=Struct (10)
elementadminlist=
elementapprovelist=
elementauthorlist=
elementcommentlist=
elementdesignlist=
elementeditlist=
elementreadlist=
elementrestrictedadminlist=0,791,793,803,827,832,834,846,936
elementrestrictedauthorlist=0,791,793,803,827,832,834,846,936
elementrestricteddesignlist=0,791,793,803,827,832,834,846,936
elementrestrictedstylelist=0,791,793,803,827,832,834,846,936
elementstylelist=
fnsequence=4
formattedtimestamp=2008-05-20 15:07:22
getghost=
gvpageid=801
ignoreauthuser=0
imageupfront=
includedmodules=
includedobjects=nwjs,pgIndexJS
initialsiteid=2
initialsubsiteid=4
itemsecurity=Struct (8)
jswarnmessage=
knownsecurecontrols=
linkdataupfront_itempos=
linkdataupfront_itemtitle=
lockid=0
master_cfm_used=1
masterrendersequence=113146
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 (93)
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=540438
sessionlockname=Session_1_8101459_67256816
sessionstring=1_8101459_67256816
sicupfront=
sicupfrontparam=
site=Struct (47)
siteid=2
structdoctypes=Struct (76)
structowners=Struct (2)
styleids=Struct (206)
stylenames=Struct (206)
subsite=Struct (56)
subsitecache=Struct (135)
subsiteid=4
subsiteperms=Struct (135)
subsiterights=Struct (14)
subsitesecurity=Struct (2)
subsitesecuritycache=Struct (135)
taiupfrontparam=
tbupfront=
tbupfrontparam=
thecontrolid=34114
timestamp={ts '2008-05-20 15:07:22'}
udslockname=CS_Customer_commonspot-users
uipath=/ui/
updatingschemas=0
usedelementnames=sideNavElement_common
user=Struct (18)
usersdatasource=commonspot-users
vcontrolid=25470
vinheritancelist=801,7,2,1
wanterrorsrethrown=0
warnmessage=
xhighlightcontrol=

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

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