Journal Articles Search

Search Title, Abstract or Author:
Topics:
Adult Health Issues
Anemia
Anthropometry/Biomarkers
Child Health and Development
Climate and environment
COVID-19
Decolonization
Domestic Violence
Education
Family Planning
Female Genital Cutting
Fertility and Fertility Preferences
Gender
Geographic Information
Health facilities/SPA surveys
HIV/AIDS
Household and Respondent Characteristics
Infant and Child Mortality
Malaria
Maternal Health
Maternal Mortality
Mental Health
Non-communicable diseases
Nutrition
Other
Survey Methodology, Data Quality, Analysis
Wealth/Socioeconomics
Youth
Country:
Published from:
Journal: enter word(s) to find journals
 Sort By:
Results (1 - 24) of 24 Page(s): 1
Son preference, gender asymmetries and parity progressions: the case of Kyrgyzstan
Author(s): Konstantin Kazenin
Journal: Asian Population Studies (OCT 2021) , DOI:https://doi.org/10.1080/17441730.2021.1992858
Topic(s): Fertility and Fertility Preferences , Gender
Country(s): Kyrgyz Republic
Web: https://www.tandfonline.com/doi/abs/10.1080/17441730.2021.19
The association between maternal employment and child survival in India, 1998–99 and 2005–06
Author(s): Saabneh, A.
Journal: Asian Population Studies (OCT 2016) , Published online: 21 Oct 2016, Pages 1-19; DOI: 10.1080/17441730.2016.1239412
Topic(s): Child Health and Development , Fertility and Fertility Preferences , Gender , Infant and Child Mortality , Nutrition
Country(s): India
Influence of Son Preference on Contraceptive Method Mix: Some Evidences from ‘Two Bengals’
Author(s): Saswata Ghosh, and Sharifa Begum
Journal: Asian Population Studies (NOV 2015) , 11(3):1-16; DOI: 10.1080/17441730.2015.1093749
Topic(s): Family Planning , Fertility and Fertility Preferences
Country(s): Bangladesh
Web: https://www.researchgate.net/publication/283761035_Influence
Women's autonomy, education and birth intervals in India: Visiting the less familiar
Author(s): Santosh Jatrana, and Samba Siva Rao Pasupuleti
Journal: Asian Population Studies (JUN 2015) , 11(2):172-190, DOI: 10.1080/17441730.2015.1050083
Topic(s): Education , Family Planning , Fertility and Fertility Preferences , Gender , Maternal Health
Country(s): India
Application of Health Expectancy Research on Working Male Population in Bangladesh
Author(s): Ismail Tareque, Yasuhiko Saito, and Kazuo Kawahara
Journal: Asian Population Studies (FEB 2015) , 11(1): 32-43; DOI:10.1080/17441730.2015.1007558
Topic(s): Adult Health Issues
Country(s): Bangladesh
Early marriage in Bangladesh: Not as early as it appears
Author(s): Peter Kim Streatfield, Nahid Kamal, Karar Zunaid Ahsan, and Quamrun Nahar
Journal: Asian Population Studies (FEB 2015) , 11(1):94-110, DOI: 10.1080/17441730.2015.1012785
Topic(s): Education , Fertility and Fertility Preferences , Gender
Country(s): Bangladesh
The Intersection of Gender, Caste and Class Inequalities in Child Nutrition in Rural India
Author(s): Simantini Mukhopadhyay
Journal: Asian Population Studies (JAN 2015) , 11(1): 17-31; DOI: https://doi.org/10.1080/17441730.2015.995150
Topic(s): Child Health and Development , Gender , Nutrition , Wealth/Socioeconomics
Country(s): India
Web: https://www.researchgate.net/profile/Simantini_Mukhopadhyay/
Decomposing the Rural-Urban Differentials in Childhood Malnutrition in India, 1992–2006
Author(s): Abhishek Kumar, and Divya Kumari
Journal: Asian Population Studies (APR 2014) , 10(2):144-162, DOI: 10.1080/17441730.2014.902161
Topic(s): Child Health and Development , Household and Respondent Characteristics , Nutrition , Wealth/Socioeconomics
Country(s): India
Economic Development, Women's Social and Economic Empowerment and Reproductive Health in Rural India
Author(s): Shobha Rao, Carol Vlassoff, and Jayshree Sarode
Journal: Asian Population Studies (OCT 2013) , 10(1):4-22, DOI:10.1080/17441730.2013.840083
Topic(s): Gender , Maternal Health , Wealth/Socioeconomics
Country(s): India
Pathways to Low Fertility in India: Comparison across states and a detailed look at Kerala
Author(s): Trina Vithayathil
Journal: Asian Population Studies (SEP 2013) , 9(3):301-321, DOI: 10.1080/17441730.2013.824184
Topic(s): Fertility and Fertility Preferences
Country(s): India
‘Ultramodern Contraception’ Re-Examined: Cultural dissent or son preference?
Author(s): Zakir Husain, Saswata Ghosh, and Mousumi Dutta
Journal: Asian Population Studies (JUL 2013) , 9(3):280-300, DOI: 10.1080/17441730.2013.816480
Topic(s): Family Planning , Fertility and Fertility Preferences
Country(s): India
Fertility changes in Central Asia since 1980
Author(s): Spoorenberg, Thomas
Journal: Asian Population Studies (JAN 2013) , 9(1): 50-77. doi:10.1080/17441730.2012.752238
Topic(s): Fertility and Fertility Preferences
Country(s): Uzbekistan, Kazakhstan, Kyrgyz Republic, Multiple Asian Countries
Daughter Discrimination and Future Sex Ratio at Birth in India
Author(s): Tarun K. Roy, and Aparajita Chattopadhyay
Journal: Asian Population Studies (AUG 2012) , 8(3):281-299, DOI: 10.1080/17441730.2012.714669
Topic(s): Family Planning , Fertility and Fertility Preferences
Country(s): India
EFFECT OF LIVING ARRANGEMENT ON THE HEALTH STATUS OF ELDERLY IN INDIA: findings from a national cross sectional survey
Author(s): Sutapa Agrawal
Journal: Asian Population Studies (FEB 2012) , Volume 8, Issue 1, pages 87-101, DOI:10.1080/17441730.2012.646842
Topic(s): Adult Health Issues
Country(s): India
Web: http://www.tandfonline.com/doi/pdf/10.1080/17441730.2012.646
Determinants of inequality in child malnutrition in India: the poverty-undernutrition linkage.
Author(s): Mazumdar, Sumit
Journal: Asian Population Studies (NOV 2010) , Nov2010, Vol. 6 Issue 3, p307-333, 27p; DOI: 10.1080/17441730.2010.512763
Topic(s): Child Health and Development , Nutrition , Wealth/Socioeconomics
Country(s): India
DOES THE SAFE-MOTHERHOOD PROGRAMME REACH THE POOR IN UTTAR PRADESH, INDIA?
Author(s): Praveen K. Pathak, and Sanjay K. Mohanty
Journal: Asian Population Studies (JUL 2010) , 6(2):173-191, DOI: 10.1080/17441730.2010.494444
Topic(s): Maternal Health , Wealth/Socioeconomics
Country(s): India
DETERMINANTS OF ADULT MORTALITY IN INDIA
Author(s): Saikia, Nandita; Ram, F.
Journal: Asian Population Studies (JUL 2010) , Jul2010, Vol. 6 Issue 2, p153-171, 19p, DOI: 10.1080/17441730.2010.494441
Topic(s): Adult Health Issues
Country(s): India
Factors Affecting Utilization of Skilled Maternity Care Services among Married Adolescents in Bangladesh
Author(s): S. M. Mostafa Kamal
Journal: Asian Population Studies (JUL 2009) , 5(2): 153-170; DIO: 10.1080/17441730902992075
Topic(s): Maternal Health , Youth
Country(s): Bangladesh
WOMEN'S REPRODUCTIVE MORBIDITY AND TREATMENT-SEEKING BEHAVIOUR IN INDIA.
Author(s): S. C. Gulati, Alok R. Chaurasia & Raghubansh M. Singh
Journal: Asian Population Studies (MAR 2009) , Mar2009, Vol. 5 Issue 1, p61-84, 24p, , DOI:10.1080/17441730902790131
Topic(s): Maternal Health , Maternal Mortality
Country(s): India
Village size in India: How relevant is it in the context of development?
Author(s): Abhishek Singh; Sandip Chakraborty; Tarun K. Roy
Journal: Asian Population Studies (JUL 2008) , Volume 4, Issue 2 July 2008 , pages 111 - 134
Topic(s): Child Health and Development , Maternal Health , Other , Wealth/Socioeconomics
Country(s): India
Nuptiality in Soviet and post-Soviet Central Asia
Author(s): Premchand Dommaraju, and Victor Agadjanian
Journal: Asian Population Studies (JUL 2008) , 4(2):195-213, DOI: 10.1080/17441730802247463
Topic(s): Fertility and Fertility Preferences , Gender
Country(s): Uzbekistan, Multiple Asian Countries, Kazakhstan, Kyrgyz Republic
Rich-Poor Gap in Maternal Care
Author(s): Laishram Ladusingh; Chungkham Holendro Singh
Journal: Asian Population Studies (MAR 2007) , Volume 3, Issue 1 March 2007 , pages 79 - 94
Topic(s): Maternal Health , Wealth/Socioeconomics
Country(s): India
Toward smaller family size in Yemen: a demographic analysis.
Author(s): Vijayan K. Pillai; T. S. Sunil
Journal: Asian Population Studies (NOV 2006) , Volume 2, Issue 3 November 2006 , pages 257 - 269
Topic(s): Family Planning , Fertility and Fertility Preferences
Country(s): Yemen
Ultramodern contraception--Social class and family planning in India
Author(s): Basu, A.M.
Journal: Asian Population Studies (SEP 2005) , Vol 1, Num 3, Page: 303-323
Topic(s): Family Planning
Country(s): India
Results (1 - 24) of 24 Page(s): 1


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


