Journal Articles Search

Search Title, Abstract or Author:
Topics:
Adult Health Issues
Anemia
Anthropometry/Biomarkers
Child Health and Development
Climate and environment
COVID-19
Decolonization
Domestic Violence
Education
Family Planning
Female Genital Cutting
Fertility and Fertility Preferences
Gender
Geographic Information
Health facilities/SPA surveys
HIV/AIDS
Household and Respondent Characteristics
Infant and Child Mortality
Malaria
Maternal Health
Maternal Mortality
Mental Health
Non-communicable diseases
Nutrition
Other
Survey Methodology, Data Quality, Analysis
Wealth/Socioeconomics
Youth
Country:
Published from:
Journal: enter word(s) to find journals
 Sort By:
Results (1 - 11) of 11 Page(s): 1
Determinants of exclusive breast feeding among women of child bearing age in the Gambia using Gambia demographic and health survey (GDHS) 2019-20 data
Author(s): Babucarr Jassey and Ibrahim Touray
Journal: World Journal of Advanced Research and Reviews (AUG 2022) , Volume 14, issue 2; DOI:10.30574/wjarr.2022.14.2.0437
Topic(s): Child Health and Development , Nutrition
Country(s): Gambia
Web: https://wjarr.com/content/determinants-exclusive-breast-feed
Prevalence and determinants of meeting minimum dietary diversity among children aged 6–23 months in three sub-Saharan African Countries: The Demographic and Health Surveys, 2019–2020
Author(s): Djibril M. Ba, Paddy Ssentongo, Xiang Gao, Vernon M. Chinchilli, John P. Richie Jr., Mamoudou Maiga and Joshua E. Muscat
Journal: Frontiers in Public Health (AUG 2022) , DOI:https://doi.org/10.3389/fpubh.2022.846049
Topic(s): Child Health and Development , Nutrition
Country(s): Gambia, Liberia, Rwanda
Web: https://www.frontiersin.org/articles/10.3389/fpubh.2022.8460
Prevalence of and factors associated with tobacco smoking in the Gambia: a national cross-sectional study
Author(s): Md Shariful Islam, Haifaa AlWajeah, Md Golam Rabbani, Md Ferdous, Nusrat Sharmin Mahfuza, Daniel Konka, Eva Silenga, and Abu Naser Zafar Ullah
Journal: BMJ Open (JUN 2022) , Volume 12, issue 6; DOI:10.1136/bmjopen-2021-057607
Topic(s): Adult Health Issues , Wealth/Socioeconomics
Country(s): Gambia
Web: https://bmjopen.bmj.com/content/12/6/e057607
Determinants of pentavalent and measles vaccination dropouts among children aged 12–23 months in The Gambia
Author(s): Peter A. M. Ntenda, Alick Sixpence, Tisungane E. Mwenyenkulu, Kondwani Mmanga, Angeziwa C. Chirambo, Andy Bauleni and Owen Nkoka
Journal: BMC Public Health (MAR 2022) , Volume 22, issue 520; DOI:https://doi.org/10.1186/s12889-022-12914-6
Topic(s): Child Health and Development
Country(s): Gambia
Web: https://bmcpublichealth.biomedcentral.com/articles/10.1186/s
No relationship found between female genital cutting and intimate partner violence across six sub-Saharan African countries
Author(s): Janet A Howard, Mhairi A Gibson
Journal: Global Public Health (NOV 2021) , DOI:10.1080/17441692.2021.1991974
Topic(s): Domestic Violence , Female Genital Cutting , Gender
Country(s): Multiple African Countries, Gambia, Cote D'Ivoire, Kenya, Nigeria
Web: https://pubmed.ncbi.nlm.nih.gov/34743651/
Mind the gap: what explains the rural-nonrural inequality in diarrhoea among under-five children in low and medium-income countries? A decomposition analysis
Author(s): A. F. Fagbamigbe, F. F. Oyinlola, O. M. Morakinyo, A. S. Adebowale, O. S. Fagbamigbe, and A. O. Uthman
Journal: BMC Public Health (MAR 2021) , Volume 21; DOI: https://doi.org/10.1186/s12889-021-10615-0
Topic(s): Child Health and Development , Household and Respondent Characteristics
Country(s): Multiple African Countries, Comoros, Ethiopia, Malawi, Mozambique, Tanzania, Uganda, Burundi, Rwanda, Cameroon, Congo Democratic Republic, Chad, Gabon, Congo, Egypt, Namibia, South Africa, Zambia, Zimbabwe, Lesotho, Cote D'Ivoire, Ghana, Guinea, Mali, Nigeria, Burkina Faso, Senegal, Benin, Niger, Sierra Leone, Togo, Gambia, Kyrgyz Republic, Tajikistan, Cambodia, Philippines, Multiple Asian Countries, Bangladesh, India, Indonesia, Nepal, Pakistan, Afghanistan, Yemen, Jordan, Armenia, Multiple L.A./Caribbean Countries, Guatemala, Haiti, Peru, Dominican Republic, Honduras, Multiple Regions, Papua New Guinea, Albania, Myanmar, Timor-Leste
Web: https://bmcpublichealth.biomedcentral.com/articles/10.1186/s
Determinants of unmet need for family planning in Gambia & Mozambique: implications for women’s health
Author(s): Sanni Yaya, Dina Idriss-Wheeler, Olalekan A. Uthman, and Ghose Bishwajit
Journal: BMC Women's Health (MAR 2021) , Volume 21, Article number: 123; DOI: https://doi.org/10.1186/s12905-021-01267-8
Topic(s): Family Planning , Gender , Household and Respondent Characteristics , Maternal Health
Country(s): Mozambique, Gambia
Web: https://bmcwomenshealth.biomedcentral.com/articles/10.1186/s
Prevalence and determinants of unmet family planning needs among women of childbearing age in The Gambia: analysis of nationally representative data [version 2; peer review: 1 approved, 1 approved with reservations]
Author(s): Amadou Barrow, Amienatta Jobe, and Friday Okonofua
Journal: Gates Open Research (JAN 2021) , 4:124; DOI: https://doi.org/10.12688/gatesopenres.13175.2
Topic(s): Family Planning , Gender , Nutrition
Country(s): Gambia
Web: https://gatesopenresearch.org/articles/4-124
Factors associated with the continuum of care for maternal, newborn and child health in The Gambia: a cross-sectional study using Demographic and Health Survey 2013
Author(s): Jiyoung Oh, Juyoung Moon, Jae Wook Choi, and Kyunghee Kim
Journal: BMJ Open (NOV 2020) , Volume 10, Issue 11; DOI: 10.1136/bmjopen-2019-036516
Topic(s): Child Health and Development , Education , Family Planning , Maternal Health
Country(s): Gambia
Web: https://bmjopen.bmj.com/content/10/11/e036516
Under-five mortality in The Gambia: Comparison of the results of the first demographic and health survey with those from existing inquiries
Author(s): J. Rerimoi, Momodou Jasseh, Schadrac C. Agbla, Georges Reniers, Anna Roca, and Ian M. Timæus
Journal: PLOS ONE (JUL 2019) , 14(7): e0219919; DOI: 10.1371/journal.pone.0219919
Topic(s): Child Health and Development , Infant and Child Mortality
Country(s): Gambia
Web: https://journals.plos.org/plosone/article?id=10.1371%2Fjourn
Equity-Oriented Monitoring in the Context of Universal Health Coverage
Author(s): Ahmad Reza Hosseinpoor, Nicole Bergen, Theadora Koller, Amit Prasad, Anne Schlotheuber, Nicole Valentine, John Lynch, and Jeanette Vega
Journal: PLOS Medicine (SEP 2014) , 11(9): e1001727; DOI: 10.1371/journal.pmed.1001727
Topic(s): Wealth/Socioeconomics
Country(s): Multiple Asian Countries, Multiple Regions, Gambia, Bangladesh, Vietnam, Jordan
Web: https://www.ncbi.nlm.nih.gov/pmc/articles/PMC4171107/
Results (1 - 11) of 11 Page(s): 1


