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
 Filter By:
 Sort By:
Results (1 - 25) of 648 Page(s): 1 2 3 4 5 6 7 8 9 10 >>  Next
Breastfeeding performance index and associated factors among children aged 0–6 months in Ethiopia: Analysis of the 2019 Ethiopia Mini Demographic and Health Survey
Author(s): Getachew Tilahun Gessese, Berhanu Teshome Woldeamanuel, Takele Gezahegn Demie, Tolesa Diriba Biratu and Simegnew Handebo
Journal: Frontiers in Nutrition (OCT 2022) , DOI:https://doi.org/10.3389/fnut.2022.970737
Topic(s): Child Health and Development , Infant and Child Mortality , Nutrition
Country(s): Ethiopia
Web: https://www.frontiersin.org/articles/10.3389/fnut.2022.97073
Divergent age patterns of under-5 mortality in south Asia and sub-Saharan Africa: a modelling study
Author(s): Andrea Verhulst, Julio Romero Prieto, Nurul Alam, Hallie Eilerts-Spinelli, Daniel J Erchick, Patrick Gerland, Joanne Katz, Bruno Lankoande, Li Liu, Gilles Pison, Georges Reniers, Seema Subedi, Francisco Villavicencio, and Prof Michel Guillot
Journal: Lancet (SEP 2022) , Volume 10, issue 11; DOI:https://doi.org/10.1016/S2214-109X(22)00337-0
Topic(s): Child Health and Development , Infant and Child Mortality
Country(s): Multiple Regions
Web: https://www.thelancet.com/journals/langlo/article/PIIS2214-1
Evaluating the impact of maternal health care policy on stillbirth and perinatal mortality in Ghana; a mixed method approach using two rounds of Ghana demographic and health survey data sets and qualitative design technique
Author(s): John Azaare, Patricia Akweongo, Genevieve Cecilia Aryeteey, Duah Dwomoh
Journal: PLOS ONE (SEP 2022) , DOI: 10.1371/journal.pone.0274573
Topic(s): Fertility and Fertility Preferences , Infant and Child Mortality , Maternal Health
Country(s): Ghana
Web: https://pubmed.ncbi.nlm.nih.gov/36174023/
Infant mortality and risk factors in Nigeria in 2013–2017: A population-level study
Author(s): Damilola M. Shobiye, Ayomide Omotola, Yueming Zhao, Jianrong Zhang, Fitriana M. Ekawati,e and Hezekiah O. Shobiye
Journal: EClinicalMedicine (AUG 2022) , DOI:https://doi.org/10.1016/j.eclinm.2022.101622
Topic(s): Household and Respondent Characteristics , Infant and Child Mortality , Wealth/Socioeconomics
Country(s): Nigeria
Web: https://www.thelancet.com/journals/eclinm/article/PIIS2589-5
Modelling the impact of maternal pneumococcal vaccination on infant pneumococcal disease in low-income settings
Author(s): Gizem M.Bilgin, KamaliniLokuge, KathrynGlass
Journal: Vaccine (JUL 2022) , Volume 40, issue 31; DOI:https://doi.org/10.1016/j.vaccine.2022.05.066
Topic(s): Child Health and Development , Infant and Child Mortality , Maternal Mortality , Survey Methodology, Data Quality, Analysis
Country(s): Multiple Regions
Web: https://www.sciencedirect.com/science/article/pii/S0264410X2
Trends and Factors Associated with Under-5 Mortality in Northwest Nigeria (2008–2018)
Author(s): Osita K. Ezeh , Anastasia O. Odumegwu, Gladys H. Oforkansi, Uchechukwu D. Abada, Felix A. Ogbo, Piwuna C. Goson, Tanko Ishaya, Kingsley E. Agho
Journal: Annals of Global Health (JUL 2022) , Volume 88, issue 1; DOI:http://doi.org/10.5334/aogh.3564
Topic(s): Child Health and Development , Family Planning , Fertility and Fertility Preferences , Geographic Information , Infant and Child Mortality , Maternal Mortality
Country(s): Nigeria
Web: https://annalsofglobalhealth.org/articles/10.5334/aogh.3564/
Trends of under-five mortality and associated risk factors in Zambia: a multi survey analysis between 2007 and 2018
Author(s): Amanuel Kidane Andegiorgish, Henok G. Woldu, Mohamed Elhoumed, Zhonghai Zhu and Lingxia Zeng
Journal: BMC Pediatrics (JUN 2022) , Volume 22, issue 341; DOI:https://doi.org/10.1186/s12887-022-03362-7
Topic(s): Child Health and Development , Infant and Child Mortality
Country(s): Zambia
Web: https://bmcpediatr.biomedcentral.com/articles/10.1186/s12887
Parametric Frailty Analysis in Presence of Collinearity: An Application to Assessment of Infant Mortality
Author(s): Olayan Albalawi, Anu Sirohi, Piyush Kant Rai, and Ayed R. A. Alanzi
Journal: Mathematics (JUN 2022) , Volume 10, issue 2255; DOI:https://doi.org/10.3390/math10132255
Topic(s): Child Health and Development , Infant and Child Mortality , Survey Methodology, Data Quality, Analysis
Country(s): India
Web: https://doaj.org/article/b8342d45c32245e393e747ec0949d420
Analysis of risk factors associated with acute respiratory infections among under-five children in Uganda
Author(s): Yassin Nshimiyimana and Yingchun Zhou
Journal: BMC Public Health (JUN 2022) , Volume 22, issue 1209; DOI:https://doi.org/10.1186/s12889-022-13532-y
Topic(s): Adult Health Issues , Child Health and Development , Infant and Child Mortality
Country(s): Uganda
Web: https://bmcpublichealth.biomedcentral.com/articles/10.1186/s
Determinants of under-five mortality in Ethiopia using the recent 2019 Ethiopian demographic and health survey data: nested shared frailty survival analysis
Author(s): Belete Achamyelew Ayele, Sofonyas Abebaw Tiruneh, Melkalem Mamuye Azanaw, Habtamu Shimels Hailemeskel, Yonas Akalu and Asnakew Achaw Ayele
Journal: Archives of Public Health (MAY 2022) , Volume 80, issue137; DOI:https://doi.org/10.1186/s13690-022-00896-1
Topic(s): Child Health and Development , Infant and Child Mortality , Maternal Mortality
Country(s): Ethiopia
Web: https://archpublichealth.biomedcentral.com/articles/10.1186/
Application of machine learning methods for predicting infant mortality in Rwanda: analysis of Rwanda demographic health survey 2014–15 dataset
Author(s): Emmanuel Mfateneza, Pierre Claver Rutayisire, Emmanuel Biracyaza, Sanctus Musafiri and Willy Gasafari Mpabuka
Journal: BMC Pregnancy and Childbirth (MAY 2022) , Volume 22; issue 388; DOI:https://doi.org/10.1186/s12884-022-04699-8
Topic(s): Infant and Child Mortality , Survey Methodology, Data Quality, Analysis
Country(s): Multiple Regions
Web: https://bmcpregnancychildbirth.biomedcentral.com/articles/10
The effects of community clustering on under-five mortality in India: a parametric shared frailty modelling approach
Author(s): Wahengbam Bigyananda Meitei, Abhishek Singh and Laishram Ladusingh
Journal: Genus (MAY 2022) , Volume 78, issue 18; DOI:https://doi.org/10.1186/s41118-022-00165-7
Topic(s): Child Health and Development , Infant and Child Mortality , Maternal Mortality , Nutrition , Survey Methodology, Data Quality, Analysis
Country(s): India
Web: https://genus.springeropen.com/articles/10.1186/s41118-022-0
Prevalence and Risk Factors of Gestational Diabetes Mellitus in Bangladesh: Findings from Demographic Health Survey 2017–2018
Author(s): Mazumder, Tapas, Ema Akter, Syed M. Rahman, Md. T. Islam, and Mohammad R. Talukder
Journal: International Journal of Environmental Research and Public Health (FEB 2022) , DOI:https://doi.org/10.3390/ijerph19052583
Topic(s): Adult Health Issues , Anthropometry/Biomarkers , Infant and Child Mortality , Non-communicable diseases , Nutrition
Country(s): Bangladesh
Web: https://www.mdpi.com/1660-4601/19/5/2583/htm
A growing disadvantage of being born in an urban area? Analysing urban–rural disparities in neonatal mortality in 21 African countries with a focus on Tanzania
Author(s): Megan Norris, Gonnie Klabbers, Andrea B. Pembe, Claudia Hanson, Ulrika Baker, Kyaw Aung, Mary Mmweteni, Rashid S. Mfaume, Lenka Benová
Journal: BMJ Global Health (JAN 2022) , Volume 7, issue 1; DOI:10.1136/bmjgh-2021-007544
Topic(s): Household and Respondent Characteristics , Infant and Child Mortality
Country(s): Multiple African Countries, Tanzania
Web: https://gh.bmj.com/content/7/1/e007544
Determinants of Neonatal Mortality in Kenya: Evidence from the Kenya Demographic and Health Survey 2014
Author(s): Akinyi E. Imbo, Elizabeth K. Mbuthia, Douglas N. Ngotho
Journal: International Journal of MCH and AIDS (DEC 2021) , Volume 10, issue 2; DOI: 10.21106/ijma.508
Topic(s): Child Health and Development , Fertility and Fertility Preferences , Infant and Child Mortality , Maternal Health
Country(s): Kenya
Web: https://pubmed.ncbi.nlm.nih.gov/34938597/
Hospital delivery and neonatal mortality in 37 countries in sub-Saharan Africa and South Asia: An ecological study
Author(s): Anna D. Gage, Günther Fink, John E. Ataguba, Margaret E. Kruk
Journal: PLOS Medicine (DEC 2021) , DOI:https://doi.org/10.1371/journal.pmed.1003843
Topic(s): Infant and Child Mortality , Maternal Health
Country(s): Multiple Regions
Web: https://journals.plos.org/plosmedicine/article?id=10.1371/jo
Association between intimate partner violence and male alcohol use and the receipt of perinatal care: Evidence from Nepal demographic and health survey 2011-2016
Author(s): Blessing Akombi-Inyang, Pramesh Raj Ghimire, Elizabeth Archibong, Emma Woolley, Husna Razee
Journal: PLOS ONE (DEC 2021) , Volume 16, issue 12; DOI:10.1371/journal.pone.0259980
Topic(s): Adult Health Issues , Domestic Violence , Gender , Infant and Child Mortality
Country(s): Nepal
Web: https://pubmed.ncbi.nlm.nih.gov/34874942/
Association between type of birth attendants and neonatal mortality: Evidence from a National survey
Author(s): Ololade Julius Baruwa, Acheampong Yaw Amoateng, Sibusiso Mkwananzi
Journal: African Health Sciences (DEC 2021) , Volume 21, issue 4; DOI:10.4314/ahs.v21i4.45
Topic(s): Infant and Child Mortality , Maternal Health
Country(s): Lesotho
Web: https://www.ajol.info/index.php/ahs/article/view/218991
Socio-ecological determinants of under-five mortality in Nigeria: exploring the roles of neighbourhood poverty and use of solid cooking fuel
Author(s): Chukwuechefulam Kingsley Imo, Nicole De Wet-Billings
Journal: Journal of Biosocial Science (NOV 2021) , DOI:10.1017/S0021932021000614
Topic(s): Child Health and Development , Infant and Child Mortality , Wealth/Socioeconomics
Country(s): Nigeria
Web: https://pubmed.ncbi.nlm.nih.gov/34743767/
DETERMINANTS OF NEONATAL MORTALITY BASED ON THE 2017 INDONESIAN DEMOGRAPHIC AND HEALTH SURVEY (IDHS)
Author(s): Fidya Rumiati, Asri C. Adisasmita
Journal: Indonesian Journal of Public Health (NOV 2021) , Volume 16, issue 3. DOI:https://doi.org/10.20473/ijph.v16i3.2021.363-374
Topic(s): Gender , Infant and Child Mortality
Country(s): Indonesia
Web: https://doaj.org/article/4198e71845be41119922d8c97172e506
Fine particulate matter constituents and infant mortality in Africa: A multicountry study
Author(s): Jovine Bachwenkizi, Cong Liu, Xia Meng, Lina Zhang, Weidong Wang, Aaron van Donkelaar, Randall V. Martin, Melanie S. Hammer, Renjie Chen, and Haidong Kan
Journal: Environment International (NOV 2021) , Volume 156; DOI: https://doi.org/10.1016/j.envint.2021.106739
Topic(s): Household and Respondent Characteristics , Infant and Child Mortality
Country(s): Multiple African Countries
Web: https://www.sciencedirect.com/science/article/pii/S016041202
Preterm birth and its associated factors among reproductive aged women in sub-Saharan Africa: evidence from the recent demographic and health surveys of sub-Sharan African countries
Author(s): Tesfa Sewunet Alamneh, Achamyeleh Birhanu Teshale, Misganaw Gebrie Worku, Zemenu Tadesse Tessema, Yigizie Yeshaw, Getayeneh Antehunegn Tesema, Alemneh Mekuriaw Liyew, and Adugnaw Zeleke Alem
Journal: BMC Pregnancy and Childbirth (NOV 2021) , Volume 21, issue 770; DOI:https://doi.org/10.1186/s12884-021-04233-2
Topic(s): Fertility and Fertility Preferences , Infant and Child Mortality , Maternal Health
Country(s): Multiple African Countries
Web: https://pubmed.ncbi.nlm.nih.gov/34781891/
Community-level impacts of sanitation coverage on maternal and neonatal health: a retrospective cohort of survey data
Author(s): Brittany L. Kmush, Bhavneet Walia, Anushruta Neupane, Carolina Frances, Idris Ahmed Mohamed, Mahwish Iqbal, and David A. Larsen
Journal: BMJ Global Health (OCT 2021) , Volume 6, Issue 10
Topic(s): Anemia , Child Health and Development , Fertility and Fertility Preferences , Household and Respondent Characteristics , Infant and Child Mortality , Malaria , Maternal Health , Nutrition
Country(s): Multiple Regions
Web: https://gh.bmj.com/content/6/10/e005674
Prevalence of undernutrition and potential risk factors among children below five years of age in Somali region, Ethiopia: evidence from 2016 Ethiopian demographic and health survey
Author(s): Damitie Kebede and Alebel Aynalem
Journal: BMC Nutrition (OCT 2021) , Volume 7, Article number: 56; DOI: https://doi.org/10.1186/s40795-021-00460-0
Topic(s): Anemia , Anthropometry/Biomarkers , Child Health and Development , Fertility and Fertility Preferences , Household and Respondent Characteristics , Infant and Child Mortality , Malaria , Nutrition
Country(s): Ethiopia
Web: https://link.springer.com/article/10.1186/s40795-021-00460-0
Consistency of the determinants of achieving fertility desires in Ghana: insights from 2003, 2008 and 2014 Ghana Demographic and Health Survey data sets
Author(s): Isaac Yeboah, Stephen Owusu Kwankye, Faustina Frempong-Ainguah
Journal: Genus (OCT 2021) , Volume 77, no. 1; DOI: https://doi.org/10.1186/s41118-021-00137-3
Topic(s): Child Health and Development , Fertility and Fertility Preferences , Gender , Infant and Child Mortality
Country(s): Ghana
Web: https://doaj.org/article/a6d5c14d5bf14f7d8edf91d013386ce0
Results (1 - 25) of 648 Page(s): 1 2 3 4 5 6 7 8 9 10 >>  Next


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