Execution Time

Total Time Avg Time Count Template
1426 ms 57 ms 25 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element-core.cfm
1426 ms 57 ms 25 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element.cfm
855 ms 855 ms 1 C:/inetpub/wwwroot/commonspot/master.cfm
855 ms 855 ms 1 C:/inetpub/wwwroot/dhs/Publications/Journal-Articles-Search.cfm
776 ms 776 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cached-page-render.cfm
760 ms 760 ms 1 C:/inetpub/wwwroot/commonspot/uncached-master.cfm
743 ms 743 ms 1 C:/inetpub/wwwroot/commonspot/master-render.cfm
743 ms 743 ms 1 C:/inetpub/wwwroot/commonspot/render-page-meat.cfm
743 ms 743 ms 1 C:/inetpub/wwwroot/commonspot/render-page.cfm
713 ms 71 ms 10 C:/inetpub/wwwroot/commonspot/utilities/ct-render-named-element.cfm
713 ms 713 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm
683 ms 683 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p29042-c1378-l70-t51-dAny.read
668 ms 668 ms 1 C:/inetpub/wwwroot/commonspot/utilities/run-element.cfm
450 ms 450 ms 1 C:/inetpub/wwwroot/commonspot/controls/customcf/cpe-customcf.cfm
402 ms 402 ms 1 C:/inetpub/wwwroot/dhs/publications/customcf/journal-articles-search-cs.cfm
63 ms 63 ms 1 C:/inetpub/wwwroot/dhs/publications/customcf/journal-articles-search-form.cfm
48 ms 24 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/public_api/cache.cfc | getElementCacheSettings(29042, 51214) ] from C:/inetpub/wwwroot/commonspot/public_api/cache.cfc
47 ms 47 ms 1 C:/inetpub/wwwroot/commonspot/set-page-vars.cfm
42 ms 42 ms 1 C:/inetpub/wwwroot/commonspot/site-application.cfm
42 ms 42 ms 1 C:/inetpub/wwwroot/commonspot/startup/site-application-meat.cfm
42 ms 42 ms 1 C:/inetpub/wwwroot/dhs/Publications/Application.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/non-dashboard-include.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/startup/core-application-meat.cfm
16 ms 16 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | UpdateStatus(argumentCollection = [complex value]) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
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:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p29042-c19155-l70-t51-dAny.read
15 ms 15 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p29042-c19177-l70-t51-dAny.read
15 ms 15 ms 1 C:/inetpub/wwwroot/commonspot/controls/control-setup.cfm
15 ms 15 ms 1 C:/inetpub/wwwroot/commonspot/startup/session-first-site.cfm
14 ms 14 ms 1 C:/inetpub/wwwroot/commonspot/render-head.cfm
14 ms 14 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-c19154-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p29042-c19169-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p29042-c19172-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p29042-c19174-l70-t51-dAny.read
0 ms 0 ms 1 C:/inetpub/wwwroot/ADF/core/load_site_adf.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/controls/ct-include-once.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/controls/handle-styles.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/controls/upfront-generic.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/lview-contribute-mode-redirect-check.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/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/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/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
897 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:22:35.035
    	SELECT lang_text_var, lang_text_en
        FROM dataset_lang_dictionary
    