Debugging Information
ColdFusion Server Standard 2018,0,19,330149
Template /publications/Journal-Articles-Search.cfm
Time Stamp 04-Oct-24 08:39 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 10.0.2.225
Host Name 10.0.2.225


Execution Time

Total Time Avg Time Count Template
650 ms 26 ms 25 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element.cfm
649 ms 26 ms 25 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element-core.cfm
443 ms 443 ms 1 C:/inetpub/wwwroot/commonspot/master.cfm
443 ms 443 ms 1 C:/inetpub/wwwroot/dhs/publications/Journal-Articles-Search.cfm
412 ms 412 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cached-page-render.cfm
403 ms 403 ms 1 C:/inetpub/wwwroot/commonspot/uncached-master.cfm
388 ms 388 ms 1 C:/inetpub/wwwroot/commonspot/master-render.cfm
388 ms 388 ms 1 C:/inetpub/wwwroot/commonspot/render-page-meat.cfm
388 ms 388 ms 1 C:/inetpub/wwwroot/commonspot/render-page.cfm
367 ms 367 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm
349 ms 35 ms 10 C:/inetpub/wwwroot/commonspot/utilities/ct-render-named-element.cfm
312 ms 312 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p29042-c1378-l70-t51-dAny.read
282 ms 282 ms 1 C:/inetpub/wwwroot/commonspot/utilities/run-element.cfm
157 ms 157 ms 1 C:/inetpub/wwwroot/commonspot/controls/customcf/cpe-customcf.cfm
125 ms 125 ms 1 C:/inetpub/wwwroot/dhs/publications/customcf/journal-articles-search-cs.cfm
32 ms 16 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/public_api/cache.cfc | getElementCacheSettings(29042, 51214) ] from C:/inetpub/wwwroot/commonspot/public_api/cache.cfc
31 ms 31 ms 1 C:/inetpub/wwwroot/commonspot/set-page-vars.cfm
31 ms 31 ms 1 C:/inetpub/wwwroot/dhs/publications/customcf/journal-articles-search-form.cfm
16 ms 8 ms 2 C:/inetpub/wwwroot/commonspot/controls/ct-include-once.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/render-head.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/site-application.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/startup/site-application-meat.cfm
16 ms 8 ms 2 C:/inetpub/wwwroot/commonspot/utilities/newwindow-js.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/dhs/publications/Application.cfm
16 ms 8 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc | getPageSettings(1) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
4 ms 4 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p29042-c19155-l70-t51-dAny.read
2 ms 2 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p29042-c19177-l70-t51-dAny.read
1 ms 1 ms 1 C:/inetpub/wwwroot/commonspot/utilities/nocache-headers.cfm
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p29042-c1432-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p29042-c19152-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p29042-c19153-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p29042-c19154-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p29042-c19169-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p29042-c19172-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p29042-c19174-l70-t51-dAny.read
0 ms 0 ms 1 C:/inetpub/wwwroot/ADF/core/load_site_adf.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/controls/control-setup.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/controls/handle-styles.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/controls/upfront-generic.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/non-dashboard-include.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-foot.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-metatags.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-tracking-code.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/security/security-page.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/core-application-meat.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/init-customer-scope.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/init-server-scope.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/session-first-global.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/session-first-site.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/add-resource-request.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/build-user-struct.cfm
0 ms 0 ms 3 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 4 C:/inetpub/wwwroot/commonspot/utilities/handle-in-list.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/load-template-properties.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/newwindow-js-meat.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/update-page-cache-status.cfm
0 ms 0 ms 3 C:/inetpub/wwwroot/commonspot/utilities/validate-date-string.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-application.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/custom-search/inc-custom-application-search-vars.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.head
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc | getPageSettings(1652) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc | getPageSettings(2) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc | getPageSettings(29042) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
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 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | GetPageCacheStatus(1652, 2, 2, 0) ] 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(29042, 2, 1652, 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(argumentCollection = [complex value]) ] 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(2) ] from C:/inetpub/wwwroot/commonspot/components/cache/custom-module-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/custom-module-cache.cfc | getCustomModulePath(post-page-render, 2) ] from C:/inetpub/wwwroot/commonspot/components/cache/custom-module-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/item-security-cache.cfc | GetEntry(29042) ] from C:/inetpub/wwwroot/commonspot/components/cache/item-security-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/rewrite-rules-cache.cfc | getRewriteSettings(2) ] 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/cache/template-cache.cfc | LoadTemplateProperties(publication-template.cfm, 1652, 2) ] from C:/inetpub/wwwroot/commonspot/components/cache/template-cache.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/engine/ACF/utilities.cfc | checkFileExists(C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm, 0, false) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc | queryRowToStruct(ArgumentCollection = [complex value]) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.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=2)) ] 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(customerScope object 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(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 2 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(Cache) ] 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(Element) ] 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(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(29042, 2) ] from C:/inetpub/wwwroot/commonspot/components/util/visitor-context-rule-actions.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/element.cfc | getInfo(elementTypeID = 26) ] from C:/inetpub/wwwroot/commonspot/public_api/element.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc | appendEnforced(subsiteIDOrURL = , keywordList = Journal Articles Search) ] from C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc | getTags(29042) ] from C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/udf/database.cfc | getUDF(commonspot-site-dhs) ] from C:/inetpub/wwwroot/commonspot/udf/database.cfc
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
459 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

