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 69 Page(s): 1 2 3 Next
Female genital mutilation and skilled birth attendance among women in sub-Saharan Africa
Author(s): Abdul-Aziz Seidu, Richard Gyan Aboagye, Barbara Sakyi, Collins Adu, Edward Kwabena Ameyaw, Joycelyn Boatemaa Affum and Bright Opoku Ahinkorah
Journal: BMC Women's Health (JAN 2022) , Volume 22, issue 26, DOI:https://doi.org/10.1186/s12905-021-01578-w
Topic(s): Female Genital Cutting , Maternal Health
Country(s): Multiple African Countries
Web: https://bmcwomenshealth.biomedcentral.com/articles/10.1186/s
Interrogating female genital mutilation and multiple sexual partnerships among young people in south-west Nigeria: Results from the 2018 Nigeria demographic and health survey
Author(s): Chukwuechefulam Kingsley Imo, Miracle-Eunice Bolorunduro, Chidi Slessor Mbah, Adediran Daniel Ikuomola
Journal: IFE PsychologIA (NOV 2021) , Volume 29, issue 2
Topic(s): Family Planning , Female Genital Cutting , HIV/AIDS , Maternal Health , Youth
Country(s): Nigeria
Web: https://www.ajol.info/index.php/ifep/article/view/217609
No relationship found between female genital cutting and intimate partner violence across six sub-Saharan African countries
Author(s): Janet A Howard, Mhairi A Gibson
Journal: Global Public Health (NOV 2021) , DOI:10.1080/17441692.2021.1991974
Topic(s): Domestic Violence , Female Genital Cutting , Gender
Country(s): Multiple African Countries, Gambia, Cote D'Ivoire, Kenya, Nigeria
Web: https://pubmed.ncbi.nlm.nih.gov/34743651/
Spatial distribution and associated factors of female genital cutting among reproductive-age women in Ethiopia: Further analysis of EDHS 2016
Author(s): Ayenew Engida Yismaw, Zemenu Tadesse, Dereje Nibret Gessesse, Abebe Ayinalem Tarekegn, and Yazachew Engida Yismaw
Journal: Clinical Epidemiology and Global Health (AUG 2021) , Volume 12; DOI:https://doi.org/10.1016/j.cegh.2021.100858
Topic(s): Female Genital Cutting , Geographic Information , Household and Respondent Characteristics
Country(s): Ethiopia
Web: https://cegh.net/article/S2213-3984(21)00166-4/fulltext
Empowerment and use of modern contraceptive methods among married women in Burkina Faso: a multilevel analysis
Author(s): Sylvain Y. M. Some, Christy Pu, and Song-Lih Huang
Journal: BMC Public Health (AUG 2021) , Vol. 21, no. 1; DOI: https://doi.org/10.1186/s12889-021-11541-x
Topic(s): Family Planning , Female Genital Cutting , Gender
Country(s): Burkina Faso
Web: https://doaj.org/article/1049063a9ad74e178a26c0570fb50dc8
Spatial distribution of traditional male circumcision and associated factors in Ethiopia; using multilevel generalized linear mixed effects model
Author(s): Biruk Shalmeno Tusa, Adisu Birhanu Weldesenbet, Telahun Kasa Tefera, and Sewnet Adem Kebede
Journal: BMC Public Health (JUL 2021) , Vol. 21, no. 1; DOI: https://doi.org/10.1186/s12889-021-11482-5
Topic(s): Female Genital Cutting , Gender , Geographic Information , HIV/AIDS , Household and Respondent Characteristics
Country(s): Ethiopia
Web: https://doaj.org/article/85a388b84c784dc793991f006125b710
Women’s empowerment and female genital mutilation intention for daughters in Sierra Leone: a multilevel analysis
Author(s): Edward Kwabena Ameyaw, Seun Anjorin, Bright Opoku Ahinkorah, Abdul-Aziz Seidu, Olalekan A. Uthman, Mpho Keetile, and Sanni Yaya
Journal: BMC Women's Health (MAY 2021) , Volume 21, Article number: 200; DOI: https://doi.org/10.1186/s12905-021-01340-2
Topic(s): Female Genital Cutting , Gender
Country(s): Sierra Leone
Web: https://bmcwomenshealth.biomedcentral.com/articles/10.1186/s
Cohort analysis of the state of female genital cutting in Nigeria: prevalence, daughter circumcision and attitude towards its discontinuation
Author(s): Babatunde M. Gbadebo, Adetokunbo T. Salawu, Rotimi F. Afolabi, Mobolaji M. Salawu, Adeniyi F. Fagbamigbe, and Ayo S. Adebowale
Journal: BMC Women's Health (APR 2021) , Volume 21; DOI: https://doi.org/10.1186/s12905-021-01324-2
Topic(s): Female Genital Cutting , Maternal Health
Country(s): Nigeria
Web: https://bmcwomenshealth.biomedcentral.com/articles/10.1186/s
Predictors of Female Genital Mutilation or Cutting Among Daughters of Women in Guinea, West Africa
Author(s): Bright Opoku Ahinkorah, Edward Kwabena Ameyaw, Abdul-Aziz Seidu, and Sanni Yaya
Journal: International Journal of Translational Medical Research and Public Health (MAR 2021) , DOI: https://doi.org/10.21106/ijtmrph.319
Topic(s): Education , Female Genital Cutting , Household and Respondent Characteristics , Wealth/Socioeconomics
Country(s): Guinea
Web: https://ijtmrph.org/index.php/IJTMRPH/article/view/319
Evaluating changes in the prevalence of female genital mutilation/cutting among 0-14 years old girls in Nigeria using data from multiple surveys: A novel Bayesian hierarchical spatio-temporal model
Author(s): Chibuzor Christopher Nnanatu, Glory Atilola, Paul Komba, Lubanzadio Mavatikua, Zhuzhi Moore, Dennis Matanda, Otibho Obianwu, and Ngianga-Bakwin Kandala
Journal: PLOS ONE (FEB 2021) , DOI: https://doi.org/10.1371/journal.pone.0246661
Topic(s): Female Genital Cutting , Geographic Information , Survey Methodology, Data Quality, Analysis
Country(s): Nigeria
Web: https://journals.plos.org/plosone/article?id=10.1371/journal
Physical Intimate Partner Violence Justification and Female Genital Mutilation in Kenya: Evidence from the Demographic and Health Survey
Author(s): Yujiro Sano, Irenius Konkor, Roger Antabe, and Rosalind Ragetlie
Journal: Journal of Aggression, Maltreatment & Trauma (JAN 2021) , DOI: https://doi.org/10.1080/10926771.2020.1854913
Topic(s): Domestic Violence , Female Genital Cutting , Gender
Country(s): Kenya
Web: https://www.tandfonline.com/doi/abs/10.1080/10926771.2020.18
The socioeconomic dynamics of trends in female genital mutilation/cutting across Africa
Author(s): Ewa Batyra, Ernestina Coast, Ben Wilson, and Valeria Cetorelli
Journal: BMJ Global Health (OCT 2020) , DOI: http://dx.doi.org/10.1136/bmjgh-2020-003088
Topic(s): Education , Female Genital Cutting , Household and Respondent Characteristics
Country(s): Multiple African Countries
Web: https://gh.bmj.com/content/5/10/e003088
Mapping male circumcision for HIV prevention efforts in sub-Saharan Africa
Author(s): M.A. Cork, K.F. Wilson, S. Perkins, M.L. Collison, A. Deshpande, J.W. Eaton, L. Earl, E. Haeuser, J.E. Justman, D.K. Kinyoki, B.K. Mayala, J.F. Mosser, C.J.L. Murray, J.N. Nkengasong, P. Piot, B. Sartorius, L.E. Schaeffer, A.L. Serfes, A. Sligar, K.M. Steuben, F.C. Tanser, J.D. VanderHeide, M. Yang, N. Wabiri, S.I. Hay, and L. Dwyer-Lindgren
Journal: BMC Medicine (JUL 2020) , 18:189; DOI: 10.1186/s12916-020-01635-5
Topic(s): Adult Health Issues , Female Genital Cutting , Gender , HIV/AIDS
Country(s): Multiple African Countries
Web: https://bmcmedicine.biomedcentral.com/track/pdf/10.1186/s129
The medicalisation of female genital cutting: harm reduction or social norm?
Author(s): Nina Van Eekert, Veerle Buffel, Sara De Bruyn, and Sarah Van de Velde
Journal: Sociology of Health & Illness (JUL 2020) , Published online; DOI: 10.1111/1467-9566.13153
Topic(s): Female Genital Cutting
Country(s): Egypt
Community gender systems and a daughter’s risk of female genital mutilation/cutting: Multilevel findings from Egypt
Author(s): Kathryn M. Yount, Yuk Fai Cheong, Rose Grace Grose, and Sarah R. Hayford
Journal: PLOS ONE (MAR 2020) , 15(3): e0229917; DOI: 10.1371/journal.pone.0229917
Topic(s): Female Genital Cutting , Gender
Country(s): Egypt
Web: https://journals.plos.org/plosone/article?id=10.1371/journal
Female Genital Mutilation/Cutting in Mali and Mauritania: Understanding Trends and Evaluating Policies
Author(s): Valeria Cetorelli, Ben Wilson, Ewa Batyra, and Ernestina Coast
Journal: Studies in Family Planning (MAR 2020) , DOI: 10.1111/sifp.12112
Topic(s): Female Genital Cutting
Country(s): Mali, Mauritania
Web: https://pubmed.ncbi.nlm.nih.gov/32180237/
Female Genital Mutilation in Benin: Prevalence and Associated Factors Based on Data from the Demographic and Health Survey, 2011-2012
Author(s): Alphonse Kpozehouen, Yolaine Glele Ahanhanzo, Elvyre Klikpo, Colette Azandjame, Alphonse Chabi, Charles Sossa Jerome, Moussiliou Noel Paraiso, and Edgard-Marius Ouendo
Journal: World Journal of Public Health (OCT 2019) , 4(4): 74-80; DOI: 10.11648/j.wjph.20190404.11
Topic(s): Female Genital Cutting
Country(s): Benin
Web: http://article.sciencepublishinggroup.com/pdf/10.11648.j.wjp
Is there a relationship between female genital mutilation/cutting and fistula? A statistical analysis using cross-sectional data from Demographic and Health Surveys in 10 sub-Saharan Africa countries
Author(s): Dennis Juma Matanda, Pooja Sripad, and Charity Ndwiga
Journal: BMJ Open (JUL 2019) , 9: e025355; DOI: 10.1136/bmjopen-2018-025355
Topic(s): Female Genital Cutting , Maternal Health
Country(s): Multiple African Countries
Web: https://bmjopen.bmj.com/content/9/7/e025355
HIV prevalence correlated with circumcision prevalence and high-risk sexual behavior in India's states: an ecological study
Author(s): Chris R. Kenyon
Journal: F1000 Research (JUN 2019) , 8: 60; DOI: 10.12688/f1000research.17807.2
Topic(s): Family Planning , Female Genital Cutting , Gender , HIV/AIDS , Maternal Health
Country(s): India
Web: https://f1000research.com/articles/8-60/v2
Traditional Male Circumcision is Associated with Sexual Risk Behaviors in Sub-Saharan Countries Prioritized for Male Circumcision
Author(s): Chyun Shi, Michael Li, and Jonathan Dushoff
Journal: AIDS and Behavior (APR 2019) , Online First: 1-9; DOI: 10.1007/s10461-019-02473-0
Topic(s): Adult Health Issues , Family Planning , Female Genital Cutting , Gender , HIV/AIDS , Maternal Health
Country(s): Multiple African Countries
Secular Trends in the Prevalence of Female Genital Mutilation/Cutting among Girls: A Systematic Analysis
Author(s): Ngianga-Bakwin Kandala, Martinsixtus C Ezejimofor, Olalekan A Uthman, and Paul Komba
Journal: BMJ Global Health (NOV 2018) , 3(5): e000549; DOI:10.1136/bmjgh-2017-000549
Topic(s): Female Genital Cutting
Country(s): Multiple African Countries, Multiple Asian Countries, Multiple Regions
Web: https://www.ncbi.nlm.nih.gov/pmc/articles/PMC6231106/
Studying Social Processes Underlying the Persistence of Female Genital Mutilation Using Agent-Based Modeling
Author(s): Laurence Thomas Droy
Journal: SAGE Research Methods Cases (APR 2018) , Online; DOI: 10.4135/9781526446176
Topic(s): Female Genital Cutting
Country(s): Senegal
Schistosomiasis and Infertility in East Africa
Author(s): Woodall PA, and Kramer MR
Journal: American Journal of Tropical Medicine and Hygiene (APR 2018) , 98(4):1137-1144; DOI: 10.4269/ajtmh.17-0280
Topic(s): Female Genital Cutting , Fertility and Fertility Preferences , Geographic Information , Maternal Health
Country(s): Multiple African Countries, Ethiopia, Kenya, Tanzania, Uganda
Web: http://www.ajtmh.org/docserver/fulltext/14761645/98/4/tpmd17
Impact of age on harm risks of Female Genital Mutilation: Analysis of Demographic and Health Surveys
Author(s): John Simister
Journal: MOJ Women's Health (FEB 2018) , 7(1): 00163; DOI:10.15406/mojwh.2018.07.00163
Topic(s): Female Genital Cutting
Country(s): Multiple African Countries
Web: http://medcraveonline.com/MOJWH/MOJWH-07-00163.pdf
Religious Perceptions and Attitudes of Men towards Discontinuation of Female Genital Cutting in Nigeria: Evidence from the 2013 Nigeria Demographic and Health Survey
Author(s): Ayotunde Titilayo, Martin E. Palamuleni, John O. Olaoye-Oyesola, and Olumide M. Owoeye
Journal: African Journal of Reproductive Health (JAN 2018) , 22(1): 20-28; DOI: 10.29063/ajrh2018/v22i1.2
Topic(s): Female Genital Cutting , Household and Respondent Characteristics , Maternal Health
Country(s): Nigeria
Web: https://www.ajrh.info/index.php/ajrh/article/download/1352/p
Results (1 - 25) of 69 Page(s): 1 2 3 Next