SelectedCustomRenderElements (Datasource=commonspot-site-dhs, Time=47ms, Records=2059) in C:\inetpub\wwwroot\commonspot\set-page-vars.cfm @ 09:22:35.035
		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:22:35.035
			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:22:35.035
					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:22:35.035
		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:22:35.035
		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:22:35.035
		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:22:35.035
		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:22:35.035
	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:22:35.035
		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:22:35.035
		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:22:35.035
		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:22:35.035
		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:22:35.035
		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

qArticlePubName (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 09:22:35.035
		SELECT pub_name FROM Dhs_article_pub
		WHERE pub_id = 	? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 15

qArticlePubID (Datasource=dhs_legacy_live, Time=16ms, Records=1) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-form.cfm @ 09:22:35.035
	SELECT pub_id FROM Dhs_article_pub
	WHERE ltrim(rtrim(pub_name)) = 'Asian Population Studies'
qArticleTopic (Datasource=dhs_legacy_live, Time=0ms, Records=28) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-form.cfm @ 09:22:35.035
	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:22:35.035
		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:22:35.035
	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:22:35.035
	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:22:35.035
	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:22:35.035
	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:22:35.035
	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:22:35.035
	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:22:35.035
	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=31ms, Records=1120) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-form.cfm @ 09:22:35.035
	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=16ms, Records=0) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-form.cfm @ 09:22:35.035
	SELECT pub_topic_name 
	FROM pub_topics
	WHERE pub_topic_id IN (0)