Execution Time

Total Time Avg Time Count Template
840 ms 34 ms 25 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element-core.cfm
840 ms 34 ms 25 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element.cfm
550 ms 550 ms 1 C:/inetpub/wwwroot/commonspot/master.cfm
550 ms 550 ms 1 C:/inetpub/wwwroot/dhs/Publications/Journal-Articles-Search.cfm
503 ms 503 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cached-page-render.cfm
487 ms 487 ms 1 C:/inetpub/wwwroot/commonspot/master-render.cfm
487 ms 487 ms 1 C:/inetpub/wwwroot/commonspot/render-page-meat.cfm
487 ms 487 ms 1 C:/inetpub/wwwroot/commonspot/render-page.cfm
487 ms 487 ms 1 C:/inetpub/wwwroot/commonspot/uncached-master.cfm
457 ms 46 ms 10 C:/inetpub/wwwroot/commonspot/utilities/ct-render-named-element.cfm
457 ms 457 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm
409 ms 409 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p29042-c1378-l70-t51-dAny.read
399 ms 399 ms 1 C:/inetpub/wwwroot/commonspot/utilities/run-element.cfm
258 ms 258 ms 1 C:/inetpub/wwwroot/commonspot/controls/customcf/cpe-customcf.cfm
228 ms 228 ms 1 C:/inetpub/wwwroot/dhs/publications/customcf/journal-articles-search-cs.cfm
32 ms 32 ms 1 C:/inetpub/wwwroot/commonspot/set-page-vars.cfm
32 ms 32 ms 1 C:/inetpub/wwwroot/dhs/publications/customcf/journal-articles-search-form.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/site-application.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/startup/core-application-meat.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/startup/site-application-meat.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/dhs/Publications/Application.cfm
15 ms 15 ms 1 C:/inetpub/wwwroot/commonspot/controls/upfront-generic.cfm
15 ms 15 ms 1 C:/inetpub/wwwroot/commonspot/render-head.cfm
15 ms 8 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/public_api/cache.cfc | getElementCacheSettings(29042, 51214) ] from C:/inetpub/wwwroot/commonspot/public_api/cache.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-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-c19155-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:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p29042-c19177-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 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/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/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(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
566 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 @ 09:33:27.027
    	SELECT lang_text_var, lang_text_en
        FROM dataset_lang_dictionary
    
SelectedCustomRenderElements (Datasource=commonspot-site-dhs, Time=16ms, Records=2059) in C:\inetpub\wwwroot\commonspot\set-page-vars.cfm @ 09:33:27.027
		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 @ 09:33:27.027
			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 @ 09:33:27.027
					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 @ 09:33:27.027
		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 @ 09:33:27.027
		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 @ 09:33:27.027
		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 @ 09:33:27.027
		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 @ 09:33:27.027
	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 @ 09:33:27.027
		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 @ 09:33:27.027
		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 @ 09:33:27.027
		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 @ 09:33:27.027
		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 @ 09:33:27.027
		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 @ 09:33:27.027
	SELECT pub_id FROM Dhs_article_pub
	WHERE ltrim(rtrim(pub_name)) = ''
qArticleTopic (Datasource=dhs_legacy_live, Time=16ms, Records=28) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-form.cfm @ 09:33:27.027
	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 @ 09:33:27.027
		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 @ 09:33:27.027
	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 @ 09:33:27.027
	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 @ 09:33:27.027
	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 @ 09:33:27.027
	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 @ 09:33:27.027
	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 @ 09:33:27.027
	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 @ 09:33:27.027
	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=16ms, Records=1120) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-form.cfm @ 09:33:27.027
	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=1) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-form.cfm @ 09:33:27.027
	SELECT pub_topic_name 
	FROM pub_topics
	WHERE pub_topic_id IN (11)