Debugging Information
ColdFusion Server Developer 2018,0,19,330149
Template /publications/Journal-Articles-Search.cfm
Time Stamp 24-Jul-24 09:01 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 10.0.0.214
Host Name 10.0.0.214


Execution Time

Total Time Avg Time Count Template
1001 ms 40 ms 25 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element-core.cfm
1001 ms 40 ms 25 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element.cfm
656 ms 656 ms 1 C:/inetpub/wwwroot/commonspot/master.cfm
656 ms 656 ms 1 C:/inetpub/wwwroot/dhs/Publications/Journal-Articles-Search.cfm
562 ms 562 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cached-page-render.cfm
547 ms 547 ms 1 C:/inetpub/wwwroot/commonspot/master-render.cfm
547 ms 547 ms 1 C:/inetpub/wwwroot/commonspot/render-page-meat.cfm
547 ms 547 ms 1 C:/inetpub/wwwroot/commonspot/render-page.cfm
547 ms 547 ms 1 C:/inetpub/wwwroot/commonspot/uncached-master.cfm
516 ms 516 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm
500 ms 50 ms 10 C:/inetpub/wwwroot/commonspot/utilities/ct-render-named-element.cfm
469 ms 469 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p29042-c1378-l70-t51-dAny.read
453 ms 453 ms 1 C:/inetpub/wwwroot/commonspot/utilities/run-element.cfm
312 ms 312 ms 1 C:/inetpub/wwwroot/commonspot/controls/customcf/cpe-customcf.cfm
265 ms 265 ms 1 C:/inetpub/wwwroot/dhs/publications/customcf/journal-articles-search-cs.cfm
78 ms 78 ms 1 C:/inetpub/wwwroot/commonspot/set-page-vars.cfm
47 ms 47 ms 1 C:/inetpub/wwwroot/dhs/publications/customcf/journal-articles-search-form.cfm
32 ms 16 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/public_api/cache.cfc | getElementCacheSettings(29042, 51214) ] from C:/inetpub/wwwroot/commonspot/public_api/cache.cfc
16 ms 16 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p29042-c19154-l70-t51-dAny.read
16 ms 16 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p29042-c19174-l70-t51-dAny.read
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/site-application.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/startup/site-application-meat.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/utilities/nocache-headers.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/utilities/verify-stub-data.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/dhs/Publications/Application.cfm
15 ms 15 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p29042-c19152-l70-t51-dAny.read
15 ms 15 ms 1 C:/inetpub/wwwroot/commonspot/render-head.cfm
15 ms 15 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 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-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-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/controls/upfront-generic.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/lview-contribute-mode-redirect-check.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/non-dashboard-include.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/pagemode/pagemodeui.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-body-tag.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-foot.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-metatags.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-tracking-code.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/security/security-page.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/browser-detect-methods.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/build-request-params.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/core-application-meat.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/handle-head-request.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/handle-request-timeout.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/init-customer-scope.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/init-server-scope.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/session-first-global.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/session-first-site.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/add-resource-request.cfm
0 ms 0 ms 6 C:/inetpub/wwwroot/commonspot/utilities/add-unregistered-resource-request.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/append-to-resource-group.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/build-user-struct.cfm
0 ms 0 ms 3 C:/inetpub/wwwroot/commonspot/utilities/cp-cfheader.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cp-cfmail-request-queue.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/utilities/define-upfront-vars.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/flush-cache-db-queue.cfm
0 ms 0 ms 4 C:/inetpub/wwwroot/commonspot/utilities/handle-in-list.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/load-template-properties.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/newwindow-js-meat.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/utilities/newwindow-js.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/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/udf/database.cfc | getUDF(commonspot-site-dhs) ] from C:/inetpub/wwwroot/commonspot/udf/database.cfc
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
672 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:01:37.037
    	SELECT lang_text_var, lang_text_en
        FROM dataset_lang_dictionary
    
