The DHS Program

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

			SELECT *
			  FROM Param_Page
			 WHERE (PageID=8297 OR (PageID IN (8021,2352,2,1) AND (VersionState = 2)))
			   AND VersionState=2
			 ORDER BY PageID DESC
		

					SELECT SubsiteID
					  FROM SitePages
					 WHERE ID = ? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1) AND Uploaded=0)
	

		SELECT Data_SeeAlso.ID, SubSites.SubSiteURL, SitePages.filename as pagename,
				 XMLPublications.name as feedname, XMLPublicationFormat.name as feedformat,
				 XMLPublications.description,
				 CASE
					 	WHEN XMLPublicationFormat.IsSyndication = 0 THEN 0
						ELSE 1
				 END AS IsSyndicationFeed
		  FROM Data_SeeAlso, XMLPublications, XMLPublicationFormat, SitePages, SubSites
		 WHERE Data_SeeAlso.PageID = ?
		 	AND Data_SeeAlso.Action = ?
		 	AND Data_SeeAlso.ItemID = XMLPublicationFormat.XMLPublicationFormatID
		 	AND Data_SeeAlso.TargetPageID = XMLPublications.XMLPublicationID
		 	AND XMLPublications.XMLPublicationFormatID = XMLPublicationFormat.XMLPublicationFormatID
		 	AND XMLPublications.PageID = SitePages.ID
		 	AND SitePages.SubSiteID = SubSites.ID
	

	SELECT *
	  FROM Data_Ghost_Common
	 WHERE (PageID=8297 OR (PageID IN (8021,2352,2,1) AND (VersionState = 2)))
	ORDER BY ControlID, PageID DESC

		SELECT ControlID, ControlName, ControlType, ParentControlID, ParentControlType, pageID
		  FROM ControlInstance
		 WHERE (PageID IN (?,?,?,?,?)) 
	 ORDER BY ControlID, PageID DESC
	

		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ? 

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

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

select name, size, 1 as scode
from qSPADatasets
where name like '%SR.ZIP%'

UNION

select name, size, 2 as scode
from qSPADatasets
where name like '%SP.ZIP%'

order by scode, name

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'AN'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'AN'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'AN'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'AN'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'AT'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'AT'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'AT'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'AT'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'CL'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'CL'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'CL'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'CL'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'CT'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'CT'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'CT'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'CT'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FC'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FC'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FC'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FC'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FP'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FP'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FP'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FP'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'LB'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'LB'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'LB'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'LB'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'MS'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'MS'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'MS'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'MS'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'OI'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'OI'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'OI'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'OI'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'PH'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'PH'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'PH'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'PH'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'PM'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'PM'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'PM'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'PM'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'PV'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'PV'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'PV'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'PV'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SC'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SC'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SC'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SC'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SI'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SI'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SI'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SI'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SL'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SL'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SL'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SL'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'TB'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'TB'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'TB'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'TB'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'AN'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'AN'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'AN'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'AN'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'AT'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'AT'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'AT'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'AT'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'CT'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'CT'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'CT'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'CT'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FC'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FC'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FC'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FC'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FP'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FP'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FP'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FP'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'IP'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'IP'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'IP'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'IP'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'OP'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'OP'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'OP'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'OP'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'PM'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'PM'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'PM'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'PM'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'PV'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'PV'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'PV'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'PV'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SC'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SC'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SC'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SC'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SI'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SI'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SI'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SI'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'TB'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'TB'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'TB'
			

      SELECT * FROM File_For where File_for_code = ? 

			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'TB'
			

      SELECT * FROM File_For where File_for_code = ? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

sp_dataset_disp (Datasource=dhs_legacy_live, Time=15ms) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 03:50:00.000

Application Variables:
activesubsites=1,2,5,6,8,17,18,19,20,21,22,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
adf=Struct (89)
adfscheduler=Struct (0)
applicationname=site1
assocpubdocs=Struct (4)
blogcache=Struct (4)
cachedimages=Struct (32)
cacheinfocache=Struct (53)
confidentiality=Array (5)
controlinstance_toplevel_cache=Struct (126)
covid_articlecount=10
covid_newsarticlecount=49
covid_pressreleasecount=4
covid_pubcount=3
cs_elementcache=Struct (10)
cs_resourcesmissing=Struct (0)
cs_rewriterulescache=Struct (21)
cs_subsitecachemanager=Struct (28)
customerinfo=Complex type
customerscope=Struct (21)
custommodulecache=Struct (21)
defaultconfidentiality=2
dhspagesyncdata=Struct (1)
itemsecuritycache=Struct (31)
languagenames=Struct (51)
languages=Struct (51)
lastknownchange=Struct (18)
lastupdate=Struct (14)
metadatacache=Struct (4)
pendingstubrequests=Struct (0)
rsscache=Struct (2)
search_archive_next_clean=2024-07-03 12:12:03
serverstatus=Struct (1)
site=Struct (74)
sitescope=Struct (9)
styleids=Struct (248)
stylenames=Struct (248)
subsitecache=Struct (46)
subsitecachebysecuritypageid=Struct (46)
templatecache=Struct (28)
templatedefaultsecuritycache=Struct (60)
templateenforcedsecuritycache=Struct (60)
treecache=Struct (25)
twittercache=Struct (2)
typefactory=Complex type
youtubecache=Struct (3)

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=C:\inetpub\wwwroot\dhs\data\dataset\Kenya_SPA_2004.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=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=JSESSIONID=3ED5613F4F90532DBE52EC8F735BA559.cfusion; CSRFTOKEN=48BDE56A1934C04F4528851B9167C87051011EC7
HTTP_HOST=preview.dhsprogram.com
HTTP_REFERER=
HTTP_URL=/data/dataset/Kenya_SPA_2004.cfm
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.0.0.111
PATH_INFO=
PATH_TRANSLATED=C:\inetpub\wwwroot\dhs\data\dataset\Kenya_SPA_2004.cfm
QUERY_STRING=
REMOTE_ADDR=10.0.0.149
REMOTE_HOST=10.0.0.149
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/data/dataset/Kenya_SPA_2004.cfm
SERVER_NAME=preview.dhsprogram.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Cookie Variables:
CSRFTOKEN=48BDE56A1934C04F4528851B9167C87051011EC7
JSESSIONID=3ED5613F4F90532DBE52EC8F735BA559.cfusion

