Journalist's Hub

Journalists worldwide write about The DHS Program results. The dissemination of DHS, SPA and HIV data is often widely covered by media in survey countries, but journalists also use The DHS Program data throughout the year as background information for their stories, or to compare health and development indicators across countries. These data are also used by journalists in the United States and other developed countries, as it is considered the gold standard of population, health and nutrition data. Below are some examples of recent news coverage. Please note: The links below are to websites outside The DHS Program.

Dec 21, 2020
The bid for harmless mosquitoes

Killiad Sinide
THE STANDARD HEALTH (Kenya)

"...Data from the 2015 Kenya Malaria Indicator Survey also showed that 27 per cent of children younger than 15 years were found to be positive for malaria in the lake region of Kenya..."

Read more>>


Debugging Information
ColdFusion Server Standard 2018,0,07,316715
Template /Who-We-Are/News-Room/The-bid-for-harmless-mosquitoes.cfm
Time Stamp 17-Oct-21 01:27 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 3.237.16.210
Host Name 3.237.16.210


Execution Time

Total Time Avg Time Count Template
618 ms 618 ms 1 C:/inetpub/wwwroot/dhs/Who-We-Are/News-Room/The-bid-for-harmless-mosquitoes.cfm
615 ms 615 ms 1 C:/inetpub/wwwroot/commonspot/master.cfm
593 ms 593 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cached-page-render.cfm
528 ms 18 ms 30 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element.cfm
504 ms 17 ms 30 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element-core.cfm
363 ms 363 ms 1 C:/inetpub/wwwroot/commonspot/uncached-master.cfm
360 ms 360 ms 1 C:/inetpub/wwwroot/commonspot/master-render.cfm
360 ms 360 ms 1 C:/inetpub/wwwroot/commonspot/render-page.cfm
358 ms 358 ms 1 C:/inetpub/wwwroot/commonspot/render-page-meat.cfm
327 ms 327 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm
320 ms 29 ms 11 C:/inetpub/wwwroot/commonspot/utilities/ct-render-named-element.cfm
226 ms 226 ms 1 C:/inetpub/wwwroot/commonspot/utilities/update-page-cache-status.cfm
38 ms 38 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/18/p148426-c1433-l70-t51-dAny.read
32 ms 32 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/18/p148426-c19152-l70-t51-dAny.read
31 ms 31 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/18/p148426-c19153-l70-t51-dAny.read
31 ms 31 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/18/p148426-c19154-l70-t51-dAny.read
27 ms 27 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/18/p148426-c19155-l70-t51-dAny.read
23 ms 23 ms 1 C:/inetpub/wwwroot/dhs/Who-We-Are/News-Room/Application.cfm
22 ms 22 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/18/p148426-c1432-l70-t51-dAny.read
22 ms 22 ms 1 C:/inetpub/wwwroot/commonspot/site-application.cfm
21 ms 21 ms 1 C:/inetpub/wwwroot/commonspot/startup/site-application-meat.cfm
20 ms 20 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/18/p148426-c1378-l70-t51-dAny.read
14 ms 14 ms 1 C:/inetpub/wwwroot/commonspot/render-head.cfm
9 ms 9 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/18/p148426-c52609-l70-t27356-dAny.read
8 ms 8 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/18/p148426-c19169-l70-t51-dAny.read
8 ms 8 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/18/p148426-c19174-l70-t51-dAny.read
8 ms 8 ms 1 C:/inetpub/wwwroot/commonspot/startup/core-application-meat.cfm
7 ms 7 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/18/p148426-c19177-l70-t51-dAny.read
6 ms 6 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/18/p148426-c19172-l70-t51-dAny.read
6 ms 3 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | GetPageCacheStatus(148426, 18, 4868, 0) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
6 ms 6 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc | getTags(148426) ] from C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc
5 ms 5 ms 1 C:/inetpub/wwwroot/commonspot/render-foot.cfm
4 ms 4 ms 1 C:/inetpub/wwwroot/commonspot/security/security-page.cfm
4 ms 4 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.head
4 ms 4 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/item-security-cache.cfc | GetEntry(148426) ] from C:/inetpub/wwwroot/commonspot/components/cache/item-security-cache.cfc
3 ms 3 ms 1 C:/inetpub/wwwroot/dhs/custom-application.cfm
2 ms 2 ms 1 C:/inetpub/wwwroot/commonspot/non-dashboard-include.cfm
2 ms 2 ms 1 C:/inetpub/wwwroot/commonspot/render-metatags.cfm
2 ms 2 ms 1 C:/inetpub/wwwroot/commonspot/set-page-vars.cfm
2 ms 2 ms 1 C:/inetpub/wwwroot/commonspot/utilities/load-template-properties.cfm
1 ms 1 ms 1 C:/inetpub/wwwroot/commonspot/startup/init-server-scope.cfm
1 ms 1 ms 1 C:/inetpub/wwwroot/commonspot/startup/session-first-global.cfm
1 ms 0 ms 9 C:/inetpub/wwwroot/commonspot/utilities/add-resource-request.cfm
1 ms 1 ms 1 C:/inetpub/wwwroot/commonspot/utilities/build-user-struct.cfm
1 ms 1 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/custom-module-cache.cfc | getCustomModulePath(post-page-render, 18) ] from C:/inetpub/wwwroot/commonspot/components/cache/custom-module-cache.cfc
1 ms 1 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc | GetTemplatePageData(1501) ] from C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc
1 ms 1 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc | LoadTemplateProperties(template-dhs-in-the-news.cfm, 4868, 18) ] from C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc
1 ms 1 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc | checkFileExists(C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm, 0) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc
0 ms 0 ms 1 C:/inetpub/wwwroot/ADF/core/load_site_adf.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/controls/ct-include-once.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/lview-contribute-mode-redirect-check.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/pagemode/pagemodeui.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-body-tag.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-tracking-code.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/browser-detect-methods.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/build-request-params.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/handle-head-request.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/handle-request-timeout.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/session-first-site.cfm
0 ms 0 ms 6 C:/inetpub/wwwroot/commonspot/utilities/add-unregistered-resource-request.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/append-to-resource-group.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cp-cfheader.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cp-cfmail-request-queue.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/utilities/define-upfront-vars.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/flush-cache-db-queue.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/handle-in-list.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/newwindow-js-meat.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/utilities/newwindow-js.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/verify-stub-data.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/custom-search/inc-custom-application-search-vars.cfm
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | DBQueue_Count() ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | GetPageCacheStatus(1501, 17, 2, 0) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | GetPageCacheStatus(4868, 18, 1501, 0) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | UpdateStatus([complex value], [complex value], 18, 148426, 4868, 0, 0, 90) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/custom-module-cache.cfc | getCustomAppPath(18) ] from C:/inetpub/wwwroot/commonspot/components/cache/custom-module-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/rewrite-rules-cache.cfc | getRewriteSettings(18) ] from C:/inetpub/wwwroot/commonspot/components/cache/rewrite-rules-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/subsite-cache-manager.cfc | getLatest() ] from C:/inetpub/wwwroot/commonspot/components/cache/subsite-cache-manager.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/subsite-cache-manager.cfc | getSecurityPageIDMap([complex value]) ] from C:/inetpub/wwwroot/commonspot/components/cache/subsite-cache-manager.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/custom-application-framework/handle-applications.cfc | executeFunction(handleRequestStart) ] from C:/inetpub/wwwroot/commonspot/components/custom-application-framework/handle-applications.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/commonspot-context.cfc | getDSN(site) ] from C:/inetpub/wwwroot/commonspot/components/util/commonspot-context.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent('head' request check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(CGI variable processing) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(New (global) session initialized) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(Request object updates) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(Request.Params initialized) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(RequestTimeout check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(Server-level remote requests checked) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(Subsite context updated (ID=18)) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(authoring suspended check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(basic setup) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(check for server property changes) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(core cleanup) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(core initialization) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(core variables) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(custom-application.cfm) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(handleRequestStart) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(init-server-scope loaded) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(lock checks/updates) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(site environment initialization) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(site session check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(subsite context refreshed) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(user object created) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(user session initialized) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(wait for lock: CommonSpot_Server_Scope (read)) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(wait for lock: CommonSpot_Site1_Core (exclusive)) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | init() ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(Keywords) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(LiveBookmarks) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/visitor-context-rule-actions.cfc | onPageVisit(148426, 18) ] from C:/inetpub/wwwroot/commonspot/components/util/visitor-context-rule-actions.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc | appendEnforced(subsiteIDOrURL = , keywordList = ) ] from C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc
14 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
655 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

get (Datasource=dhs_legacy_live, Time=1ms, Records=217) in C:\inetpub\wwwroot\dhs\custom-application.cfm @ 13:27:31.031
    	SELECT lang_text_var, lang_text_en
        FROM dataset_lang_dictionary
    
CacheInfo (Datasource=commonspot-site-dhs, Time=4ms, Records=31) in C:\inetpub\wwwroot\commonspot\components\cache\cache-status.cfc @ 13:27:31.031
			SELECT *
			  FROM ElementInstance
			 WHERE SubsiteID=?
				AND PageID=?
				AND IsWIP=? 
				AND ServerID=? 
		 ORDER BY ControlID DESC,CacheLevel
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 18
Parameter #2(CF_SQL_INTEGER) = 148426
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 1

PagePermissions (Datasource=commonspot-site-dhs, Time=4ms, Records=0) in C:\inetpub\wwwroot\commonspot\components\cache\item-security-cache.cfc @ 13:27:31.031
			SELECT *
			  FROM ItemSecurity
			 WHERE PageID = ?
				AND ApplyTo = 0 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 148426

SelectedCustomRenderElements (Datasource=commonspot-site-dhs, Time=1ms, Records=21) in C:\inetpub\wwwroot\commonspot\set-page-vars.cfm @ 13:27:31.031
		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
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 1501
Parameter #3(CF_SQL_INTEGER) = 2
Parameter #4(CF_SQL_INTEGER) = 148426
Parameter #5(CF_SQL_INTEGER) = 4868
Parameter #6(CF_SQL_INTEGER) = 2

Request.PageData.PageParams (Datasource=commonspot-site-dhs, Time=1ms, Records=1) in C:\inetpub\wwwroot\commonspot\render-page-meat.cfm @ 13:27:31.031
			SELECT *
			  FROM Param_Page
			 WHERE (PageID=148426 OR (PageID IN (4868,1501,2,1) AND (VersionState = 2)))
			   AND VersionState=2
			 ORDER BY PageID DESC
		
qry (Datasource=commonspot-site-dhs, Time=1ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\core.cfm @ 13:27:31.031
					SELECT SubsiteID
					  FROM SitePages
					 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 148426

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 13:27:31.031
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 148426

qry (Datasource=commonspot-site-dhs, Time=1ms, Records=0) in C:\inetpub\wwwroot\commonspot\commands\livebookmarks.cfc @ 13:27:31.031
		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
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 148426
Parameter #2(CF_SQL_INTEGER) = 11


Scope Variables

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-10-17 17:16:40
search_orphan_next_clean=2021-10-17 17:16:41
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\Who-We-Are\News-Room\The-bid-for-harmless-mosquitoes.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=/Who-We-Are/News-Room/The-bid-for-harmless-mosquitoes.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\Who-We-Are\News-Room\The-bid-for-harmless-mosquitoes.cfm
QUERY_STRING=
REMOTE_ADDR=3.237.16.210
REMOTE_HOST=3.237.16.210
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/Who-We-Are/News-Room/The-bid-for-harmless-mosquitoes.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=1568855
CFTOKEN=8c012a405b1f5b86-905BA204-ADA5-73F5-2A69707B49CC9D34
Request Parameters:
anonnoreadelements=
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=29
cachestatus=Complex type
cfflushcount=0
cgivars=Struct (49)
constants=Complex type
cors.isCorsRequest=NO
cp=Struct (124)
cs_includedobjects=nwjs
cs_init_timings=Struct (23)
cs_isdashboardcmd=0
cs_runningdashboardcmdcode=0
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 (0)
elementsrun=0
environment=Struct (5)
finalreportids=5,26,21,10,18,30,39
finalreportna=139,315,445,488,107,138
formattedtimestamp=2021-10-17 13:27:31
getghost=
hivbold=1,3,8,9
ignoreauthuser=0
imageupfront=
imgdir=/images/
includerootdir=/
initialsiteid=1
initticks=1634477251156
jswarnmessage=
linkdataupfront_itempos=
linkdataupfront_itemtitle=
lockid=0
mainpage=Struct (86)
master_cfm_used=1
maxperms=Complex type
modeorderbyclause=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-10-17 13:27:31.151
req_sequenceid=9960
req_startticks=1634477251151
rootdir=/
rootpath=
rooturldatasetadmin=https://preview.dhsprogram.com/data/dataset_admin
scheduleupfront=
serverdatasource=commonspot-sites
sessionlockname=Session_1_587A34D73948852547AA8A3DB38C9F68.cfusion
sessionstring=1_587A34D73948852547AA8A3DB38C9F68.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=18
taiupfrontparam=
tbupfront=
tbupfrontparam=
templatecachestatus=Struct (1)
templaterootdir=/
timestamp={ts '2021-10-17 13:27:31'}
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=Cz/qOdKOVEQwE3OVjxl3UA==
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)
Session Variables:
adf=Struct (0)
authormode=0
contributemode=read
currentpageid=148426
debugmode=0
debugstate=Struct (1)
editmode=0
hasusertempfiles=0
language=Struct (216)
lastupdate=Struct (2)
lastuserupdate=1634477251163
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
ownedobjecttypes=
pendingapprovalpages=
pendingapprovals=
previewmode=0
requestedversioncounter=
requestedversiontimestamp=
sessionid=587A34D73948852547AA8A3DB38C9F68.cfusion
urltoken=CFID=1568855&CFTOKEN=8c012a405b1f5b86-905BA204-ADA5-73F5-2A69707B49CC9D34&jsessionid=587A34D73948852547AA8A3DB38C9F68.cfusion
usagelist=
user=Struct (27)
Debug Rendering Time: 19 ms