getArticles (Datasource=dhs_legacy_live, Time=15ms, Records=648) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 09:33:27.027
	SELECT distinct 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_topics_lnk l ON l.article_id=a.article_id
		INNER JOIN pub_topics t ON t.pub_topic_id=l.pub_topic_id
	
	
	WHERE a.article_id <> 0	
	  and active=1
	  and a.article_type_id=1	
	
	
	   AND  l.pub_topic_id IN (11)
	
		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	
	
qsubTopics (Datasource=dhs_legacy_live, Time=16ms, Records=4) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 09:33:27.027
		SELECT distinct l.topic_id, r.topic_name
		FROM pub_topics t
		inner join dhs_article_topics_lnk l on l.pub_topic_id = t.pub_topic_id 
		inner join dhs_articles a on a.article_id = l.article_id
		left outer join Dhs_article_topics r on r.topic_id = l.topic_id
		WHERE t.pub_topic_id IN (11)
		  and active = 1 
		  and article_type_id = 1
		  and t.active_flag = 1
		  and topic_name <> ''
		order by topic_name
		
distinct_cnt (Datasource=, Time=0ms, Records=648) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 09:33:27.027
	select distinct article_id from getArticles
	
getart_topic (Datasource=dhs_legacy_live, Time=0ms, Records=3) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 09:33:27.027
		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) = 5870