SelectedCustomRenderElements (Datasource=commonspot-site-dhs, Time=46ms, Records=2059) in C:\inetpub\wwwroot\commonspot\set-page-vars.cfm @ 09:01:37.037
		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:01:37.037
			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:01:37.037
					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:01:37.037
		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=15ms, Records=0) in C:\inetpub\wwwroot\commonspot\commands\livebookmarks.cfc @ 09:01:37.037
		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:01:37.037
		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:01:37.037
		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:01:37.037
	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:01:37.037
		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:01:37.037
		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:01:37.037
		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:01:37.037
		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:01:37.037
		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:01:37.037
	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 @ 09:01:37.037
	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:01:37.037
		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:01:37.037
	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:01:37.037
	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:01:37.037
	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:01:37.037
	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:01:37.037
	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=18ms, Records=2) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-form.cfm @ 09:01:37.037
	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:01:37.037
	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=14ms, Records=1120) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-form.cfm @ 09:01:37.037
	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:01:37.037
	SELECT pub_topic_name 
	FROM pub_topics
	WHERE pub_topic_id IN (6)
getArticles (Datasource=dhs_legacy_live, Time=15ms, Records=69) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 09:01:37.037
	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 (6)
	
		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=0ms, Records=2) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 09:01:37.037
		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 (6)
		  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=69) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 09:01:37.037
	select distinct article_id from getArticles
	
