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 - 14) of 14 Page(s): 1
Predictors of contraceptive method discontinuation among adolescent and young women in three West African countries (Burkina Faso, Mali, and Niger)
Author(s): Adja Mariam Ouedraogo, Adama Baguiya, Rachidatou Compaore, Kadari Cisse, Desire Lucien Dahourou, Anthony Some, Halima Tougri, and Seni Kouanda
Journal: BMC Women's Health (JUN 2021) , Volume 21, Article number: 261; DOI: https://doi.org/10.1186/s12905-021-01326-0
Topic(s): Family Planning
Country(s): Multiple African Countries, Mali, Burkina Faso, Niger
Web: https://bmcwomenshealth.biomedcentral.com/articles/10.1186/s
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
Modelling children's anthropometric status using Bayesian distributional regression merging socio-economic and remote sensed data from South Asia and sub-Saharan Africa
Author(s): Johannes Seiler, Kenneth Harttgen, Thomas Kneib, and Stefan Lang
Journal: Economics and Human Biology (JAN 2021) , Volume 40; DOI: https://doi.org/10.1016/j.ehb.2020.100950
Topic(s): Anthropometry/Biomarkers , Child Health and Development , Nutrition , Survey Methodology, Data Quality, Analysis , Wealth/Socioeconomics
Country(s): Nigeria, Niger, Madagascar, India, Multiple Regions
Web: https://www.sciencedirect.com/science/article/pii/S1570677X2
Spatial analysis of individual and village level sociodemographic characteristics associated with age at first marriage among married adolescents in rural Niger
Author(s): Mukesh Adhikari, Binaya Chalise, Bihungum Bista, Achyut Raj Pandey, and Dipak Prasad Upadhyaya
Journal: BMC Pregnancy and Childbirth (SEP 2020) , 20(Article number: 513); DOI: 10.1186/s12884-020-03218-x
Topic(s): Fertility and Fertility Preferences , Gender , Youth
Country(s): Niger
Web: https://bmcpregnancychildbirth.biomedcentral.com/articles/10
Skilled birth attendance in Sierra Leone, Niger, and Mali: analysis of demographic and health surveys
Author(s): Edward Kwabena Ameyaw, and Kwamena Sekyi Dickson
Journal: BMC Public Health (FEB 2020) , 20(164): 1-10; DOI: 10.1186/s12889-020-8258-z
Topic(s): Maternal Health
Country(s): Multiple African Countries, Mali, Niger, Sierra Leone
Web: https://link.springer.com/article/10.1186/s12889-020-8258-z
Forty years of fertility changes in the Sahel
Author(s): Thomas Spoorenberg
Journal: Demographic Research (NOV 2019) , 41(46): 1289-1314; DOI: 10.4054/DemRes.2019.41.46
Topic(s): Fertility and Fertility Preferences
Country(s): Multiple African Countries, Mali, Burkina Faso, Niger, Chad
Web: https://www.demographic-research.org/volumes/vol41/46/41-46.
Fertility compression in Niger: A study of fertility change by parity (1977–2011)
Author(s): Thomas Spoorenberg, and Hamidou Issaka Maga
Journal: Demographic Research (OCT 2018) , 39(24): 685-700; DOI: 10.4054/DemRes.2018.39.24
Topic(s): Fertility and Fertility Preferences , Gender
Country(s): Niger
Web: https://www.demographic-research.org/volumes/vol39/24/39-24.
Does Place and Attendance at Birth Improve Early Neonatal Mortality? Secondary Analysis of Nine Demographic and Health Surveys
Author(s): S Bellizzi, H L Sobel, M Mathai, and M Temmerman
Journal: BJOG: An International Journal of Obstetrics & Gynaecology (SEP 2017) , 124(10): 1558-1565; DOI: 10.1111/1471-0528.14422
Topic(s): Infant and Child Mortality , Maternal Health
Country(s): Mali, Niger, Bangladesh, Indonesia, Philippines, Colombia, Peru, Honduras, Multiple Regions, Sao Tome and Principe
Web: https://obgyn.onlinelibrary.wiley.com/doi/epdf/10.1111/1471-
Predicting Maternal Health Care Use by Age at Marriage in Multiple Countries
Author(s): Deepali Godha, Anastasia J Gage, David R Hotchkiss, and Claudia Cappa
Journal: Journal of Adolescent Health (MAY 2016) , 58(5): 504-11; DOI: 10.1016/j.jadohealth.2016.01.001
Topic(s): Child Health and Development , Fertility and Fertility Preferences , Gender , Maternal Health , Other , Youth
Country(s): Bangladesh, Nepal, Ethiopia, Mali, Mozambique, Burkina Faso, Niger, Multiple Regions
Niger's Child Survival Success, Contributing Factors and Challenges to Sustainability: A Retrospective Analysis
Author(s): Donela Besada, Kate Kerber, Natalie Leon, David Sanders, Emmanuelle Daviaud, Sarah Rohde, Jon Rohde, Wim van Damme, Mary Kinney, Samuel Manda, Nicholas P Oliphant, Fatima Hachimou, Adama Ouedraogo, Asma Yaroh Ghali, and Tanya Doherty
Journal: PLOS ONE (JAN 2016) , 11(1): e0146945; DOI: 10.1371/journal.pone.0146945
Topic(s): Child Health and Development , Infant and Child Mortality
Country(s): Niger
Web: https://journals.plos.org/plosone/article?id=10.1371/journal
Individual characteristics and use of maternal and child health services by adolescent mothers in Niger
Author(s): Rai RK, Singh PK, Singh L, and Kumar C.
Journal: Maternal and Child Health Journal (APR 2014) , 18(3):592-603. doi: 10.1007/s10995-013-1276-z.
Topic(s): Child Health and Development , Maternal Health , Other , Youth
Country(s): Niger
It's a Long, Long Walk: Accessibility to Hospitals, Maternity and Integrated Health Centers in Niger
Author(s): Blanford JI, Kumar S, Luo W, MacEachren AM.
Journal: International Journal of Health Geographics (JUN 2012) , 11:24. doi: 10.1186/1476-072X-11-24.
Topic(s): Geographic Information , Other
Country(s): Niger
Web: http://www.ncbi.nlm.nih.gov/pmc/articles/PMC3515413/
Estimates of HIV Incidence from Household-based Prevalence Surveys
Author(s): Timothy B. Hallett, John Stover, Vinod Mishra, Peter D. Ghys, Simon Gregsone and Ties Boerma
Journal: AIDS (JAN 2010) , 2010, 24:147–152
Topic(s): HIV/AIDS
Country(s): Mali, Tanzania, Zambia, Niger, Dominican Republic
Collective violence and attitudes of women toward intimate partner violence: Evidence from the Niger Delta.
Author(s): Antai D, Antai J.
Journal: BMC International Health and Human Rights (JUN 2009) , 9:12. doi: 10.1186/1472-698X-9-12.
Topic(s): Domestic Violence
Country(s): Niger
Results (1 - 14) of 14 Page(s): 1


