The DHS Program

    	SELECT lang_text_var, lang_text_en
        FROM dataset_lang_dictionary
    

		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=2244 OR (PageID IN (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 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 d1.ID,
				 d1.FormName,
				 d1.Method,
				 d1.Action,
				 d1.JSHandler,
				 d1.DateCreated,
				 d1.DateLastModified,
				 d1.Params,
				 d1.ViewerPageID,
				 d1.OwnerID,
			
				 d4.ClassConstant as Class,
				 CASE
				 	WHEN d1.action = 'custom_form_element' THEN 1  
					ELSE d4.ClassID
				 END AS ClassID,
			
				 d2.ID as inputID,
				 d2.fieldName,
				 cft.ID as CFTID,
				 cft.CSDataType AS CFTDataType,
				 cft.FilterModule as CFTFilterModule,
				 d2.shared,
				 d3.formID,
				 d3.itemPos,
				 d3.TabID,
				 d5.TabDisplayName,
				 d5.TabSortName,
				 d2.type as inputType,
				 d2.params as inputParams,
				 d2.OverrideParams as inputOverrideParams,
				 d2.dateCreated as inputCreated,
				 d2.description,
				 d2.dateLastModified as inputLastModified
		  FROM formControl d1
	
		INNER JOIN formControlMap d4 ON d1.ID = d4.formID
	
		INNER JOIN formInputControlMap d3 ON d1.ID = d3.formID
		INNER JOIN FormControlTabs d5 ON d5.ID = d3.TabID
		INNER JOIN formInputControl d2 ON d3.fieldID = d2.ID
		LEFT OUTER JOIN CustomFieldTypes cft ON d2.type = cft.type
		 WHERE (1=1)
	AND d4.classConstant = 7 AND d4.classID = 135732 ORDER BY d1.id, d2.id 

   SELECT PageID,VersionState,AuthorID
     FROM Param_WDDX
    WHERE ControlID=?
		AND (PageID=2244 OR (PageID IN (2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY PageID Desc

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=2244 AND (VersionState = 2)) OR ((PageID IN (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 DisplayTemplateID, ModuleID
	  FROM Data_Custom_Render
	 WHERE ControlID = ?
		AND (PageID IN (?,?,?)) 
		AND (VersionState = 2)
 ORDER BY PageID DESC, VersionID DESC

	SELECT *
	  FROM ElementDefaults
	 WHERE ElementTypeID = ? 

		SELECT params
		  FROM FormControl
		 WHERE ID = ? 

		SELECT *
		  FROM CustomElementModules
		 WHERE ID = ?
			AND (IncludeStyle + IncludeParams + IncludeLayout + IncludeMetadata) > 0 
			AND DisplayTemplateID = 0
	

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

			SELECT DataBlock, PageID, ControlID
			  FROM ElementDataCache
			 WHERE (PageID = ?) 
				AND ControlID = 0
			
				AND FormID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT DisplayTemplateID
			  FROM Data_Custom_Render
			 WHERE ModuleID > 0
				AND DisplayTemplateID > 0
				AND ControlID = ?
				AND (PageID IN (?,?,?)) 
				AND (VersionState = 2)
		 ORDER BY PageID DESC, VersionID DESC
		

		SELECT rmm.FormControlID, rmm.Data_TextBlockID, rmm.TransactionDate, rmm.PreviewImageID, rmm.ItemState, rmm.Description,
			CASE WHEN ed.DisplayTemplateID = rmm.Data_TextBlockID THEN 1 ELSE 0 END AS IsDefault
		  FROM RenderMaskMap rmm
		  LEFT OUTER JOIN ElementDefaults ed ON ed.DisplayTemplateID = rmm.Data_TextBlockID AND ed.HandlerID = 0
		 WHERE rmm.FormControlID = ? 
			AND rmm.Data_TextBlockID = ed.DisplayTemplateID
		

	SELECT InputType, FieldName, FormID, InputID, CFTID, CFTDataType
	  FROM attributes.formDefQuery
	 WHERE InputType IN (?,?,?,?,?,?,?,?,?,?)
		 OR CFTID > 0

		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 DISTINCT TOP 4

   c.Pub_ID,
   c.Pub_Type_ID,
   c.Pub_Code,
   Year(c.print_date) as PrintYear,
   CONVERT(CHAR(8), c.print_date, 1) as pubPrintDate,
   c.Pub_Code_Num,
   c.ctry_list,
   c.Print_Date,
   c.Release_Date,
   c.Lang_List,
   c.Title AS Title2,
   t.Pub_Type_Name,
   s.Survey_Yr_Display,
   t2.Pub_Type_Prnt_Name,

    (SELECT Count(*)
     FROM Pub_PDF
     WHERE Pub_PDF.Pub_ID = c.Pub_ID) AS NoPDF,

	 (SELECT
	  CASE WHEN survey_subtype_desc = 'Standard DHS' THEN 'DHS'
	       WHEN survey_subtype_desc = 'Standard AIS' THEN 'AIS'
	       ELSE survey_subtype_desc END
    FROM survey_subtype, survey
    WHERE survey_subtype.survey_subtype_id = survey.survey_type_ID
   and survey.survey_id=c.survey_id
   ) AS SurveyType,

     (SELECT ctry_name
    FROM Ctry, survey
    WHERE ctry.ctry_id = survey.ctry_id
   and survey.survey_id=c.survey_id
   ) AS ctry_name,

    (SELECT PDF_File_Name
    FROM Pub_PDF
    WHERE Pub_PDF.Pub_ID = c.Pub_ID
    AND (SELECT Count(*)
        FROM Pub_PDF
        WHERE Pub_PDF.Pub_ID = c.Pub_ID) = 1) AS PDFFileName

FROM Pub_Catalog c
   INNER JOIN Pub_Type t ON t.Pub_Type_ID = c.Pub_Type_ID
   INNER JOIN Pub_Type_Prnt t2 ON t.Pub_Type_Prnt_ID = t2.Pub_Type_Prnt_ID
   LEFT OUTER JOIN Survey s ON s.Survey_ID = c.Survey_ID
WHERE c.Pub_Code <> 'NA'
  AND c.Stts_ID =3
  AND c.Pub_Type_ID IN (5,21,26,30,39)

ORDER BY c.Release_Date 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)
	

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
adf=Struct (88)
adfscheduler=Struct (0)
applicationname=site1
blogcache=Struct (4)
cachedimages=Struct (20)
cacheinfocache=Struct (51)
confidentiality=Array (5)
controlinstance_toplevel_cache=Struct (126)
covid_articlecount=6
covid_newsarticlecount=24
covid_pressreleasecount=4
covid_pubcount=2
cs_element_cache=Struct (0)
cs_resourcesmissing=Struct (0)
cs_rewriterulescache=Struct (21)
cs_subsitecachemanager=Struct (28)
customerscope=Struct (18)
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 (3)
pendingstubrequests=Struct (0)
rsscache=Struct (2)
search_archive_next_clean=2021-11-28 03:10:48
search_orphan_next_clean=2021-11-28 03:10:48
serverstatus=Struct (1)
site=Struct (71)
sitescope=Struct (9)
styleids=Struct (248)
stylenames=Struct (248)
subsitecache=Struct (44)
subsitecachebysecuritypageid=Struct (44)
taxonomy=Struct (2)
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=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, S=Illinois, L=Chicago, O="Trustwave Holdings, Inc.", CN="Trustwave Organization Validation SHA256 CA, Level 1", E=ca@trustwave.com
CERT_SERVER_SUBJECT=CN=*.dhsprogram.com, O=ICF International, L=Fairfax, S=Virginia, C=US
CERT_SUBJECT=
CF_TEMPLATE_PATH=C:\inetpub\wwwroot\dhs\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, S=Illinois, L=Chicago, O="Trustwave Holdings, Inc.", CN="Trustwave Organization Validation SHA256 CA, Level 1", E=ca@trustwave.com
HTTPS_SERVER_SUBJECT=CN=*.dhsprogram.com, O=ICF International, L=Fairfax, S=Virginia, C=US
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=br,gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=preview.dhsprogram.com
HTTP_REFERER=
HTTP_URL=/index.cfm
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
LOCAL_ADDR=10.0.0.111
PATH_INFO=
PATH_TRANSLATED=C:\inetpub\wwwroot\dhs\index.cfm
QUERY_STRING=
REMOTE_ADDR=54.227.97.219
REMOTE_HOST=54.227.97.219
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=preview.dhsprogram.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Cookie Variables:
CFID=1876177
CFTOKEN=b729467e6bf6190b-C0699D97-A008-320D-EA64431CC76E6769

Request Parameters:
anonnoreadelements=61254
applockname=CS_App_Site1_1
archiveemail=archive@dhsprogram.com
assetsdir=/assets/
author_approve_whereclause=(VersionState = 2)
authormode=0
authorok=1
autologinhandled=0
blupfront=
browser=Struct (13)
browserallincluded=1
cachefilesused=26
cachestatus=Complex type
cfflushcount=0
cgivars=Struct (49)
cloudfrontkeypairid=K3LSHNFSZFMIUC
cloudfronturl=d1vyaiefsqy4pf
constants=Complex type
cors.isCorsRequest=NO
cp=Struct (124)
cs_includedobjects=nwjs
cs_init_timings=Struct (23)
cs_isdashboardcmd=0
cs_runningdashboardcmdcode=0
ctrl_data=Struct (183)
customcfupfront=
customerinfo=Complex type
customhead=1
customrenderhandlerpairs=
customsearch=Struct (11)
dbdsn=measure_db
debugstate=Struct (1)
dhspagesyncdata=Struct (1)
dhtmlmenuitemsprefetch=
disablehideformenus=0
dsource=dhs_legacy_live
editmode=0
element=Struct (41)
elementrundetail=Struct (1)
elementsrun=1
environment=Struct (5)
finalreportids=5,26,21,10,18,30,39
finalreportna=139,315,445,488,107,138
formattedtimestamp=2021-11-27 06:17:25
getghost=
hivbold=1,3,8,9
ignoreauthuser=0
imageupfront=
imgdir=/images/
includerootdir=/
initialsiteid=1
initticks=1637993845729
jswarnmessage=
linkdataupfront_itempos=
linkdataupfront_itemtitle=
lockid=0
mainpage=Struct (86)
master_cfm_used=1
maxperms=Complex type
modeorderbyclause=VersionID Desc
modeorderbyclause_page=VersionID Desc
modewhereclause=(VersionState = 2)
modewhereclause_page=(VersionState = 2)
multisectionupfront=
noauthorreason=
nocacheelementtypes=
nondashboardincludedone=1
obcountires=EG,ZM
package=Struct (0)
page=Struct (86)
pagedata=Struct (1)
pagedhtmlitems=
pagedhtmlmenus=
pageperms=Complex type
pagesync=Struct (4)
params=Struct (4)
previewmode=0
readmodewhereclause=(VersionState = 2)
renderedelements=Struct (0)
renderelementdata=Struct (0)
renderfordiff=0
renderforprint=0
renderstate=Struct (72)
req_cam_callcount=1
req_inittimestamp=2021-11-27 06:17:25.714
req_sequenceid=58707
req_startticks=1637993845714
rootdir=/
rootpath=
rooturldatasetadmin=https://preview.dhsprogram.com/data/dataset_admin
scheduleupfront=
serverdatasource=commonspot-sites
sessionlockname=Session_1_C0446F8C2A044183329207F310F81B0B.cfusion
sessionstring=1_C0446F8C2A044183329207F310F81B0B.cfusion
sicupfront=
sicupfrontparam=
site=Struct (71)
siteid=1
standardrenderhandlers=
styleids=Struct (248)
stylenames=Struct (248)
subsite=Struct (0)
subsitecache=Struct (44)
subsitecachebysecuritypageid=Struct (44)
subsiteid=1
taiupfrontparam=
tbupfront=
tbupfrontparam=
templatecachestatus=Struct (1)
templaterootdir=/
timestamp={ts '2021-11-27 06:17:25'}
trustcachestatus=1
typefactory=Complex type
udslockname=CS_Customer_commonspot-users
updatingschemas=0
user=Struct (27)
usersdatasource=commonspot-users
wanterrorsrethrown=0
warnmessage=
xmlbrowser=Struct (13)

Server Variables:
ADF=Struct (15)
COMMONSPOT=Struct (40)
EMAILALERTKEY=LZIA60f/S/A4a/iAH17Viw==
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)

Session Variables:
adf=Struct (0)
authormode=0
contributemode=read
currentpageid=2244
debugmode=0
debugstate=Struct (1)
editmode=0
hasusertempfiles=0
language=Struct (216)
lastupdate=Struct (2)
lastuserupdate=1637993845729
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
ownedobjecttypes=
pendingapprovalpages=
pendingapprovals=
previewmode=0
requestedversioncounter=
requestedversiontimestamp=
sessionid=C0446F8C2A044183329207F310F81B0B.cfusion
urltoken=CFID=1876177&CFTOKEN=b729467e6bf6190b-C0699D97-A008-320D-EA64431CC76E6769&jsessionid=C0446F8C2A044183329207F310F81B0B.cfusion
usagelist=
user=Struct (27)