SELECT dcr.*
			  FROM Data_Custom_Render dcr, CustomElementModules cem
			 WHERE (dcr.PageID IN (57290,97834,204413)) 
				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 (57290,97834,204413)) 
		 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,97834) 

		SELECT DISTINCT ControlID
		  FROM ItemSecurity
		 WHERE
			(
				((ApplyTo=?)
					AND (PageID=?))
				OR
				((ApplyTo=?)
					AND (PageID IN (57290,97834)))
			)
			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,97834)))
				)
				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 (204413,57290,97834)  AND (VersionState = 2)) AND ((((PageID=204413) AND (VersionState >= 2)) OR (PageID IN (57290,97834) 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 (204413,57290,97834)  AND (VersionState = 2)) AND ((PageID=204413 OR (PageID IN (57290,97834) 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 = 45868 AND Data_FieldValue.formID = 6855 AND Data_FieldValue.VersionState >= 2 AND (Data_FieldValue.fieldValue = 'Urban Issues'))  or  SitePages.ID in (select pageID from Data_FieldValue where Data_FieldValue.fieldID = 151314 AND Data_FieldValue.formID = 6855 AND Data_FieldValue.VersionState >= 2 AND (Data_FieldValue.fieldValue = 'Urban Issues'))  or  SitePages.SubSiteID in (34,34)  ) AND (SitePages.IsPublic IN (1,3,5,7,9,11,13,15)))) AND (SitePages.ExpDate >= '2008-07-04 00:00:00' OR SitePages.ExpDate IS NULL) AND (SitePages.PublicReleaseDate < '2008-07-04 23:32:30') AND (SitePages.ID <> 204413) 

 
				    SELECT 
				SitePages.*, DocCategories.Category
				  FROM DocCategories,SitePages,Data_FieldValue
				 WHERE (DocCategories.ID = SitePages.CategoryID) AND (SitePages.ID = Data_FieldValue.PageID AND Data_FieldValue.FormID = 6855 AND Data_FieldValue.FieldID = 6858) AND (SitePages.ID  IN (3472,3489,11989,11994,12490,12492,12944,17340,17345,17369,19379,19380,19580,19583,19652,19654,20293,20305,20308,20565,20567,21032,21033,21709,21717,22315,22323,23011,23287,23292,23680,23822,23972,24327,24336,25087,25151,25293,25295,31976,48677,54995,54996,54997,54999,55001,55003,55005,55007,55009,75799,75824,75830,75832,75845,75847,83329,90852,90853,90862,90863,90882,90883,91110,91111,91228,91229,91412,91413,91414,91415,92597,92598,97461,97465,130377,167086,167123,206060,223503)) 
	 ORDER BY Data_FieldValue.FieldValue desc,SitePages.title 

		SELECT DISTINCT LastName, FirstName, ContactID
		  FROM Contacts
		 WHERE (ContactID  IN (1000002,1000015,1000047,1000052,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 (223503,206060,167086,167123,83329,75832,75824,54995,54997,48677,21032,3472,12490,11989,12944,17369,17345,20308,20293,20567,24336,19580,19652,25293,19379,21709,22315,23287,23822,23680,31976,91415,91413,23972,92598,91111,90883,90863,90853,91229,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 (223503,206060,167086,167123,83329,75832,75824,54995,54997,48677,21032,3472,12490,11989,12944,17369,17345,20308,20293,20567,24336,19580,19652,25293,19379,21709,22315,23287,23822,23680,31976,91415,91413,23972,92598,91111,90883,90863,90853,91229,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,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=79708
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\Research\UrbanIssues\index_all.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/UrbanIssues/index_all.cfm
PATH_TRANSLATED=D:\websites\heritage.org\Research\UrbanIssues\index_all.cfm
QUERY_STRING=
REMOTE_ADDR=10.10.41.254
REMOTE_HOST=10.10.41.254
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/Research/UrbanIssues/index_all.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=9998077
CFTOKEN=13578139

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 (5)
constants=Struct (185)
controlswhereuserisowner=
cp=Struct (110)
ctrl_data=Struct (43)
ctrlinstupfront=Query (43)
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-07-04 23:32:30
getghost=
gvpageid=204413
ignoreauthuser=0
imageupfront=
includedmodules=
includedobjects=nwjs,pgIndexJS
initialsiteid=2
initialsubsiteid=34
itemsecurity=Struct (8)
jswarnmessage=
knownsecurecontrols=
linkdataupfront_itempos=
linkdataupfront_itemtitle=
lockid=0
master_cfm_used=1
masterrendersequence=79708
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=634189
sessionlockname=Session_1_9998077_13578139
sessionstring=1_9998077_13578139
sicupfront=
sicupfrontparam=
site=Struct (47)
siteid=2
structdoctypes=Struct (78)
structowners=Struct (6)
styleids=Struct (206)
stylenames=Struct (206)
subsite=Struct (56)
subsitecache=Struct (136)
subsiteid=34
subsiteperms=Struct (136)
subsiterights=Struct (14)
subsitesecurity=Struct (2)
subsitesecuritycache=Struct (136)
taiupfrontparam=
tbupfront=
tbupfrontparam=
thecontrolid=202478
timestamp={ts '2008-07-04 23:32:30'}
udslockname=CS_Customer_commonspot-users
uipath=/ui/
updatingschemas=0
usedelementnames=
user=Struct (18)
usersdatasource=commonspot-users
vcontrolid=202478
vinheritancelist=204413,57290,97834
wanterrorsrethrown=0
warnmessage=
xhighlightcontrol=

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

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