Request Parameters:
anonnoreadelements=
applockname=CS_App_Site1_1
archiveemail=archive@dhsprogram.com
assetsdir=/assets/
author_approve_whereclause=(VersionState = 2)
authormode=0
authorok=1
blupfront=
browser=Struct (13)
browserallincluded=1
cachefilesused=24
cachestatus=Complex type
cfflushcount=0
cgivars=Struct (49)
cloudfrontkeypairid=K3LSHNFSZFMIUC
cloudfronturl=d1vyaiefsqy4pf
constants=Complex type
cors.isCorsRequest=NO
cp=Struct (123)
cs_includedobjects=nwjs
cs_init_timings=Struct (23)
cs_isdashboardcmd=0
cs_request_start_memory=2693285376
cs_runningdashboardcmdcode=0
csrftoken=48BDE56A1934C04F4528851B9167C87051011EC7
ctrl_data=Struct (80)
customcf_data=Struct (2)
customcfupfront=Query (2)
customerinfo=Complex type
customhead=1
customrenderhandlerpairs=
customsearch=Struct (11)
data_ghost=Struct (0)
dbdsn=measure_db
debugstate=Struct (1)
dhspagesyncdata=Struct (1)
dhtmlmenuitemsprefetch=
disablehideformenus=0
dsource=dhs_legacy_live
editmode=0
element=Struct (42)
elementrundetail=Struct (1)
elementsrun=1
environment=Struct (5)
finalreportids=5,26,21,10,18,30,39
finalreportna=139,315,445,488,107,138,459,518
formattedtimestamp=2024-07-03 03:49:59
getghost=Query (0)
hivbold=1,3,8,9
imageupfront=
imgdir=/images/
includerootdir=/
initialsiteid=1
initticks=1719978599813
jswarnmessage=
linkdataupfront_itempos=
linkdataupfront_itemtitle=
lockid=0
mainpage=Struct (84)
master_cfm_used=1
maxperms=Complex type
modeorderbyclause=VersionID Desc
modewhereclause=(VersionState = 2)
modewhereclause_page=(VersionState = 2)
multisectionupfront=
noauthorreason=
nocacheelementtypes=
nocacheheaderincluded=1
nondashboardincludedone=1
obcountires=EG,ZM
package=Struct (0)
page=Struct (84)
pagedata=Struct (1)
pagedhtmlitems=
pagedhtmlmenus=
pageperms=Complex type
pagesync=Struct (4)
params=Struct (4)
params_formfields=
params_urlfields=
readmodewhereclause=(VersionState = 2)
renderedelements=Struct (0)
renderelementdata=Struct (0)
renderfordiff=0
renderforprint=0
renderstate=Struct (73)
req_cam_callcount=1
req_inittimestamp=2024-07-03 03:49:59.813
req_sequenceid=59872
req_startticks=1719978599813
rootdir=/
rootpath=
rooturldatasetadmin=https://preview.dhsprogram.com/data/dataset_admin
samesite_value=
scheduleupfront=
serverdatasource=commonspot-sites
sessionlockname=Session_1_3ED5613F4F90532DBE52EC8F735BA559.cfusion
sessionstring=1_3ED5613F4F90532DBE52EC8F735BA559.cfusion
sicupfront=
sicupfrontparam=
site=Struct (74)
siteid=1
standardrenderhandlers=
styleids=Struct (248)
stylenames=Struct (248)
subsite=Struct (0)
subsitecache=Struct (46)
subsitecachebysecuritypageid=Struct (46)
subsiteid=34
taiupfrontparam=
tbupfront=
tbupfrontparam=
templatecachestatus=Struct (1)
templaterootdir=/
timestamp={ts '2024-07-03 03:49:59'}
trustcachestatus=1
typefactory=Complex type
udslockname=CS_Customer_commonspot-users
updatingschemas=0
user=Struct (31)
usersdatasource=commonspot-users
wanterrorsrethrown=0
warnmessage=
xmlbrowser=Struct (13)

Server Variables:
ADF=Struct (15)
COMMONSPOT=Struct (44)
EMAILALERTKEY=BSu0cRa8xSWdSrClnnGvpA==
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)

Session Variables:
_csrf_token=48BDE56A1934C04F4528851B9167C87051011EC7
adf=Struct (0)
authormode=0
contributemode=read
currentpageid=8297
debugmode=0
debugstate=Struct (1)
editmode=0
environment=Struct (5)
hasusertempfiles=0
language=Struct (216)
lastupdate=Struct (2)
lastuserupdate=1719978567281
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
ownedobjecttypes=
pendingapprovalpages=
pendingapprovals=
previewmode=0
requestedversioncounter=
requestedversiontimestamp=
sessionid=3ED5613F4F90532DBE52EC8F735BA559.cfusion
sessionstring=1_3ED5613F4F90532DBE52EC8F735BA559.cfusion
urltoken=CFID=2283380&CFTOKEN=f29e526902a26772-A3220C93-A895-7B69-2C4C48680FD72F27&jsessionid=3ED5613F4F90532DBE52EC8F735BA559.cfusion
usagelist=
user=Struct (31)
xmlbrowser=Struct (13)
xmlenvironment=Struct (5)