Debugging Information
ColdFusion Server Standard 2018,0,19,330149
Template /publications/Journal-Articles-Search.cfm
Time Stamp 04-Oct-24 08:19 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
923 ms 37 ms 25 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element-core.cfm
923 ms 37 ms 25 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element.cfm
549 ms 549 ms 1 C:/inetpub/wwwroot/commonspot/master.cfm
549 ms 549 ms 1 C:/inetpub/wwwroot/dhs/Publications/Journal-Articles-Search.cfm
500 ms 500 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cached-page-render.cfm
485 ms 485 ms 1 C:/inetpub/wwwroot/commonspot/master-render.cfm
485 ms 485 ms 1 C:/inetpub/wwwroot/commonspot/render-page-meat.cfm
485 ms 485 ms 1 C:/inetpub/wwwroot/commonspot/render-page.cfm
485 ms 485 ms 1 C:/inetpub/wwwroot/commonspot/uncached-master.cfm
454 ms 45 ms 10 C:/inetpub/wwwroot/commonspot/utilities/ct-render-named-element.cfm
454 ms 454 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm
422 ms 422 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p29042-c1378-l70-t51-dAny.read
390 ms 390 ms 1 C:/inetpub/wwwroot/commonspot/utilities/run-element.cfm
203 ms 203 ms 1 C:/inetpub/wwwroot/commonspot/controls/customcf/cpe-customcf.cfm
172 ms 172 ms 1 C:/inetpub/wwwroot/dhs/publications/customcf/journal-articles-search-cs.cfm
49 ms 49 ms 1 C:/inetpub/wwwroot/dhs/publications/customcf/journal-articles-search-form.cfm
48 ms 48 ms 1 C:/inetpub/wwwroot/commonspot/site-application.cfm
48 ms 48 ms 1 C:/inetpub/wwwroot/commonspot/startup/site-application-meat.cfm
48 ms 48 ms 1 C:/inetpub/wwwroot/dhs/Publications/Application.cfm
32 ms 32 ms 1 C:/inetpub/wwwroot/commonspot/set-page-vars.cfm
31 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
16 ms 16 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p29042-c19152-l70-t51-dAny.read
16 ms 16 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p29042-c19155-l70-t51-dAny.read
16 ms 16 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p29042-c19177-l70-t51-dAny.read
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/controls/control-setup.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/startup/core-application-meat.cfm
16 ms 16 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
16 ms 16 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 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-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 2 C:/inetpub/wwwroot/commonspot/controls/ct-include-once.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-head.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/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 2 C:/inetpub/wwwroot/commonspot/utilities/newwindow-js.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/nocache-headers.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(1) ] 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(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(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/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
597 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:19:42.042
    	SELECT lang_text_var, lang_text_en
        FROM dataset_lang_dictionary
    
SelectedCustomRenderElements (Datasource=commonspot-site-dhs, Time=32ms, Records=2059) in C:\inetpub\wwwroot\commonspot\set-page-vars.cfm @ 08:19:42.042
		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:19:42.042
			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:19:42.042
					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:19:42.042
		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:19:42.042
		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:19:42.042
		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:19:42.042
		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:19:42.042
	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:19:42.042
		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:19:42.042
		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:19:42.042
		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:19:42.042
		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:19:42.042
		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:19:42.042
	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:19:42.042
	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:19:42.042
		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:19:42.042
	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:19:42.042
	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:19:42.042
	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:19:42.042
	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:19:42.042
	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=0ms, Records=2) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-form.cfm @ 08:19:42.042
	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:19:42.042
	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=33ms, Records=1120) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-form.cfm @ 08:19:42.042
	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=0ms, Records=0) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-form.cfm @ 08:19:42.042
	SELECT pub_topic_name 
	FROM pub_topics
	WHERE pub_topic_id IN (0)