get (Datasource=dhs_legacy_live, Time=0ms, Records=217) in C:\inetpub\wwwroot\dhs\custom-application.cfm @ 08:39:54.054
    	SELECT lang_text_var, lang_text_en
        FROM dataset_lang_dictionary
    
SelectedCustomRenderElements (Datasource=commonspot-site-dhs, Time=31ms, Records=2059) in C:\inetpub\wwwroot\commonspot\set-page-vars.cfm @ 08:39:54.054
		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) = 2
Parameter #3(CF_SQL_INTEGER) = 1652
Parameter #4(CF_SQL_INTEGER) = 29042
Parameter #5(CF_SQL_INTEGER) = 2

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

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

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\commands\livebookmarks.cfc @ 08:39:54.054
		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) = 29042
Parameter #2(CF_SQL_INTEGER) = 11

ControlInstanceData (Datasource=commonspot-site-dhs, Time=0ms, Records=78) in C:\inetpub\wwwroot\commonspot\controls\control-setup.cfm @ 08:39:54.054
		SELECT ControlID, ControlName, ControlType, ParentControlID, ParentControlType, pageID
		  FROM ControlInstance
		 WHERE (PageID IN (?,?,?,?)) 
	 ORDER BY ControlID, PageID DESC
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 2
Parameter #3(CF_SQL_INTEGER) = 1652
Parameter #4(CF_SQL_INTEGER) = 29042