getart_Ctry (Datasource=dhs_legacy_live, Time=17ms, Records=1) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 09:33:27.027
		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) = 5870

getart_topic (Datasource=dhs_legacy_live, Time=2ms, Records=2) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 09:33:27.027
		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) = 5879

getart_Ctry (Datasource=dhs_legacy_live, Time=9ms, Records=1) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 09:33:27.027
		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) = 5879

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

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

getart_topic (Datasource=dhs_legacy_live, Time=10ms, Records=3) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 09:33:27.027
		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) = 5856

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

getart_topic (Datasource=dhs_legacy_live, Time=0ms, Records=4) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 09:33:27.027
		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) = 5774

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

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

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

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

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

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

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

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

getart_Ctry (Datasource=dhs_legacy_live, Time=16ms, Records=1) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 09:33:27.027
		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) = 5837

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

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

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

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

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

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

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

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

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

getart_Ctry (Datasource=dhs_legacy_live, Time=0ms, Records=2) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 09:33:27.027
		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) = 5667

getart_topic (Datasource=dhs_legacy_live, Time=0ms, Records=4) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 09:33:27.027
		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) = 5555

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

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

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

getart_topic (Datasource=dhs_legacy_live, Time=0ms, Records=4) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 09:33:27.027
		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) = 5508