getArticles (Datasource=dhs_legacy_live, Time=14ms, Records=14) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:19:42.042
	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=67 
		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=14) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:19:42.042
	select distinct article_id from getArticles
	
getart_topic (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:19:42.042
		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) = 4960

getart_Ctry (Datasource=dhs_legacy_live, Time=16ms, Records=4) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:19:42.042
		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) = 4960

getart_topic (Datasource=dhs_legacy_live, Time=0ms, Records=2) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:19:42.042
		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:19:42.042
		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=5) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:19:42.042
		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) = 5225

getart_Ctry (Datasource=dhs_legacy_live, Time=15ms, Records=5) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:19:42.042
		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) = 5225

getart_topic (Datasource=dhs_legacy_live, Time=0ms, Records=3) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:19:42.042
		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) = 4679

getart_Ctry (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:19:42.042
		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) = 4679

getart_topic (Datasource=dhs_legacy_live, Time=16ms, Records=1) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:19:42.042
		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) = 4396

getart_Ctry (Datasource=dhs_legacy_live, Time=0ms, Records=4) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:19:42.042
		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) = 4396

getart_topic (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:19:42.042
		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) = 4126

getart_Ctry (Datasource=dhs_legacy_live, Time=0ms, Records=5) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:19:42.042
		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) = 4126