qInfo (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\element.cfc @ 08:39:54.054
		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 = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 400
Parameter #2(CF_SQL_INTEGER) = 22
Parameter #3(CF_SQL_INTEGER) = 44
Parameter #4(CF_SQL_INTEGER) = 55
Parameter #5(CF_SQL_INTEGER) = 1
Parameter #6(CF_SQL_INTEGER) = 56
Parameter #7(CF_SQL_INTEGER) = 47
Parameter #8(CF_SQL_INTEGER) = 26
Parameter #9(CF_SQL_INTEGER) = 48
Parameter #10(CF_SQL_INTEGER) = 27
Parameter #11(CF_SQL_INTEGER) = 28
Parameter #12(CF_SQL_INTEGER) = 51
Parameter #13(CF_SQL_INTEGER) = 31
Parameter #14(CF_SQL_INTEGER) = 33
Parameter #15(CF_SQL_INTEGER) = 26
Parameter #16(CF_SQL_INTEGER) = 48
Parameter #17(CF_SQL_INTEGER) = 37
Parameter #18(CF_SQL_INTEGER) = 27
Parameter #19(CF_SQL_INTEGER) = 38
Parameter #20(CF_SQL_INTEGER) = 28
Parameter #21(cf_sql_integer) = 26

Request.customCFUpfront (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\controls\upfront-generic.cfm @ 08:39:54.054
	SELECT *
	  FROM Data_CustomCF
	 WHERE (PageID=29042 OR (PageID IN (1652,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY ControlID, PageID DESC, VersionID DESC 
testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 08:39:54.054
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 29042

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\cache.cfc @ 08:39:54.054
		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 29042

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

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

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

qArticlePubID (Datasource=dhs_legacy_live, Time=0ms, Records=0) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-form.cfm @ 08:39:54.054
	SELECT pub_id FROM Dhs_article_pub
	WHERE ltrim(rtrim(pub_name)) = ''
qArticleTopic (Datasource=dhs_legacy_live, Time=0ms, Records=28) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-form.cfm @ 08:39:54.054
	SELECT pub_topic_id as topic_id, pub_topic_name as topic_name 
	FROM pub_topics
	WHERE journal_flag = 1
	order by pub_topic_name
qArticleCtry (Datasource=dhs_legacy_live, Time=0ms, Records=82) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-form.cfm @ 08:39:54.054
		SELECT *
		FROM Dhs_article_ctry c, Dhs_article_rgn r
		where r.rgn_id = c.country_rgn_id
		  and country_id NOT IN (2,23,35,47)
		order by Rgn_Name, country_name
	
qArticleRgn (Datasource=dhs_legacy_live, Time=0ms, Records=6) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-form.cfm @ 08:39:54.054
	SELECT Rgn_ID, Rgn_Code, Rgn_Name FROM Dhs_article_rgn
qRgnCtrys1 (Datasource=dhs_legacy_live, Time=0ms, Records=43) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-form.cfm @ 08:39:54.054
	SELECT *
		FROM Dhs_article_ctry c, Dhs_article_rgn r
		where r.rgn_id = c.country_rgn_id
		and r.rgn_id = 1
		order by rgn_name,country_id,country_name
	
qRgnCtrys2 (Datasource=dhs_legacy_live, Time=0ms, Records=26) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-form.cfm @ 08:39:54.054
	SELECT *
		FROM Dhs_article_ctry c, Dhs_article_rgn r
		where r.rgn_id = c.country_rgn_id
		and r.rgn_id = 2
		order by rgn_name,country_id,country_name
	
qRgnCtrys3 (Datasource=dhs_legacy_live, Time=0ms, Records=13) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-form.cfm @ 08:39:54.054
	SELECT *
		FROM Dhs_article_ctry c, Dhs_article_rgn r
		where r.rgn_id = c.country_rgn_id
		and r.rgn_id = 3
		order by rgn_name,country_id,country_name
	
qRgnCtrys4 (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-form.cfm @ 08:39:54.054
	SELECT *
		FROM Dhs_article_ctry c, Dhs_article_rgn r
		where r.rgn_id = c.country_rgn_id
		and r.rgn_id = 7
		order by rgn_name,country_id,country_name
	
qRgnCtrys5 (Datasource=dhs_legacy_live, Time=16ms, Records=2) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-form.cfm @ 08:39:54.054
	SELECT *
		FROM Dhs_article_ctry c, Dhs_article_rgn r
		where r.rgn_id = c.country_rgn_id
		and r.rgn_id = 9
		order by rgn_name,country_id,country_name
	
qRgnCtrys6 (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-form.cfm @ 08:39:54.054
	SELECT *
		FROM Dhs_article_ctry c, Dhs_article_rgn r
		where r.rgn_id = c.country_rgn_id
		and r.rgn_id = 10
		order by rgn_name,country_id,country_name
	
qArticlePub (Datasource=dhs_legacy_live, Time=0ms, Records=1120) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-form.cfm @ 08:39:54.054
	SELECT distinct a.pub_id, pub_name
	FROM dhs_articles a, Dhs_article_pub p 
	WHERE a.pub_id = p.pub_id 	
	  and active = 1
	order by pub_name
qTopicNames (Datasource=dhs_legacy_live, Time=15ms, Records=0) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-form.cfm @ 08:39:54.054
	SELECT pub_topic_name 
	FROM pub_topics
	WHERE pub_topic_id IN (0)
getArticles (Datasource=dhs_legacy_live, Time=0ms, Records=11) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:39:54.054
	SELECT  a.article_id, a.pub_id, title, authors, pub_name, article_date, article_year, vol, link, 
	   case when article_date = 'January' then 1
			when article_date = 'February' then 2
			when article_date = 'March' then 3
			when article_date = 'April' then 4
			when article_date = 'May' then 5
			when article_date = 'June' then 6
			when article_date = 'July' then 7
			when article_date = 'August' then 8
			when article_date = 'September' then 9
			when article_date = 'October' then 10
			when article_date = 'November' then 11
			when article_date = 'December' then 12
			end
	FROM dhs_articles a   
	INNER JOIN  Dhs_article_pub p ON a.pub_id = p.pub_id
	INNER JOIN  Dhs_article_type Tp ON a.article_type_id = Tp.Article_type_Id
	
	
	INNER JOIN dhs_article_Ctry_lnk lc ON lc.article_id=a.article_id
	INNER JOIN dhs_article_Ctry c ON c.country_id=lc.country_id
	INNER JOIN dhs_article_rgn r ON r.rgn_id=c.country_rgn_id 		
	
	
	WHERE a.article_id <> 0	
	  and active=1
	  and a.article_type_id=1	
	
	
	and c.country_id=93 
		Order By article_year desc, 
		           case when article_date = 'January' then 1
						when article_date = 'February' then 2
						when article_date = 'March' then 3
						when article_date = 'April' then 4
						when article_date = 'May' then 5
						when article_date = 'June' then 6
						when article_date = 'July' then 7
						when article_date = 'August' then 8
						when article_date = 'September' then 9
						when article_date = 'October' then 10
						when article_date = 'November' then 11
						when article_date = 'December' then 12
					end desc, authors	
	
distinct_cnt (Datasource=, Time=0ms, Records=11) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:39:54.054
	select distinct article_id from getArticles
	
getart_topic (Datasource=dhs_legacy_live, Time=16ms, Records=2) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:39:54.054
		select distinct article_id, t.pub_topic_id, pub_topic_name 
		from dhs_article_topics_lnk l, pub_topics t 
		where article_id=?
		and l.pub_topic_id=t.pub_topic_id
		order by pub_topic_name
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 5826

getart_Ctry (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:39:54.054
		select * from dhs_article_ctry_lnk l, dhs_article_ctry c ,dhs_article_rgn r
		where article_id=? and l.country_id=c.country_id
		and R.Rgn_id = c.country_rgn_id	
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 5826

getart_topic (Datasource=dhs_legacy_live, Time=0ms, Records=2) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:39:54.054
		select distinct article_id, t.pub_topic_id, pub_topic_name 
		from dhs_article_topics_lnk l, pub_topics t 
		where article_id=?
		and l.pub_topic_id=t.pub_topic_id
		order by pub_topic_name
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 5858

getart_Ctry (Datasource=dhs_legacy_live, Time=0ms, Records=3) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:39:54.054
		select * from dhs_article_ctry_lnk l, dhs_article_ctry c ,dhs_article_rgn r
		where article_id=? and l.country_id=c.country_id
		and R.Rgn_id = c.country_rgn_id	
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 5858

getart_topic (Datasource=dhs_legacy_live, Time=0ms, Records=2) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:39:54.054
		select distinct article_id, t.pub_topic_id, pub_topic_name 
		from dhs_article_topics_lnk l, pub_topics t 
		where article_id=?
		and l.pub_topic_id=t.pub_topic_id
		order by pub_topic_name
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 5762

getart_Ctry (Datasource=dhs_legacy_live, Time=15ms, Records=1) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:39:54.054
		select * from dhs_article_ctry_lnk l, dhs_article_ctry c ,dhs_article_rgn r
		where article_id=? and l.country_id=c.country_id
		and R.Rgn_id = c.country_rgn_id	
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 5762

getart_topic (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:39:54.054
		select distinct article_id, t.pub_topic_id, pub_topic_name 
		from dhs_article_topics_lnk l, pub_topics t 
		where article_id=?
		and l.pub_topic_id=t.pub_topic_id
		order by pub_topic_name
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 5697

getart_Ctry (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:39:54.054
		select * from dhs_article_ctry_lnk l, dhs_article_ctry c ,dhs_article_rgn r
		where article_id=? and l.country_id=c.country_id
		and R.Rgn_id = c.country_rgn_id	
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 5697

getart_topic (Datasource=dhs_legacy_live, Time=0ms, Records=3) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:39:54.054
		select distinct article_id, t.pub_topic_id, pub_topic_name 
		from dhs_article_topics_lnk l, pub_topics t 
		where article_id=?
		and l.pub_topic_id=t.pub_topic_id
		order by pub_topic_name
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 5588

getart_Ctry (Datasource=dhs_legacy_live, Time=16ms, Records=5) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:39:54.054
		select * from dhs_article_ctry_lnk l, dhs_article_ctry c ,dhs_article_rgn r
		where article_id=? and l.country_id=c.country_id
		and R.Rgn_id = c.country_rgn_id	
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 5588

getart_topic (Datasource=dhs_legacy_live, Time=0ms, Records=2) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:39:54.054
		select distinct article_id, t.pub_topic_id, pub_topic_name 
		from dhs_article_topics_lnk l, pub_topics t 
		where article_id=?
		and l.pub_topic_id=t.pub_topic_id
		order by pub_topic_name
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 5338

getart_Ctry (Datasource=dhs_legacy_live, Time=0ms, Records=57) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:39:54.054
		select * from dhs_article_ctry_lnk l, dhs_article_ctry c ,dhs_article_rgn r
		where article_id=? and l.country_id=c.country_id
		and R.Rgn_id = c.country_rgn_id	
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 5338

getart_topic (Datasource=dhs_legacy_live, Time=0ms, Records=4) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:39:54.054
		select distinct article_id, t.pub_topic_id, pub_topic_name 
		from dhs_article_topics_lnk l, pub_topics t 
		where article_id=?
		and l.pub_topic_id=t.pub_topic_id
		order by pub_topic_name
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4916

getart_Ctry (Datasource=dhs_legacy_live, Time=16ms, Records=2) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:39:54.054
		select * from dhs_article_ctry_lnk l, dhs_article_ctry c ,dhs_article_rgn r
		where article_id=? and l.country_id=c.country_id
		and R.Rgn_id = c.country_rgn_id	
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4916

getart_topic (Datasource=dhs_legacy_live, Time=0ms, Records=3) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:39:54.054
		select distinct article_id, t.pub_topic_id, pub_topic_name 
		from dhs_article_topics_lnk l, pub_topics t 
		where article_id=?
		and l.pub_topic_id=t.pub_topic_id
		order by pub_topic_name
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4924

getart_Ctry (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:39:54.054
		select * from dhs_article_ctry_lnk l, dhs_article_ctry c ,dhs_article_rgn r
		where article_id=? and l.country_id=c.country_id
		and R.Rgn_id = c.country_rgn_id	
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4924

getart_topic (Datasource=dhs_legacy_live, Time=0ms, Records=4) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:39:54.054
		select distinct article_id, t.pub_topic_id, pub_topic_name 
		from dhs_article_topics_lnk l, pub_topics t 
		where article_id=?
		and l.pub_topic_id=t.pub_topic_id
		order by pub_topic_name
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4774

getart_Ctry (Datasource=dhs_legacy_live, Time=15ms, Records=1) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:39:54.054
		select * from dhs_article_ctry_lnk l, dhs_article_ctry c ,dhs_article_rgn r
		where article_id=? and l.country_id=c.country_id
		and R.Rgn_id = c.country_rgn_id	
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4774

getart_topic (Datasource=dhs_legacy_live, Time=0ms, Records=2) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:39:54.054
		select distinct article_id, t.pub_topic_id, pub_topic_name 
		from dhs_article_topics_lnk l, pub_topics t 
		where article_id=?
		and l.pub_topic_id=t.pub_topic_id
		order by pub_topic_name
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3818

getart_Ctry (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:39:54.054
		select * from dhs_article_ctry_lnk l, dhs_article_ctry c ,dhs_article_rgn r
		where article_id=? and l.country_id=c.country_id
		and R.Rgn_id = c.country_rgn_id	
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3818

getart_topic (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:39:54.054
		select distinct article_id, t.pub_topic_id, pub_topic_name 
		from dhs_article_topics_lnk l, pub_topics t 
		where article_id=?
		and l.pub_topic_id=t.pub_topic_id
		order by pub_topic_name
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3253

getart_Ctry (Datasource=dhs_legacy_live, Time=0ms, Records=6) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:39:54.054
		select * from dhs_article_ctry_lnk l, dhs_article_ctry c ,dhs_article_rgn r
		where article_id=? and l.country_id=c.country_id
		and R.Rgn_id = c.country_rgn_id	
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3253

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

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\cache.cfc @ 08:39:54.054
		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 29042

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

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

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


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,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 (7)
pendingstubrequests=Struct (0)
rsscache=Struct (2)
search_archive_next_clean=2024-10-04 16:05:16
serverclockcheck=2024-09-30 15:39:19
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\publications\Journal-Articles-Search.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=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=
HTTP_COOKIE=
HTTP_HOST=preview.dhsprogram.com
HTTP_REFERER=
HTTP_URL=/publications/Journal-Articles-Search.cfm?C_id=93&page=1
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
LOCAL_ADDR=10.0.0.111
PATH_INFO=
PATH_TRANSLATED=C:\inetpub\wwwroot\dhs\publications\Journal-Articles-Search.cfm
QUERY_STRING=C_id=93&page=1
REMOTE_ADDR=10.0.2.225
REMOTE_HOST=10.0.2.225
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/publications/Journal-Articles-Search.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=FE4CA6055056F9DB379BB6F4A2FB99D551E0DC32
Form Fields:
ALL=0
ALL_TOPIC=0
BACK=0
CTRY=93
C_id=93
FORWARD=0
PUB=
R_ID=
SELECTED=0
SORT=2
TOPIC=
TP=
YEAR1=
YEAR2=
page=1
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=23
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=2495632176
cs_runningdashboardcmdcode=0
csrftoken=FE4CA6055056F9DB379BB6F4A2FB99D551E0DC32
ctrl_data=Struct (66)
customcf_data=Struct (2)
customcfupfront=Query (1)
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 (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-10-04 08:39:54
getghost=
hivbold=1,3,8,9
imageupfront=
imgdir=/images/
includerootdir=/
initialsiteid=1
initticks=1728031194736
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 (6)
params_formfields=
params_urlfields=page,C_id
previewmode=0
readmodewhereclause=(VersionState = 2)
renderedelements=Struct (0)
renderelementdata=Struct (0)
renderfordiff=0
renderforprint=0
renderstate=Struct (73)
req_cam_callcount=1
req_inittimestamp=2024-10-04 08:39:54.736
req_sequenceid=128125
req_startticks=1728031194736
rootdir=/
rootpath=
rooturldatasetadmin=https://preview.dhsprogram.com/data/dataset_admin
samesite_value=
scheduleupfront=
serverdatasource=commonspot-sites
sessionlockname=Session_1_ADF5E6B3F486E63671EEA52FDA966BEC.cfusion
sessionstring=1_ADF5E6B3F486E63671EEA52FDA966BEC.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=2
taiupfrontparam=
tbupfront=
tbupfrontparam=
templatecachestatus=Struct (0)
templaterootdir=/
timestamp={ts '2024-10-04 08:39:54'}
trustcachestatus=1
typefactory=Complex type
udslockname=CS_Customer_commonspot-users
updatingschemas=0
user=Struct (30)
usersdatasource=commonspot-users
wanterrorsrethrown=0
warnmessage=
xmlbrowser=Struct (13)
Server Variables:
ADF=Struct (15)
COMMONSPOT=Struct (44)
EMAILALERTKEY=0BZ8ueP9r+2oypDPCudA3A==
SURVEYINFO_ACTIVE_DATE=2024-10-9
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)
Session Variables:
_csrf_token=FE4CA6055056F9DB379BB6F4A2FB99D551E0DC32
adf=Struct (0)
authormode=0
contributemode=read
currentpageid=29042
debugmode=0
debugstate=Struct (1)
editmode=0
environment=Struct (5)
groupbyregion=
hasusertempfiles=0
language=Struct (216)
lastupdate=Struct (2)
lastuserupdate=1728031194736
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
ownedobjecttypes=
pendingapprovalpages=
pendingapprovals=
previewmode=0
requestedversioncounter=
requestedversiontimestamp=
sessionid=ADF5E6B3F486E63671EEA52FDA966BEC.cfusion
sessionstring=1_ADF5E6B3F486E63671EEA52FDA966BEC.cfusion
urltoken=CFID=9306962&CFTOKEN=2ff81840d3a8396c-62DA4EBB-E94E-CF0D-6AA848EAEE050BB2&jsessionid=ADF5E6B3F486E63671EEA52FDA966BEC.cfusion
usagelist=
user=Struct (30)
xmlbrowser=Struct (13)
xmlenvironment=Struct (5)
URL Parameters:
C_id=93
page=1
Debug Rendering Time: 31 ms