SELECT *
				  FROM Param_Page
				 WHERE (PageID=220205 OR (PageID IN (5472,7,2,1) AND (VersionState = 2)))
				   AND VersionState=2
	 		 ORDER BY PageID DESC
			

	SELECT Data_FieldValue.FieldValue,FormInputControl.FieldName,FormInputControl.type,FormControl.FormName,
			 FormControl.ID AS FormControlID, FormInputControl.ID AS ficID,
			 Data_FieldValue.MemoValue, Data_FieldValue.listid
	  FROM FormInputControl,FormControl,FormInputControlMap,Data_FieldValue,FormControlMap
	 WHERE Data_FieldValue.PageID = ?
		AND Data_FieldValue.FieldID = FormInputControl.ID
		AND Data_FieldValue.FormID = FormControl.ID
		AND FormInputControl.ID = FormInputControlMap.FieldID
		AND FormControl.ID = FormInputControlMap.FormID
		AND FormControl.ID = FormControlMap.FormID
		AND (
				((FormControlMap.ClassConstant = 4)
			
				AND (FormControlMap.ClassID IN (1,4,140)) 
			)
	
			OR ((FormControlMap.ClassConstant = 1) AND ( (FormControlMap.ClassID IN (1,2,7,5472)) ))
	
			OR ((FormControlMap.ClassConstant = 2) AND (FormControlMap.ClassID = ?))
	
			 )
 ORDER BY FormControl.ID, FormInputControl.ID

			select Title, FirstName, MI, LastName, Suffix, BioPageLink from tblStaff INNER JOIN 
			tblPaperAuthors ON tblStaff.StaffID = tblPaperAuthors.StaffID
			WHERE SitePagesID = 220205
			ORDER BY SortOrder
		

   SELECT PageID,VersionState,AuthorID
     FROM Data_Menu_Items
    WHERE ControlID=?
		AND (PageID=220205 OR (PageID IN (5472,7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY PageID Desc

		SELECT *
		FROM Param_WDDX
		WHERE (PageID=220205 OR (PageID IN (5472,7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
			AND ElementTypeID = ?
			AND ControlID > 0
		ORDER BY ControlID, PageID DESC
	

	SELECT *
	  FROM Data_Menu_Items
	 WHERE (PageID=220205 OR (PageID IN (5472,7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY ControlID, PageID DESC, ItemPos,VersionID DESC 

		SELECT PageID,ControlID,ItemID,Max(VersionID) AS MaxVersion
		  FROM Data_Menu_Items
		 WHERE (PageID=220205 OR (PageID IN (5472,7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2) 
	 GROUP BY PageID,ControlID,ItemID
	

			SELECT ControlID,ControlName
			  FROM ControlInstance
			 WHERE (PageID IN (1,2,7,5472,220205)) 
		 ORDER BY PageID DESC
		

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

			SELECT *
			  FROM RestrictedSecurity
			 WHERE PageID IN (5472,7,2,1) 

		SELECT DISTINCT ControlID
		  FROM ItemSecurity
		 WHERE
			(
				((ApplyTo=?)
					AND (PageID=?))
				OR
				((ApplyTo=?)
					AND (PageID IN (5472,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 (5472,7,2,1)))
				)
				AND ControlID<>0
		 GROUP BY ControlID
		

	   SELECT PageID
	     FROM Data_LayoutRowCol
	    WHERE ControlID=?
			AND (PageID=220205 OR (PageID IN (5472,7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
	 	ORDER BY PageID Desc
	

	SELECT *
	  FROM Param_ControlTable
	 WHERE ControlID=?
	   AND (PageID=220205 OR (PageID IN (5472,7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2)
 ORDER BY PageID DESC, VersionID Desc 

	SELECT *
	  FROM Data_LayoutRowCol
	 WHERE ControlID=?
	   AND
	   (
			(
				PageID=220205 AND (VersionState = 2)
				AND (VersionState = 2)
			)
		)
 ORDER BY VersionState DESC, Action

			SELECT *
			  FROM Data_LayoutCell
			 WHERE ControlID = ?
				AND (PageID=220205 OR (PageID IN (5472,7,2,1) AND (VersionState = 2)))
				AND (VersionState = 2)
		 ORDER BY ItemID, PageID DESC, VersionID DESC
		

		
		SELECT *
		  FROM Param_TextBlock
		 WHERE (PageID=220205 OR (PageID IN (5472,7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
	 ORDER BY ControlID, PageID Desc, VersionID Desc 

			
			SELECT *
			  FROM Data_TextBlock
			 WHERE (pageID IN (1,2,7,5472,220205)) 
			 	AND versionState = 2
		 ORDER BY ControlID, PageID Desc, VersionID Desc 

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

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

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

	   SELECT PageID
	     FROM Data_LayoutRowCol
	    WHERE ControlID=?
			AND (PageID=220205 OR (PageID IN (5472,7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
	 	ORDER BY PageID Desc
	

	SELECT *
	  FROM Param_ControlTable
	 WHERE ControlID=?
	   AND (PageID=220205 OR (PageID IN (5472,7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2)
 ORDER BY PageID DESC, VersionID Desc 

	SELECT *
	  FROM Data_LayoutRowCol
	 WHERE ControlID=?
	   AND
	   (
			(
				PageID=7 AND (VersionState = 2)
				AND (VersionState = 2)
			)
		)
 ORDER BY VersionState DESC, Action

			SELECT *
			  FROM Data_LayoutCell
			 WHERE ControlID = ?
				AND (PageID=220205 OR (PageID IN (5472,7,2,1) AND (VersionState = 2)))
				AND (VersionState = 2)
		 ORDER BY ItemID, PageID DESC, VersionID DESC
		

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

	SELECT Data_FieldValue.FieldValue,FormInputControl.FieldName,FormInputControl.type,FormControl.FormName,
			 FormControl.ID AS FormControlID, FormInputControl.ID AS ficID,
			 Data_FieldValue.MemoValue, Data_FieldValue.listid
	  FROM FormInputControl,FormControl,FormInputControlMap,Data_FieldValue,FormControlMap
	 WHERE Data_FieldValue.PageID = ?
		AND Data_FieldValue.FieldID = FormInputControl.ID
		AND Data_FieldValue.FormID = FormControl.ID
		AND FormInputControl.ID = FormInputControlMap.FieldID
		AND FormControl.ID = FormInputControlMap.FormID
		AND FormControl.ID = FormControlMap.FormID
		AND (
				((FormControlMap.ClassConstant = 4)
			
				AND (FormControlMap.ClassID IN (1,4,140)) 
			)
	
			OR ((FormControlMap.ClassConstant = 1) AND ( (FormControlMap.ClassID IN (1,2,7,5472)) ))
	
			OR ((FormControlMap.ClassConstant = 2) AND (FormControlMap.ClassID = ?))
	
			 )
 ORDER BY FormControl.ID, FormInputControl.ID

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

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

	   SELECT PageID
	     FROM Data_LayoutRowCol
	    WHERE ControlID=?
			AND (PageID=220205 OR (PageID IN (5472,7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
	 	ORDER BY PageID Desc
	

	SELECT *
	  FROM Param_ControlTable
	 WHERE ControlID=?
	   AND (PageID=220205 OR (PageID IN (5472,7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2)
 ORDER BY PageID DESC, VersionID Desc 

	SELECT *
	  FROM Data_LayoutRowCol
	 WHERE ControlID=?
	   AND
	   (
			(
				PageID=220205 AND (VersionState = 2)
				AND (VersionState = 2)
			)
		)
 ORDER BY VersionState DESC, Action

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

	SELECT StaffID, BioPageLink, LastName, FirstName
	FROM tblStaff 
	WHERE BioPageLink = '/Press/ALAChart/alc_018.cfm'

	SELECT StaffID, BioPageLink, LastName, FirstName
	FROM tblStaff 
	WHERE BioPageLink = '/Press/ALAChart/alc_018.cfm'

	   SELECT PageID
	     FROM Data_LayoutRowCol
	    WHERE ControlID=?
			AND (PageID=220205 OR (PageID IN (5472,7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
	 	ORDER BY PageID Desc
	

	SELECT *
	  FROM Param_ControlTable
	 WHERE ControlID=?
	   AND (PageID=220205 OR (PageID IN (5472,7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2)
 ORDER BY PageID DESC, VersionID Desc 

	SELECT *
	  FROM Data_LayoutRowCol
	 WHERE ControlID=?
	   AND
	   (
			(
				PageID=220205 AND (VersionState = 2)
				AND (VersionState = 2)
			)
		)
 ORDER BY VersionState DESC, Action

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

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

				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,145
anonitemsecurity=Struct (8)
anonrights=Struct (7)
anonsubsiteperms=Struct (136)
anonsubsitesecurity=Struct (136)
applicationname=site2
cachedimages=Struct (327)
cacheinfo=Struct (15089)
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)
getidparams=Struct (2)
gettaxonomyannotlookup=Complex type
imagegallerylists=Struct (0)
languages=Struct (11)
lastknownchange=Struct (19)
lastupdate=Struct (15)
lookuptaxonomyannot=Complex type
masterrendersequence=78818
metadatacache=Struct (0)
nextcheck=Struct (1)
serverclockcheck=2008-07-04 11:38:52
servervalidationcode=1029RTN7H3C5C265DONPR3CT2
site=Struct (47)
styleids=Struct (206)
stylenames=Struct (206)
subsitecache=Struct (136)
templaterenderoptions=Struct (66)
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\ALAChart\alc_018.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=/Press/ALAChart/alc_018.cfm
PATH_TRANSLATED=D:\websites\heritage.org\Press\ALAChart\alc_018.cfm
QUERY_STRING=
REMOTE_ADDR=10.10.41.254
REMOTE_HOST=10.10.41.254
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/Press/ALAChart/alc_018.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=9989879
CFTOKEN=77577774

Request Parameters:
applockname=CS_App_Site2_1
approvalneededlist=
approvedlist=
author_approve_whereclause=(VersionState = 2)
authormode=0
authorok=1
basehref=/
blupfront=
browser=Struct (9)
buildingcache=0
cacheinfo=Struct (9)
constants=Struct (185)
controlswhereuserisowner=
cp=Struct (110)
ctrl_data=Struct (351)
ctrlinstupfront=Query (351)
customcf_data=Struct (1)
customcfupfront=Query (9)
customerinfo=Struct (25)
customhead=1
debugmode=0
dhtmlmenuitemsprefetch=
dhtmlmenus_current=Struct (0)
dhtmlmenus_wip=Struct (0)
disablehideformenus=0
editiconcontrols=
editiconitems=
editiconnames=action-big-change,action-big-del,action-big-move,action-big-move-add,action-big-move-change,action-both,action-delete,action-wip,action-big-add
editmode=0
element=Struct (10)
elementadminlist=
elementapprovelist=
elementauthorlist=
elementcommentlist=
elementdesignlist=
elementeditlist=
elementreadlist=
elementrestrictedadminlist=0,791,793,803,827,832,834,846,936,2,811,825,928,929,1125,4839,4853,4902,5476,5484,5491,5496,7140,7401,10582,10587
elementrestrictedauthorlist=0,791,793,803,827,832,834,846,936,2,811,825,928,929,1125,4839,4853,4902,5476,5484,5491,5496,7140,7401,10582,10587
elementrestricteddesignlist=0,791,793,803,827,832,834,846,936,2,811,825,928,929,1125,4839,4853,4902,5476,5484,5491,5496,7140,7401,10582,10587
elementrestrictedstylelist=0,791,793,803,827,832,834,846,936,2,811,825,928,929,1125,4839,4853,4902,5476,5484,5491,5496,7140,7401,10582,10587
elementstylelist=
fnsequence=8
formattedtimestamp=2008-07-04 18:42:35
generatedmenuoutput=
getghost=
havebodytag=1
havehtmltag=1
ignoreauthuser=0
imageupfront=
includedmodules=
includedobjects=nwjs
initialsiteid=2
initialsubsiteid=140
itemsecurity=Struct (8)
jswarnmessage=
knownsecurecontrols=
linkdataupfront_itempos=
linkdataupfront_itemtitle=
lockid=0
longagotimestamp=1993-11-04 01:00:00
master_cfm_used=1
masterrendersequence=78818
maxadmin=0
maxapprove=0
maxauthor=0
maxcomment=0
maxdesign=0
maxedit=0
maxhistory=0
maxperms=Struct (9)
maxstyle=0
metadata=Struct (0)
minperms=Struct (9)
modeorderbyclause=VersionID Desc
modeorderbyclause_page=VersionID DESC
modewhereclause=(VersionState = 2)
modewhereclause_page=(VersionState = 2)
multisectionupfront=
nocacheelementtypes=
openelements=
page=Struct (94)
pagedata=Struct (8)
pagedhtmlitems=Query (0)
pagedhtmlmenus=Query (0)
pageperms=Struct (9)
pagerestrictedadmin=0
pagerestrictedauthor=0
pagerestricteddesign=0
pagerestrictedstyle=0
previewon=1
propsretrieved=false
readmodewhereclause=(VersionState = 2)
renderedelements=Struct (0)
renderelementdata=Struct (0)
renderfordiff=0
renderforprint=0
renderstate=Struct (2)
requestedversiontimestamp=
scheduleupfront=
securitydetailrun=1
sequenceid=625697
sessionlockname=Session_1_9989879_77577774
sessionstring=1_9989879_77577774
sicupfront=
sicupfrontparam=
site=Struct (47)
siteid=2
static_basetag=
styleids=Struct (206)
stylenames=Struct (206)
subsite=Struct (56)
subsitecache=Struct (136)
subsiteid=140
subsiteperms=Struct (136)
subsiterights=Struct (14)
subsitesecurity=Struct (2)
subsitesecuritycache=Struct (136)
taiupfrontparam=
tb_data=Struct (9)
tb_param=Struct (16)
tbupfront=Query (9)
tbupfrontparam=Query (16)
timestamp={ts '2008-07-04 18:42:35'}
udslockname=CS_Customer_commonspot-users
uipath=/ui/
updatingschemas=0
usedelementnames=contentlayout2_common,contentlayout_common,contentlayout3_common,RHBoxesRD06_common
user=Struct (18)
usersdatasource=commonspot-users
vinheritancelist=220205,5472,7,2,1
wanterrorsrethrown=0
warnmessage=

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

Session Variables:
authormode=0
browser=Struct (9)
cfid=9989879
cftoken=77577774
current_page_containing_forum=
currentpageid=220205
debugmode=0
debugmode_control=0
editmode=0
hasusertempfiles=0
lastupdate=Struct (6)
lastuserupdate=1215211355906
lockid=0
lockobjectid=0
lockobjecttype=page
locktype=temp
logintime=
pagedata=
pendingapprovalpages=
pendingapprovals=
previewon=1
requestedversioncounter=
requestedversiontimestamp=
sessionid=SITE2_9989879_77577774
urltoken=CFID=9989879&CFTOKEN=77577774
usagelist=
user=Struct (18)