getart_Ctry (Datasource=dhs_legacy_live, Time=16ms, Records=1) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 09:33:27.027
		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) = 5508

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

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

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

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

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

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

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

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

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

getart_Ctry (Datasource=dhs_legacy_live, Time=16ms, Records=1) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 09:33:27.027
		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) = 5468

getart_topic (Datasource=dhs_legacy_live, Time=0ms, Records=8) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 09:33:27.027
		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) = 5392

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

getart_topic (Datasource=dhs_legacy_live, Time=0ms, Records=8) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 09:33:27.027
		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) = 5398

getart_Ctry (Datasource=dhs_legacy_live, Time=15ms, Records=1) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 09:33:27.027
		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) = 5398

getart_topic (Datasource=dhs_legacy_live, Time=0ms, Records=4) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 09:33:27.027
		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) = 5442

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

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 09:33:27.027
		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 @ 09:33:27.027
		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 @ 09:33:27.027
		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 @ 09:33:27.027
		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 @ 09:33:27.027
		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?T_id=11&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=T_id=11&page=1
REMOTE_ADDR=10.0.0.84
REMOTE_HOST=10.0.0.84
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=6063F20E867D8E2121B82CF1584B1C28AE155940
Form Fields:
ALL=0
ALL_TOPIC=0
BACK=0
CTRY=
FORWARD=0
PUB=
R_ID=
SELECTED=0
SORT=2
TOPIC=11
TP=
T_id=11
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=2003574816
cs_runningdashboardcmdcode=0
csrftoken=6063F20E867D8E2121B82CF1584B1C28AE155940
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 09:33:26
getghost=
hivbold=1,3,8,9
imageupfront=
imgdir=/images/
includerootdir=/
initialsiteid=1
initticks=1728034406998
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,T_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 09:33:26.998
req_sequenceid=128632
req_startticks=1728034406998
rootdir=/
rootpath=
rooturldatasetadmin=https://preview.dhsprogram.com/data/dataset_admin
samesite_value=
scheduleupfront=
serverdatasource=commonspot-sites
sessionlockname=Session_1_95EBCFAF7046D5126654901F49085B76.cfusion
sessionstring=1_95EBCFAF7046D5126654901F49085B76.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 09:33:26'}
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=6063F20E867D8E2121B82CF1584B1C28AE155940
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=1728034407014
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
ownedobjecttypes=
pendingapprovalpages=
pendingapprovals=
previewmode=0
requestedversioncounter=
requestedversiontimestamp=
sessionid=95EBCFAF7046D5126654901F49085B76.cfusion
sessionstring=1_95EBCFAF7046D5126654901F49085B76.cfusion
urltoken=CFID=9309611&CFTOKEN=6c4938183b9b8648-64C47601-EC49-4AB9-1B1A714AF9327737&jsessionid=95EBCFAF7046D5126654901F49085B76.cfusion
usagelist=
user=Struct (30)
xmlbrowser=Struct (13)
xmlenvironment=Struct (5)
URL Parameters:
T_id=11
page=1
Debug Rendering Time: 47 ms