getArticles (Datasource=dhs_legacy_live, Time=18ms, Records=24) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 09:22:35.035
	SELECT  a.article_id, a.pub_id, title, authors, pub_name, article_date, article_year, vol, link, 
	   case when article_date = 'January' then 1
			when article_date = 'February' then 2
			when article_date = 'March' then 3
			when article_date = 'April' then 4
			when article_date = 'May' then 5
			when article_date = 'June' then 6
			when article_date = 'July' then 7
			when article_date = 'August' then 8
			when article_date = 'September' then 9
			when article_date = 'October' then 10
			when article_date = 'November' then 11
			when article_date = 'December' then 12
			end
	FROM dhs_articles a   
	INNER JOIN  Dhs_article_pub p ON a.pub_id = p.pub_id
	INNER JOIN  Dhs_article_type Tp ON a.article_type_id = Tp.Article_type_Id
	
	
	
	WHERE a.article_id <> 0	
	  and active=1
	  and a.article_type_id=1	
	
	
		AND a.pub_Id = 15 
		Order By article_year desc, 
		           case when article_date = 'January' then 1
						when article_date = 'February' then 2
						when article_date = 'March' then 3
						when article_date = 'April' then 4
						when article_date = 'May' then 5
						when article_date = 'June' then 6
						when article_date = 'July' then 7
						when article_date = 'August' then 8
						when article_date = 'September' then 9
						when article_date = 'October' then 10
						when article_date = 'November' then 11
						when article_date = 'December' then 12
					end desc, authors	
	
distinct_cnt (Datasource=, Time=0ms, Records=24) in C:\inetpub\wwwroot\dhs\publications\customcf\journal-articles-search-cs.cfm @ 09:22:35.035
	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:22:35.035
		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) = 5430

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 09:22:35.035
		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:22:35.035
		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:22:35.035
		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:22:35.035
		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:22:35.035
		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?p_id=15&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=p_id=15&page=1
REMOTE_ADDR=10.0.2.225
REMOTE_HOST=10.0.2.225
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/publications/Journal-Articles-Search.cfm
SERVER_NAME=preview.dhsprogram.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Cookie Variables:
CSRFTOKEN=4DCDA2785FC8FFA4A268C9B8712BD655AB98993F
Form Fields:
ALL=0
ALL_TOPIC=0
BACK=0
CTRY=
FORWARD=0
PUB=15
R_ID=
SELECTED=0
SORT=2
TOPIC=
TP=
YEAR1=
YEAR2=
p_id=15
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=2601950856
cs_runningdashboardcmdcode=0
csrftoken=4DCDA2785FC8FFA4A268C9B8712BD655AB98993F
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:22:35
getghost=
hivbold=1,3,8,9
imageupfront=
imgdir=/images/
includerootdir=/
initialsiteid=1
initticks=1728033755169
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=p_id,page
previewmode=0
readmodewhereclause=(VersionState = 2)
renderedelements=Struct (0)
renderelementdata=Struct (0)
renderfordiff=0
renderforprint=0
renderstate=Struct (73)
req_cam_callcount=1
req_inittimestamp=2024-10-04 09:22:35.153
req_sequenceid=128539
req_startticks=1728033755153
rootdir=/
rootpath=
rooturldatasetadmin=https://preview.dhsprogram.com/data/dataset_admin
samesite_value=
scheduleupfront=
serverdatasource=commonspot-sites
sessionlockname=Session_1_39E692C7B6E1190067A28E697612990A.cfusion
sessionstring=1_39E692C7B6E1190067A28E697612990A.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:22:35'}
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=4DCDA2785FC8FFA4A268C9B8712BD655AB98993F
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=1728033755169
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
ownedobjecttypes=
pendingapprovalpages=
pendingapprovals=
previewmode=0
requestedversioncounter=
requestedversiontimestamp=
sessionid=39E692C7B6E1190067A28E697612990A.cfusion
sessionstring=1_39E692C7B6E1190067A28E697612990A.cfusion
urltoken=CFID=9309120&CFTOKEN=c459b7e22e2c676a-6460FFAC-9FEB-B291-CB1E8C9F7654D3B6&jsessionid=39E692C7B6E1190067A28E697612990A.cfusion
usagelist=
user=Struct (30)
xmlbrowser=Struct (13)
xmlenvironment=Struct (5)
URL Parameters:
p_id=15
page=1
Debug Rendering Time: 47 ms