getart_topic (Datasource=dhs_legacy_live, Time=0ms, Records=2) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 09:01:37.037
		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) = 5664

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 09:01:37.037
		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=16ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\cache.cfc @ 09:01:37.037
		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:01:37.037
		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:01:37.037
		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:01:37.037
		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 (88)
adfscheduler=Struct (0)
applicationname=site1
blogcache=Struct (4)
cachedimages=Struct (5)
cacheinfocache=Struct (53)
confidentiality=Array (5)
controlinstance_toplevel_cache=Struct (126)
covid_articlecount=0
covid_newsarticlecount=49
covid_pressreleasecount=0
covid_pubcount=0
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 (2)
pendingstubrequests=Struct (0)
rsscache=Struct (2)
search_archive_next_clean=2024-07-25 06:27:33
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=6&tnm=Female%20Genital%20Cutting&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=6&tnm=Female%20Genital%20Cutting&page=1
REMOTE_ADDR=10.0.0.214
REMOTE_HOST=10.0.0.214
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=97AC432FDE7FE22E24EF2B44A1E0BAA7057CF67C
Form Fields:
ALL=0
ALL_TOPIC=0
BACK=0
CTRY=
FORWARD=0
PUB=
R_ID=
SELECTED=0
SORT=2
TOPIC=6
TP=
T_id=6
YEAR1=
YEAR2=
page=1
tnm=Female Genital Cutting
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=3189773312
cs_runningdashboardcmdcode=0
csrftoken=97AC432FDE7FE22E24EF2B44A1E0BAA7057CF67C
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-07-24 09:01:37
getghost=
hivbold=1,3,8,9
imageupfront=
imgdir=/images/
includerootdir=/
initialsiteid=1
initticks=1721811697134
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 (7)
params_formfields=
params_urlfields=T_id,tnm,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-07-24 09:01:37.134
req_sequenceid=3481
req_startticks=1721811697134
rootdir=/
rootpath=
rooturldatasetadmin=https://preview.dhsprogram.com/data/dataset_admin
samesite_value=
scheduleupfront=
serverdatasource=commonspot-sites
sessionlockname=Session_1_E6434371BFE6530348D5D9C37D6195B6.cfusion
sessionstring=1_E6434371BFE6530348D5D9C37D6195B6.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-07-24 09:01:37'}
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)
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)
Session Variables:
_csrf_token=97AC432FDE7FE22E24EF2B44A1E0BAA7057CF67C
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=1721811697134
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
ownedobjecttypes=
pendingapprovalpages=
pendingapprovals=
previewmode=0
requestedversioncounter=
requestedversiontimestamp=
sessionid=E6434371BFE6530348D5D9C37D6195B6.cfusion
sessionstring=1_E6434371BFE6530348D5D9C37D6195B6.cfusion
urltoken=CFID=3707597&CFTOKEN=80078f5b8bdb6fc-E7BEEB7F-E962-D547-18ADF343C97F239B&jsessionid=E6434371BFE6530348D5D9C37D6195B6.cfusion
usagelist=
user=Struct (30)
xmlbrowser=Struct (13)
xmlenvironment=Struct (5)
URL Parameters:
T_id=6
page=1
tnm=Female Genital Cutting
Debug Rendering Time: 31 ms