getart_topic (Datasource=dhs_legacy_live, Time=0ms, Records=2) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:19:42.042
		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) = 3374

getart_Ctry (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:19:42.042
		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) = 3374

getart_topic (Datasource=dhs_legacy_live, Time=0ms, Records=2) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:19:42.042
		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) = 4251

getart_Ctry (Datasource=dhs_legacy_live, Time=0ms, Records=10) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:19:42.042
		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) = 4251

getart_topic (Datasource=dhs_legacy_live, Time=0ms, Records=6) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:19:42.042
		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) = 4263

getart_Ctry (Datasource=dhs_legacy_live, Time=20ms, Records=8) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:19:42.042
		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) = 4263

getart_topic (Datasource=dhs_legacy_live, Time=0ms, Records=2) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:19:42.042
		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) = 3955

getart_Ctry (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:19:42.042
		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) = 3955

getart_topic (Datasource=dhs_legacy_live, Time=12ms, Records=4) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:19:42.042
		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) = 2434

getart_Ctry (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:19:42.042
		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) = 2434

getart_topic (Datasource=dhs_legacy_live, Time=0ms, Records=2) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:19:42.042
		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) = 1609

getart_Ctry (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:19:42.042
		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) = 1609

getart_topic (Datasource=dhs_legacy_live, Time=15ms, Records=1) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:19:42.042
		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) = 680

getart_Ctry (Datasource=dhs_legacy_live, Time=0ms, Records=5) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:19:42.042
		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) = 680

getart_topic (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:19:42.042
		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) = 1327

getart_Ctry (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 08:19:42.042
		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) = 1327

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 08:19:42.042
		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:19:42.042
		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:19:42.042
		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:19:42.042
		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:19:42.042
		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=67&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=67&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=68C8580E666ED1A40114A94A2E7ED100B4D06F5B
Form Fields:
ALL=0
ALL_TOPIC=0
BACK=0
CTRY=67
C_id=67
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=2271166128
cs_runningdashboardcmdcode=0
csrftoken=68C8580E666ED1A40114A94A2E7ED100B4D06F5B
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:19:42
getghost=
hivbold=1,3,8,9
imageupfront=
imgdir=/images/
includerootdir=/
initialsiteid=1
initticks=1728029982560
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=C_id,page
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:19:42.544
req_sequenceid=127854
req_startticks=1728029982544
rootdir=/
rootpath=
rooturldatasetadmin=https://preview.dhsprogram.com/data/dataset_admin
samesite_value=
scheduleupfront=
serverdatasource=commonspot-sites
sessionlockname=Session_1_EEF92996EE0A64A768A38B7350D52121.cfusion
sessionstring=1_EEF92996EE0A64A768A38B7350D52121.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:19:42'}
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=68C8580E666ED1A40114A94A2E7ED100B4D06F5B
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=1728029982560
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
ownedobjecttypes=
pendingapprovalpages=
pendingapprovals=
previewmode=0
requestedversioncounter=
requestedversiontimestamp=
sessionid=EEF92996EE0A64A768A38B7350D52121.cfusion
sessionstring=1_EEF92996EE0A64A768A38B7350D52121.cfusion
urltoken=CFID=9305572&CFTOKEN=bf33a4eb57706f83-62215835-9F01-3DF1-0C63B7A39A7A0158&jsessionid=EEF92996EE0A64A768A38B7350D52121.cfusion
usagelist=
user=Struct (30)
xmlbrowser=Struct (13)
xmlenvironment=Struct (5)
URL Parameters:
C_id=67
page=1
Debug Rendering Time: 16 ms