A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [CLOSE]

Physical Activity in the Child Care Setting

 
This page has been automatically translated from English. MSDH has not reviewed this translation and is not responsible for any inaccuracies.
M

SDH's Physical Activity in the Child Care Setting (PACCS) initiative is working to reduce the high prevalence of obesity among 2- to 5-year-olds by developing guidances and standards for child care facilities to improve their physical activity and nutrition environments.

Childhood Obesity and Child Care

In 2007–2008, 10% of children nationwide ages 2 to 5 years were obese; in Mississippi, about 20% of children ages 3 to 5 are overweight. Increasingly, children in this age range are spending their days in child care settings, and receive the majority of their meals and exercise there. Improving the physical activity opportunities offered by child care providers is one approach to preventing childhood obesity.

About the Initiative

Mississippi already has nationally-recognized standards for child care regarding nutrition, outdoor exposure, and limits on screen time. PACCS is working to further these standards via:

  • State policy: PACCS is developing a statewide policy requiring daily, structured physical activity in child care and after-school facilities.
  • Action guide: PACCS is working with the CDC to develop an Action Guide for child care facilities that will help them work toward improved environments for physical activity, and provide guidance and model programs for change at the regulation, administrative and policy levels.
  • Direct assistance: PACCS is a partner in Allies for Quality Care program which works directly with selected child care centers to improve their learning environment and nutritional quality.

Resources for Child Care Facilities

Related Links

Partners

Subscribe to our free newsletter and health alerts: 
Last reviewed on Jul 31, 2017
Mississippi State Department of Health 570 East Woodrow Wilson Dr Jackson, MS 39216 866-HLTHY4U web@HealthyMS.com
Facebook Twitter Instagram RSS


Debugging Information
ColdFusion Server Standard 2016,0,05,303689
Template /msdhsite/index.cfm
Time Stamp 06-Feb-18 10:39 AM
Locale English (US)
User Agent 28ED30DC-C485-3E07-CF7B3E5165A6B75F
Remote IP 10.121.1.213
Host Name 10.121.1.213


SQL Queries

GetRootGroup (Datasource=msdhsitenewdsn, Time=16ms, Records=1) in F:\inetpub\wwwroot\msdhsite\Application.cfm @ 10:39:37.037
 select GroupID
 from Groups 
 where GroupEnabled = 1 
 and GroupID not in (select GroupID
 from WebApplications wa, WebApplicationsRegister wr, Groups_WebApplications gw, Groups g
 where g.GroupEnabled = 1
 and wr.WebAppRegEnabled = 1 
 and wr.WebAppRegPublic = 0 
 and wa.WebAppReg_ID = wr.WebAppRegID
 and gw.WebApplication_ID = wa.WebApplicationID
 and g.GroupID = gw.Group_ID)
 order by ListOrder DESC
 
GetGroupName (Datasource=msdhsitenewdsn, Time=0ms, Records=1) in F:\inetpub\wwwroot\msdhsite\urlmapping.cfm @ 10:39:37.037
 select Distinct GroupName, GroupDescription, GroupKeywords, GroupPublic
 from Groups 
 where GroupEnabled = 1
 and GroupID = 30 
 and GroupPublic = 1
 
GetCategoryName (Datasource=msdhsitenewdsn, Time=0ms, Records=1) in F:\inetpub\wwwroot\msdhsite\urlmapping.cfm @ 10:39:37.037
 select CategoryName, CategoryDescription
 from Categories
 where CategoryEnabled = 1
 and CategoryName not in ('None','AssetNow Image Library','AssetNow Resource Library')
 and CategoryID = 183 
GetCRGroupName (Datasource=msdhsitenewdsn, Time=0ms, Records=1) in F:\inetpub\wwwroot\msdhsite\urlmapping.cfm @ 10:39:37.037
 select CRGroupName, CRDescription
 from CRGroups
 where CRGroupEnabled = 1
 and CRGroupName not in ('None')
 and CRGroupID = 526 
GetLayout (Datasource=msdhsitenewdsn, Time=15ms, Records=1) in F:\inetpub\wwwroot\msdhsite\_queries\layout_q1.cfm @ 10:39:37.037
 select Leads, LeadsColumns, Articles, ArticlesColumns, News, NewsColumns
 from Groups
 where GroupID = 30 
GetPageTypeContext (Datasource=msdhsitenewdsn, Time=0ms, Records=0) in F:\inetpub\wwwroot\msdhsite\_queries\dynamicinclude_q1.cfm @ 10:39:37.037
 select CategoryContext, CRGroupContext, PageContext
 from PageTypes
 where Enabled = 1 
 and PageTypeName in ('Header');
GetCategories (Datasource=msdhsitenewdsn, Time=63ms, Records=22) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q2.cfm @ 10:39:37.037
 select CategoryID, CategoryName, CategoryDescription, ExpandGroups, ListOrder
 from Categories 
 where CategoryEnabled = 1
 and CategoryName not in ('None','Hidden','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library','Site Information')
 
 and CategoryName not in ('News')
 
 and ( CategoryID in (select distinct c.Category_ID
 from Content c, Content_Groups cg, Groups g, CRGroups cr, PageTypes pt, Content_PageTypes cpt
 where g.GroupEnabled = 1
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1 
 and c.ContentDisplay = 1
 
 and c.Approved = 1 
 and ({d '2018-02-06'} between c.OnDate and c.OffDate
 or (c.OnDate = c.OffDate and {d '2018-02-06'} >= c.OnDate))
 
 and YEAR (c.ReviewDate) > 2000
 
 and pt.PageTypeID = cpt.PageType_ID
 and cpt.Content_ID = c.ContentID 
 and pt.PageTypeName in ('Feature Page','Page')
 and c.ContentID = cg.Content_ID
 and cg.Group_ID = g.GroupID
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 and c.CRGroup_ID = cr.CRGroupID 
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30)

 or
 CategoryID in (select distinct r.Category_ID
 from Resources r, Resources_Groups rg, Groups g, CRGroups cr
 where g.GroupEnabled = 1
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and r.Display = 1
 
 and r.Approved = 1 
 and ({d '2018-02-06'} between r.OnDate and r.OffDate
 or (r.OnDate = r.OffDate and {d '2018-02-06'} >= r.OnDate))
 
 and YEAR (r.ReviewDate) > 2000
 
 and r.Archive = 0
 and r.ResourceID = rg.Resource_ID
 and rg.Group_ID = g.GroupID

 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 and r.CRGroup_ID = cr.CRGroupID 
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30)
 
 )
 order by CategoryName, CategoryID DESC
GetPublicGroups (Datasource=msdhsitenewdsn, Time=16ms, Records=16) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q3.cfm @ 10:39:37.037
 select GroupID, GroupName, GroupDescription, GroupPublic, SubscribeOn
 from Groups 
 where GroupEnabled = 1
 and ({d '2018-02-06'} between OnDate and OffDate
 or (OnDate = OffDate and {d '2018-02-06'} >= OnDate))
 
 and GroupPublic = 1
 
 and ( GroupID not in (select Distinct g.GroupID
 from WebApplications wa, WebApplicationsRegister wr, Groups_WebApplications gw, Groups g
 where g.GroupEnabled = 1
 and wr.WebAppRegEnabled = 1
 and wr.WebAppRegPublic = 0
 and wa.WebAppReg_ID = wr.WebAppRegID
 and gw.WebApplication_ID = wa.WebApplicationID
 and g.GroupID = gw.Group_ID
 and ({d '2018-02-06'} between wa.OnDate and wa.OffDate
 or (wa.OnDate = wa.OffDate and {d '2018-02-06'} >= wa.OnDate)))

 )

 order by GroupName, ListOrder
ListSubCategories (Datasource=msdhsitenewdsn, Time=15ms, Records=1) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:37.037
 (select cr.CRGroupID as ContentGroup, cr.CRGroupName as ContentCategory, cr.CRDescription as Description, cr.ListOrder as ListOrder, 397 as CategoryID, 'Acute Care Systems' as CategoryName
 from Content c, CRGroups cr, Content_Groups cg, Groups g, Categories cat, PageTypes pt, Content_PageTypes cpt 
 where g.GroupEnabled = 1
 and c.CRGRoup_ID = cr.CRGroupID
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30
 and c.ContentID = cg.Content_ID
 and cg.Group_ID = g.GroupID
 and c.ContentDisplay = 1
 
 and c.Approved = 1 
 and ({d '2018-02-06'} between c.OnDate and c.OffDate
 or (c.OnDate = c.OffDate and {d '2018-02-06'} >= c.OnDate))
 
 and YEAR (c.ReviewDate) > 2000
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGroupName not in ('None')
 and pt.PageTypeID = cpt.PageType_ID
 and cpt.Content_ID = c.ContentID 
 and pt.PageTypeName in ('Feature Page','Page')
 and cat.CategoryID = c.Category_ID
 and cat.CategoryEnabled = 1 
 and cat.CategoryID = 397)
 
 union
 
 (select cr.CRGroupID, cr.CRGroupName, cr.CRDescription, cr.ListOrder, 397, 'Acute Care Systems'
 from Resources r, CRGroups cr, Categories cat, Resources_Groups rg, Groups g 
 where g.GroupEnabled = 1
 and r.CRGroup_ID = cr.CRGroupID 
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 
 and YEAR (r.ReviewDate) > 2000
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30 
 and r.ResourceID = rg.Resource_ID
 and rg.Group_ID = g.GroupID
 and r.Display = 1
 and r.Archive = 0
 
 and r.Approved = 1 
 and ({d '2018-02-06'} between r.OnDate and r.OffDate
 or (r.OnDate = r.OffDate and {d '2018-02-06'} >= r.OnDate))
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGRoupName not in ('None')
 and cat.CategoryID = r.Category_ID
 and cat.CategoryEnabled = 1
 and cat.CategoryID = 397)
 

 order by ContentCategory, ContentGroup DESC
ListSubCategories (Datasource=msdhsitenewdsn, Time=0ms, Records=0) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:37.037
 (select cr.CRGroupID as ContentGroup, cr.CRGroupName as ContentCategory, cr.CRDescription as Description, cr.ListOrder as ListOrder, 193 as CategoryID, 'Boiler & Pressure Vessel' as CategoryName
 from Content c, CRGroups cr, Content_Groups cg, Groups g, Categories cat, PageTypes pt, Content_PageTypes cpt 
 where g.GroupEnabled = 1
 and c.CRGRoup_ID = cr.CRGroupID
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30
 and c.ContentID = cg.Content_ID
 and cg.Group_ID = g.GroupID
 and c.ContentDisplay = 1
 
 and c.Approved = 1 
 and ({d '2018-02-06'} between c.OnDate and c.OffDate
 or (c.OnDate = c.OffDate and {d '2018-02-06'} >= c.OnDate))
 
 and YEAR (c.ReviewDate) > 2000
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGroupName not in ('None')
 and pt.PageTypeID = cpt.PageType_ID
 and cpt.Content_ID = c.ContentID 
 and pt.PageTypeName in ('Feature Page','Page')
 and cat.CategoryID = c.Category_ID
 and cat.CategoryEnabled = 1 
 and cat.CategoryID = 193)
 
 union
 
 (select cr.CRGroupID, cr.CRGroupName, cr.CRDescription, cr.ListOrder, 193, 'Boiler & Pressure Vessel'
 from Resources r, CRGroups cr, Categories cat, Resources_Groups rg, Groups g 
 where g.GroupEnabled = 1
 and r.CRGroup_ID = cr.CRGroupID 
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 
 and YEAR (r.ReviewDate) > 2000
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30 
 and r.ResourceID = rg.Resource_ID
 and rg.Group_ID = g.GroupID
 and r.Display = 1
 and r.Archive = 0
 
 and r.Approved = 1 
 and ({d '2018-02-06'} between r.OnDate and r.OffDate
 or (r.OnDate = r.OffDate and {d '2018-02-06'} >= r.OnDate))
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGRoupName not in ('None')
 and cat.CategoryID = r.Category_ID
 and cat.CategoryEnabled = 1
 and cat.CategoryID = 193)
 

 order by ContentCategory, ContentGroup DESC
ListSubCategories (Datasource=msdhsitenewdsn, Time=16ms, Records=12) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:37.037
 (select cr.CRGroupID as ContentGroup, cr.CRGroupName as ContentCategory, cr.CRDescription as Description, cr.ListOrder as ListOrder, 84 as CategoryID, 'Certificates of Need' as CategoryName
 from Content c, CRGroups cr, Content_Groups cg, Groups g, Categories cat, PageTypes pt, Content_PageTypes cpt 
 where g.GroupEnabled = 1
 and c.CRGRoup_ID = cr.CRGroupID
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30
 and c.ContentID = cg.Content_ID
 and cg.Group_ID = g.GroupID
 and c.ContentDisplay = 1
 
 and c.Approved = 1 
 and ({d '2018-02-06'} between c.OnDate and c.OffDate
 or (c.OnDate = c.OffDate and {d '2018-02-06'} >= c.OnDate))
 
 and YEAR (c.ReviewDate) > 2000
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGroupName not in ('None')
 and pt.PageTypeID = cpt.PageType_ID
 and cpt.Content_ID = c.ContentID 
 and pt.PageTypeName in ('Feature Page','Page')
 and cat.CategoryID = c.Category_ID
 and cat.CategoryEnabled = 1 
 and cat.CategoryID = 84)
 
 union
 
 (select cr.CRGroupID, cr.CRGroupName, cr.CRDescription, cr.ListOrder, 84, 'Certificates of Need'
 from Resources r, CRGroups cr, Categories cat, Resources_Groups rg, Groups g 
 where g.GroupEnabled = 1
 and r.CRGroup_ID = cr.CRGroupID 
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 
 and YEAR (r.ReviewDate) > 2000
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30 
 and r.ResourceID = rg.Resource_ID
 and rg.Group_ID = g.GroupID
 and r.Display = 1
 and r.Archive = 0
 
 and r.Approved = 1 
 and ({d '2018-02-06'} between r.OnDate and r.OffDate
 or (r.OnDate = r.OffDate and {d '2018-02-06'} >= r.OnDate))
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGRoupName not in ('None')
 and cat.CategoryID = r.Category_ID
 and cat.CategoryEnabled = 1
 and cat.CategoryID = 84)
 

 order by ContentCategory, ContentGroup DESC
ListSubCategories (Datasource=msdhsitenewdsn, Time=15ms, Records=15) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:37.037
 (select cr.CRGroupID as ContentGroup, cr.CRGroupName as ContentCategory, cr.CRDescription as Description, cr.ListOrder as ListOrder, 183 as CategoryID, 'Child Care & Youth Camps' as CategoryName
 from Content c, CRGroups cr, Content_Groups cg, Groups g, Categories cat, PageTypes pt, Content_PageTypes cpt 
 where g.GroupEnabled = 1
 and c.CRGRoup_ID = cr.CRGroupID
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30
 and c.ContentID = cg.Content_ID
 and cg.Group_ID = g.GroupID
 and c.ContentDisplay = 1
 
 and c.Approved = 1 
 and ({d '2018-02-06'} between c.OnDate and c.OffDate
 or (c.OnDate = c.OffDate and {d '2018-02-06'} >= c.OnDate))
 
 and YEAR (c.ReviewDate) > 2000
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGroupName not in ('None')
 and pt.PageTypeID = cpt.PageType_ID
 and cpt.Content_ID = c.ContentID 
 and pt.PageTypeName in ('Feature Page','Page')
 and cat.CategoryID = c.Category_ID
 and cat.CategoryEnabled = 1 
 and cat.CategoryID = 183)
 
 union
 
 (select cr.CRGroupID, cr.CRGroupName, cr.CRDescription, cr.ListOrder, 183, 'Child Care & Youth Camps'
 from Resources r, CRGroups cr, Categories cat, Resources_Groups rg, Groups g 
 where g.GroupEnabled = 1
 and r.CRGroup_ID = cr.CRGroupID 
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 
 and YEAR (r.ReviewDate) > 2000
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30 
 and r.ResourceID = rg.Resource_ID
 and rg.Group_ID = g.GroupID
 and r.Display = 1
 and r.Archive = 0
 
 and r.Approved = 1 
 and ({d '2018-02-06'} between r.OnDate and r.OffDate
 or (r.OnDate = r.OffDate and {d '2018-02-06'} >= r.OnDate))
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGRoupName not in ('None')
 and cat.CategoryID = r.Category_ID
 and cat.CategoryEnabled = 1
 and cat.CategoryID = 183)
 

 order by ContentCategory, ContentGroup DESC
ListSubCategories (Datasource=msdhsitenewdsn, Time=0ms, Records=0) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:37.037
 (select cr.CRGroupID as ContentGroup, cr.CRGroupName as ContentCategory, cr.CRDescription as Description, cr.ListOrder as ListOrder, 206 as CategoryID, 'Criminal History' as CategoryName
 from Content c, CRGroups cr, Content_Groups cg, Groups g, Categories cat, PageTypes pt, Content_PageTypes cpt 
 where g.GroupEnabled = 1
 and c.CRGRoup_ID = cr.CRGroupID
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30
 and c.ContentID = cg.Content_ID
 and cg.Group_ID = g.GroupID
 and c.ContentDisplay = 1
 
 and c.Approved = 1 
 and ({d '2018-02-06'} between c.OnDate and c.OffDate
 or (c.OnDate = c.OffDate and {d '2018-02-06'} >= c.OnDate))
 
 and YEAR (c.ReviewDate) > 2000
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGroupName not in ('None')
 and pt.PageTypeID = cpt.PageType_ID
 and cpt.Content_ID = c.ContentID 
 and pt.PageTypeName in ('Feature Page','Page')
 and cat.CategoryID = c.Category_ID
 and cat.CategoryEnabled = 1 
 and cat.CategoryID = 206)
 
 union
 
 (select cr.CRGroupID, cr.CRGroupName, cr.CRDescription, cr.ListOrder, 206, 'Criminal History'
 from Resources r, CRGroups cr, Categories cat, Resources_Groups rg, Groups g 
 where g.GroupEnabled = 1
 and r.CRGroup_ID = cr.CRGroupID 
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 
 and YEAR (r.ReviewDate) > 2000
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30 
 and r.ResourceID = rg.Resource_ID
 and rg.Group_ID = g.GroupID
 and r.Display = 1
 and r.Archive = 0
 
 and r.Approved = 1 
 and ({d '2018-02-06'} between r.OnDate and r.OffDate
 or (r.OnDate = r.OffDate and {d '2018-02-06'} >= r.OnDate))
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGRoupName not in ('None')
 and cat.CategoryID = r.Category_ID
 and cat.CategoryEnabled = 1
 and cat.CategoryID = 206)
 

 order by ContentCategory, ContentGroup DESC
ListSubCategories (Datasource=msdhsitenewdsn, Time=16ms, Records=0) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:37.037
 (select cr.CRGroupID as ContentGroup, cr.CRGroupName as ContentCategory, cr.CRDescription as Description, cr.ListOrder as ListOrder, 88 as CategoryID, 'Drug Testing' as CategoryName
 from Content c, CRGroups cr, Content_Groups cg, Groups g, Categories cat, PageTypes pt, Content_PageTypes cpt 
 where g.GroupEnabled = 1
 and c.CRGRoup_ID = cr.CRGroupID
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30
 and c.ContentID = cg.Content_ID
 and cg.Group_ID = g.GroupID
 and c.ContentDisplay = 1
 
 and c.Approved = 1 
 and ({d '2018-02-06'} between c.OnDate and c.OffDate
 or (c.OnDate = c.OffDate and {d '2018-02-06'} >= c.OnDate))
 
 and YEAR (c.ReviewDate) > 2000
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGroupName not in ('None')
 and pt.PageTypeID = cpt.PageType_ID
 and cpt.Content_ID = c.ContentID 
 and pt.PageTypeName in ('Feature Page','Page')
 and cat.CategoryID = c.Category_ID
 and cat.CategoryEnabled = 1 
 and cat.CategoryID = 88)
 
 union
 
 (select cr.CRGroupID, cr.CRGroupName, cr.CRDescription, cr.ListOrder, 88, 'Drug Testing'
 from Resources r, CRGroups cr, Categories cat, Resources_Groups rg, Groups g 
 where g.GroupEnabled = 1
 and r.CRGroup_ID = cr.CRGroupID 
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 
 and YEAR (r.ReviewDate) > 2000
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30 
 and r.ResourceID = rg.Resource_ID
 and rg.Group_ID = g.GroupID
 and r.Display = 1
 and r.Archive = 0
 
 and r.Approved = 1 
 and ({d '2018-02-06'} between r.OnDate and r.OffDate
 or (r.OnDate = r.OffDate and {d '2018-02-06'} >= r.OnDate))
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGRoupName not in ('None')
 and cat.CategoryID = r.Category_ID
 and cat.CategoryEnabled = 1
 and cat.CategoryID = 88)
 

 order by ContentCategory, ContentGroup DESC
ListSubCategories (Datasource=msdhsitenewdsn, Time=0ms, Records=0) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:37.037
 (select cr.CRGroupID as ContentGroup, cr.CRGroupName as ContentCategory, cr.CRDescription as Description, cr.ListOrder as ListOrder, 99 as CategoryID, 'Emergency Medical Services' as CategoryName
 from Content c, CRGroups cr, Content_Groups cg, Groups g, Categories cat, PageTypes pt, Content_PageTypes cpt 
 where g.GroupEnabled = 1
 and c.CRGRoup_ID = cr.CRGroupID
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30
 and c.ContentID = cg.Content_ID
 and cg.Group_ID = g.GroupID
 and c.ContentDisplay = 1
 
 and c.Approved = 1 
 and ({d '2018-02-06'} between c.OnDate and c.OffDate
 or (c.OnDate = c.OffDate and {d '2018-02-06'} >= c.OnDate))
 
 and YEAR (c.ReviewDate) > 2000
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGroupName not in ('None')
 and pt.PageTypeID = cpt.PageType_ID
 and cpt.Content_ID = c.ContentID 
 and pt.PageTypeName in ('Feature Page','Page')
 and cat.CategoryID = c.Category_ID
 and cat.CategoryEnabled = 1 
 and cat.CategoryID = 99)
 
 union
 
 (select cr.CRGroupID, cr.CRGroupName, cr.CRDescription, cr.ListOrder, 99, 'Emergency Medical Services'
 from Resources r, CRGroups cr, Categories cat, Resources_Groups rg, Groups g 
 where g.GroupEnabled = 1
 and r.CRGroup_ID = cr.CRGroupID 
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 
 and YEAR (r.ReviewDate) > 2000
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30 
 and r.ResourceID = rg.Resource_ID
 and rg.Group_ID = g.GroupID
 and r.Display = 1
 and r.Archive = 0
 
 and r.Approved = 1 
 and ({d '2018-02-06'} between r.OnDate and r.OffDate
 or (r.OnDate = r.OffDate and {d '2018-02-06'} >= r.OnDate))
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGRoupName not in ('None')
 and cat.CategoryID = r.Category_ID
 and cat.CategoryEnabled = 1
 and cat.CategoryID = 99)
 

 order by ContentCategory, ContentGroup DESC
ListSubCategories (Datasource=msdhsitenewdsn, Time=0ms, Records=2) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:37.037
 (select cr.CRGroupID as ContentGroup, cr.CRGroupName as ContentCategory, cr.CRDescription as Description, cr.ListOrder as ListOrder, 95 as CategoryID, 'Environmental Health' as CategoryName
 from Content c, CRGroups cr, Content_Groups cg, Groups g, Categories cat, PageTypes pt, Content_PageTypes cpt 
 where g.GroupEnabled = 1
 and c.CRGRoup_ID = cr.CRGroupID
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30
 and c.ContentID = cg.Content_ID
 and cg.Group_ID = g.GroupID
 and c.ContentDisplay = 1
 
 and c.Approved = 1 
 and ({d '2018-02-06'} between c.OnDate and c.OffDate
 or (c.OnDate = c.OffDate and {d '2018-02-06'} >= c.OnDate))
 
 and YEAR (c.ReviewDate) > 2000
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGroupName not in ('None')
 and pt.PageTypeID = cpt.PageType_ID
 and cpt.Content_ID = c.ContentID 
 and pt.PageTypeName in ('Feature Page','Page')
 and cat.CategoryID = c.Category_ID
 and cat.CategoryEnabled = 1 
 and cat.CategoryID = 95)
 
 union
 
 (select cr.CRGroupID, cr.CRGroupName, cr.CRDescription, cr.ListOrder, 95, 'Environmental Health'
 from Resources r, CRGroups cr, Categories cat, Resources_Groups rg, Groups g 
 where g.GroupEnabled = 1
 and r.CRGroup_ID = cr.CRGroupID 
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 
 and YEAR (r.ReviewDate) > 2000
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30 
 and r.ResourceID = rg.Resource_ID
 and rg.Group_ID = g.GroupID
 and r.Display = 1
 and r.Archive = 0
 
 and r.Approved = 1 
 and ({d '2018-02-06'} between r.OnDate and r.OffDate
 or (r.OnDate = r.OffDate and {d '2018-02-06'} >= r.OnDate))
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGRoupName not in ('None')
 and cat.CategoryID = r.Category_ID
 and cat.CategoryEnabled = 1
 and cat.CategoryID = 95)
 

 order by ContentCategory, ContentGroup DESC
ListSubCategories (Datasource=msdhsitenewdsn, Time=16ms, Records=7) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:37.037
 (select cr.CRGroupID as ContentGroup, cr.CRGroupName as ContentCategory, cr.CRDescription as Description, cr.ListOrder as ListOrder, 77 as CategoryID, 'Food Facilities and Permits' as CategoryName
 from Content c, CRGroups cr, Content_Groups cg, Groups g, Categories cat, PageTypes pt, Content_PageTypes cpt 
 where g.GroupEnabled = 1
 and c.CRGRoup_ID = cr.CRGroupID
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30
 and c.ContentID = cg.Content_ID
 and cg.Group_ID = g.GroupID
 and c.ContentDisplay = 1
 
 and c.Approved = 1 
 and ({d '2018-02-06'} between c.OnDate and c.OffDate
 or (c.OnDate = c.OffDate and {d '2018-02-06'} >= c.OnDate))
 
 and YEAR (c.ReviewDate) > 2000
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGroupName not in ('None')
 and pt.PageTypeID = cpt.PageType_ID
 and cpt.Content_ID = c.ContentID 
 and pt.PageTypeName in ('Feature Page','Page')
 and cat.CategoryID = c.Category_ID
 and cat.CategoryEnabled = 1 
 and cat.CategoryID = 77)
 
 union
 
 (select cr.CRGroupID, cr.CRGroupName, cr.CRDescription, cr.ListOrder, 77, 'Food Facilities and Permits'
 from Resources r, CRGroups cr, Categories cat, Resources_Groups rg, Groups g 
 where g.GroupEnabled = 1
 and r.CRGroup_ID = cr.CRGroupID 
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 
 and YEAR (r.ReviewDate) > 2000
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30 
 and r.ResourceID = rg.Resource_ID
 and rg.Group_ID = g.GroupID
 and r.Display = 1
 and r.Archive = 0
 
 and r.Approved = 1 
 and ({d '2018-02-06'} between r.OnDate and r.OffDate
 or (r.OnDate = r.OffDate and {d '2018-02-06'} >= r.OnDate))
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGRoupName not in ('None')
 and cat.CategoryID = r.Category_ID
 and cat.CategoryEnabled = 1
 and cat.CategoryID = 77)
 

 order by ContentCategory, ContentGroup DESC
ListSubCategories (Datasource=msdhsitenewdsn, Time=0ms, Records=12) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:37.037
 (select cr.CRGroupID as ContentGroup, cr.CRGroupName as ContentCategory, cr.CRDescription as Description, cr.ListOrder as ListOrder, 83 as CategoryID, 'Health and Care Facilities' as CategoryName
 from Content c, CRGroups cr, Content_Groups cg, Groups g, Categories cat, PageTypes pt, Content_PageTypes cpt 
 where g.GroupEnabled = 1
 and c.CRGRoup_ID = cr.CRGroupID
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30
 and c.ContentID = cg.Content_ID
 and cg.Group_ID = g.GroupID
 and c.ContentDisplay = 1
 
 and c.Approved = 1 
 and ({d '2018-02-06'} between c.OnDate and c.OffDate
 or (c.OnDate = c.OffDate and {d '2018-02-06'} >= c.OnDate))
 
 and YEAR (c.ReviewDate) > 2000
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGroupName not in ('None')
 and pt.PageTypeID = cpt.PageType_ID
 and cpt.Content_ID = c.ContentID 
 and pt.PageTypeName in ('Feature Page','Page')
 and cat.CategoryID = c.Category_ID
 and cat.CategoryEnabled = 1 
 and cat.CategoryID = 83)
 
 union
 
 (select cr.CRGroupID, cr.CRGroupName, cr.CRDescription, cr.ListOrder, 83, 'Health and Care Facilities'
 from Resources r, CRGroups cr, Categories cat, Resources_Groups rg, Groups g 
 where g.GroupEnabled = 1
 and r.CRGroup_ID = cr.CRGroupID 
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 
 and YEAR (r.ReviewDate) > 2000
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30 
 and r.ResourceID = rg.Resource_ID
 and rg.Group_ID = g.GroupID
 and r.Display = 1
 and r.Archive = 0
 
 and r.Approved = 1 
 and ({d '2018-02-06'} between r.OnDate and r.OffDate
 or (r.OnDate = r.OffDate and {d '2018-02-06'} >= r.OnDate))
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGRoupName not in ('None')
 and cat.CategoryID = r.Category_ID
 and cat.CategoryEnabled = 1
 and cat.CategoryID = 83)
 

 order by ContentCategory, ContentGroup DESC
ListSubCategories (Datasource=msdhsitenewdsn, Time=15ms, Records=0) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:38.038
 (select cr.CRGroupID as ContentGroup, cr.CRGroupName as ContentCategory, cr.CRDescription as Description, cr.ListOrder as ListOrder, 216 as CategoryID, 'Legislation' as CategoryName
 from Content c, CRGroups cr, Content_Groups cg, Groups g, Categories cat, PageTypes pt, Content_PageTypes cpt 
 where g.GroupEnabled = 1
 and c.CRGRoup_ID = cr.CRGroupID
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30
 and c.ContentID = cg.Content_ID
 and cg.Group_ID = g.GroupID
 and c.ContentDisplay = 1
 
 and c.Approved = 1 
 and ({d '2018-02-06'} between c.OnDate and c.OffDate
 or (c.OnDate = c.OffDate and {d '2018-02-06'} >= c.OnDate))
 
 and YEAR (c.ReviewDate) > 2000
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGroupName not in ('None')
 and pt.PageTypeID = cpt.PageType_ID
 and cpt.Content_ID = c.ContentID 
 and pt.PageTypeName in ('Feature Page','Page')
 and cat.CategoryID = c.Category_ID
 and cat.CategoryEnabled = 1 
 and cat.CategoryID = 216)
 
 union
 
 (select cr.CRGroupID, cr.CRGroupName, cr.CRDescription, cr.ListOrder, 216, 'Legislation'
 from Resources r, CRGroups cr, Categories cat, Resources_Groups rg, Groups g 
 where g.GroupEnabled = 1
 and r.CRGroup_ID = cr.CRGroupID 
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 
 and YEAR (r.ReviewDate) > 2000
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30 
 and r.ResourceID = rg.Resource_ID
 and rg.Group_ID = g.GroupID
 and r.Display = 1
 and r.Archive = 0
 
 and r.Approved = 1 
 and ({d '2018-02-06'} between r.OnDate and r.OffDate
 or (r.OnDate = r.OffDate and {d '2018-02-06'} >= r.OnDate))
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGRoupName not in ('None')
 and cat.CategoryID = r.Category_ID
 and cat.CategoryEnabled = 1
 and cat.CategoryID = 216)
 

 order by ContentCategory, ContentGroup DESC
ListSubCategories (Datasource=msdhsitenewdsn, Time=0ms, Records=1) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:38.038
 (select cr.CRGroupID as ContentGroup, cr.CRGroupName as ContentCategory, cr.CRDescription as Description, cr.ListOrder as ListOrder, 117 as CategoryID, 'Milk & Bottled Water' as CategoryName
 from Content c, CRGroups cr, Content_Groups cg, Groups g, Categories cat, PageTypes pt, Content_PageTypes cpt 
 where g.GroupEnabled = 1
 and c.CRGRoup_ID = cr.CRGroupID
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30
 and c.ContentID = cg.Content_ID
 and cg.Group_ID = g.GroupID
 and c.ContentDisplay = 1
 
 and c.Approved = 1 
 and ({d '2018-02-06'} between c.OnDate and c.OffDate
 or (c.OnDate = c.OffDate and {d '2018-02-06'} >= c.OnDate))
 
 and YEAR (c.ReviewDate) > 2000
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGroupName not in ('None')
 and pt.PageTypeID = cpt.PageType_ID
 and cpt.Content_ID = c.ContentID 
 and pt.PageTypeName in ('Feature Page','Page')
 and cat.CategoryID = c.Category_ID
 and cat.CategoryEnabled = 1 
 and cat.CategoryID = 117)
 
 union
 
 (select cr.CRGroupID, cr.CRGroupName, cr.CRDescription, cr.ListOrder, 117, 'Milk & Bottled Water'
 from Resources r, CRGroups cr, Categories cat, Resources_Groups rg, Groups g 
 where g.GroupEnabled = 1
 and r.CRGroup_ID = cr.CRGroupID 
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 
 and YEAR (r.ReviewDate) > 2000
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30 
 and r.ResourceID = rg.Resource_ID
 and rg.Group_ID = g.GroupID
 and r.Display = 1
 and r.Archive = 0
 
 and r.Approved = 1 
 and ({d '2018-02-06'} between r.OnDate and r.OffDate
 or (r.OnDate = r.OffDate and {d '2018-02-06'} >= r.OnDate))
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGRoupName not in ('None')
 and cat.CategoryID = r.Category_ID
 and cat.CategoryEnabled = 1
 and cat.CategoryID = 117)
 

 order by ContentCategory, ContentGroup DESC
ListSubCategories (Datasource=msdhsitenewdsn, Time=0ms, Records=1) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:38.038
 (select cr.CRGroupID as ContentGroup, cr.CRGroupName as ContentCategory, cr.CRDescription as Description, cr.ListOrder as ListOrder, 101 as CategoryID, 'Newborn Screening' as CategoryName
 from Content c, CRGroups cr, Content_Groups cg, Groups g, Categories cat, PageTypes pt, Content_PageTypes cpt 
 where g.GroupEnabled = 1
 and c.CRGRoup_ID = cr.CRGroupID
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30
 and c.ContentID = cg.Content_ID
 and cg.Group_ID = g.GroupID
 and c.ContentDisplay = 1
 
 and c.Approved = 1 
 and ({d '2018-02-06'} between c.OnDate and c.OffDate
 or (c.OnDate = c.OffDate and {d '2018-02-06'} >= c.OnDate))
 
 and YEAR (c.ReviewDate) > 2000
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGroupName not in ('None')
 and pt.PageTypeID = cpt.PageType_ID
 and cpt.Content_ID = c.ContentID 
 and pt.PageTypeName in ('Feature Page','Page')
 and cat.CategoryID = c.Category_ID
 and cat.CategoryEnabled = 1 
 and cat.CategoryID = 101)
 
 union
 
 (select cr.CRGroupID, cr.CRGroupName, cr.CRDescription, cr.ListOrder, 101, 'Newborn Screening'
 from Resources r, CRGroups cr, Categories cat, Resources_Groups rg, Groups g 
 where g.GroupEnabled = 1
 and r.CRGroup_ID = cr.CRGroupID 
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 
 and YEAR (r.ReviewDate) > 2000
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30 
 and r.ResourceID = rg.Resource_ID
 and rg.Group_ID = g.GroupID
 and r.Display = 1
 and r.Archive = 0
 
 and r.Approved = 1 
 and ({d '2018-02-06'} between r.OnDate and r.OffDate
 or (r.OnDate = r.OffDate and {d '2018-02-06'} >= r.OnDate))
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGRoupName not in ('None')
 and cat.CategoryID = r.Category_ID
 and cat.CategoryEnabled = 1
 and cat.CategoryID = 101)
 

 order by ContentCategory, ContentGroup DESC
ListSubCategories (Datasource=msdhsitenewdsn, Time=16ms, Records=9) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:38.038
 (select cr.CRGroupID as ContentGroup, cr.CRGroupName as ContentCategory, cr.CRDescription as Description, cr.ListOrder as ListOrder, 78 as CategoryID, 'On-Site Wastewater' as CategoryName
 from Content c, CRGroups cr, Content_Groups cg, Groups g, Categories cat, PageTypes pt, Content_PageTypes cpt 
 where g.GroupEnabled = 1
 and c.CRGRoup_ID = cr.CRGroupID
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30
 and c.ContentID = cg.Content_ID
 and cg.Group_ID = g.GroupID
 and c.ContentDisplay = 1
 
 and c.Approved = 1 
 and ({d '2018-02-06'} between c.OnDate and c.OffDate
 or (c.OnDate = c.OffDate and {d '2018-02-06'} >= c.OnDate))
 
 and YEAR (c.ReviewDate) > 2000
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGroupName not in ('None')
 and pt.PageTypeID = cpt.PageType_ID
 and cpt.Content_ID = c.ContentID 
 and pt.PageTypeName in ('Feature Page','Page')
 and cat.CategoryID = c.Category_ID
 and cat.CategoryEnabled = 1 
 and cat.CategoryID = 78)
 
 union
 
 (select cr.CRGroupID, cr.CRGroupName, cr.CRDescription, cr.ListOrder, 78, 'On-Site Wastewater'
 from Resources r, CRGroups cr, Categories cat, Resources_Groups rg, Groups g 
 where g.GroupEnabled = 1
 and r.CRGroup_ID = cr.CRGroupID 
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 
 and YEAR (r.ReviewDate) > 2000
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30 
 and r.ResourceID = rg.Resource_ID
 and rg.Group_ID = g.GroupID
 and r.Display = 1
 and r.Archive = 0
 
 and r.Approved = 1 
 and ({d '2018-02-06'} between r.OnDate and r.OffDate
 or (r.OnDate = r.OffDate and {d '2018-02-06'} >= r.OnDate))
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGRoupName not in ('None')
 and cat.CategoryID = r.Category_ID
 and cat.CategoryEnabled = 1
 and cat.CategoryID = 78)
 

 order by ContentCategory, ContentGroup DESC
ListSubCategories (Datasource=msdhsitenewdsn, Time=0ms, Records=5) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:38.038
 (select cr.CRGroupID as ContentGroup, cr.CRGroupName as ContentCategory, cr.CRDescription as Description, cr.ListOrder as ListOrder, 82 as CategoryID, 'Professional Licensure' as CategoryName
 from Content c, CRGroups cr, Content_Groups cg, Groups g, Categories cat, PageTypes pt, Content_PageTypes cpt 
 where g.GroupEnabled = 1
 and c.CRGRoup_ID = cr.CRGroupID
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30
 and c.ContentID = cg.Content_ID
 and cg.Group_ID = g.GroupID
 and c.ContentDisplay = 1
 
 and c.Approved = 1 
 and ({d '2018-02-06'} between c.OnDate and c.OffDate
 or (c.OnDate = c.OffDate and {d '2018-02-06'} >= c.OnDate))
 
 and YEAR (c.ReviewDate) > 2000
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGroupName not in ('None')
 and pt.PageTypeID = cpt.PageType_ID
 and cpt.Content_ID = c.ContentID 
 and pt.PageTypeName in ('Feature Page','Page')
 and cat.CategoryID = c.Category_ID
 and cat.CategoryEnabled = 1 
 and cat.CategoryID = 82)
 
 union
 
 (select cr.CRGroupID, cr.CRGroupName, cr.CRDescription, cr.ListOrder, 82, 'Professional Licensure'
 from Resources r, CRGroups cr, Categories cat, Resources_Groups rg, Groups g 
 where g.GroupEnabled = 1
 and r.CRGroup_ID = cr.CRGroupID 
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 
 and YEAR (r.ReviewDate) > 2000
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30 
 and r.ResourceID = rg.Resource_ID
 and rg.Group_ID = g.GroupID
 and r.Display = 1
 and r.Archive = 0
 
 and r.Approved = 1 
 and ({d '2018-02-06'} between r.OnDate and r.OffDate
 or (r.OnDate = r.OffDate and {d '2018-02-06'} >= r.OnDate))
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGRoupName not in ('None')
 and cat.CategoryID = r.Category_ID
 and cat.CategoryEnabled = 1
 and cat.CategoryID = 82)
 

 order by ContentCategory, ContentGroup DESC
ListSubCategories (Datasource=msdhsitenewdsn, Time=16ms, Records=7) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:38.038
 (select cr.CRGroupID as ContentGroup, cr.CRGroupName as ContentCategory, cr.CRDescription as Description, cr.ListOrder as ListOrder, 102 as CategoryID, 'Radiological Health' as CategoryName
 from Content c, CRGroups cr, Content_Groups cg, Groups g, Categories cat, PageTypes pt, Content_PageTypes cpt 
 where g.GroupEnabled = 1
 and c.CRGRoup_ID = cr.CRGroupID
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30
 and c.ContentID = cg.Content_ID
 and cg.Group_ID = g.GroupID
 and c.ContentDisplay = 1
 
 and c.Approved = 1 
 and ({d '2018-02-06'} between c.OnDate and c.OffDate
 or (c.OnDate = c.OffDate and {d '2018-02-06'} >= c.OnDate))
 
 and YEAR (c.ReviewDate) > 2000
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGroupName not in ('None')
 and pt.PageTypeID = cpt.PageType_ID
 and cpt.Content_ID = c.ContentID 
 and pt.PageTypeName in ('Feature Page','Page')
 and cat.CategoryID = c.Category_ID
 and cat.CategoryEnabled = 1 
 and cat.CategoryID = 102)
 
 union
 
 (select cr.CRGroupID, cr.CRGroupName, cr.CRDescription, cr.ListOrder, 102, 'Radiological Health'
 from Resources r, CRGroups cr, Categories cat, Resources_Groups rg, Groups g 
 where g.GroupEnabled = 1
 and r.CRGroup_ID = cr.CRGroupID 
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 
 and YEAR (r.ReviewDate) > 2000
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30 
 and r.ResourceID = rg.Resource_ID
 and rg.Group_ID = g.GroupID
 and r.Display = 1
 and r.Archive = 0
 
 and r.Approved = 1 
 and ({d '2018-02-06'} between r.OnDate and r.OffDate
 or (r.OnDate = r.OffDate and {d '2018-02-06'} >= r.OnDate))
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGRoupName not in ('None')
 and cat.CategoryID = r.Category_ID
 and cat.CategoryEnabled = 1
 and cat.CategoryID = 102)
 

 order by ContentCategory, ContentGroup DESC
ListSubCategories (Datasource=msdhsitenewdsn, Time=0ms, Records=0) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:38.038
 (select cr.CRGroupID as ContentGroup, cr.CRGroupName as ContentCategory, cr.CRDescription as Description, cr.ListOrder as ListOrder, 194 as CategoryID, 'Reportable Diseases' as CategoryName
 from Content c, CRGroups cr, Content_Groups cg, Groups g, Categories cat, PageTypes pt, Content_PageTypes cpt 
 where g.GroupEnabled = 1
 and c.CRGRoup_ID = cr.CRGroupID
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30
 and c.ContentID = cg.Content_ID
 and cg.Group_ID = g.GroupID
 and c.ContentDisplay = 1
 
 and c.Approved = 1 
 and ({d '2018-02-06'} between c.OnDate and c.OffDate
 or (c.OnDate = c.OffDate and {d '2018-02-06'} >= c.OnDate))
 
 and YEAR (c.ReviewDate) > 2000
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGroupName not in ('None')
 and pt.PageTypeID = cpt.PageType_ID
 and cpt.Content_ID = c.ContentID 
 and pt.PageTypeName in ('Feature Page','Page')
 and cat.CategoryID = c.Category_ID
 and cat.CategoryEnabled = 1 
 and cat.CategoryID = 194)
 
 union
 
 (select cr.CRGroupID, cr.CRGroupName, cr.CRDescription, cr.ListOrder, 194, 'Reportable Diseases'
 from Resources r, CRGroups cr, Categories cat, Resources_Groups rg, Groups g 
 where g.GroupEnabled = 1
 and r.CRGroup_ID = cr.CRGroupID 
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 
 and YEAR (r.ReviewDate) > 2000
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30 
 and r.ResourceID = rg.Resource_ID
 and rg.Group_ID = g.GroupID
 and r.Display = 1
 and r.Archive = 0
 
 and r.Approved = 1 
 and ({d '2018-02-06'} between r.OnDate and r.OffDate
 or (r.OnDate = r.OffDate and {d '2018-02-06'} >= r.OnDate))
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGRoupName not in ('None')
 and cat.CategoryID = r.Category_ID
 and cat.CategoryEnabled = 1
 and cat.CategoryID = 194)
 

 order by ContentCategory, ContentGroup DESC
ListSubCategories (Datasource=msdhsitenewdsn, Time=0ms, Records=1) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:38.038
 (select cr.CRGroupID as ContentGroup, cr.CRGroupName as ContentCategory, cr.CRDescription as Description, cr.ListOrder as ListOrder, 111 as CategoryID, 'Rural Health' as CategoryName
 from Content c, CRGroups cr, Content_Groups cg, Groups g, Categories cat, PageTypes pt, Content_PageTypes cpt 
 where g.GroupEnabled = 1
 and c.CRGRoup_ID = cr.CRGroupID
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30
 and c.ContentID = cg.Content_ID
 and cg.Group_ID = g.GroupID
 and c.ContentDisplay = 1
 
 and c.Approved = 1 
 and ({d '2018-02-06'} between c.OnDate and c.OffDate
 or (c.OnDate = c.OffDate and {d '2018-02-06'} >= c.OnDate))
 
 and YEAR (c.ReviewDate) > 2000
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGroupName not in ('None')
 and pt.PageTypeID = cpt.PageType_ID
 and cpt.Content_ID = c.ContentID 
 and pt.PageTypeName in ('Feature Page','Page')
 and cat.CategoryID = c.Category_ID
 and cat.CategoryEnabled = 1 
 and cat.CategoryID = 111)
 
 union
 
 (select cr.CRGroupID, cr.CRGroupName, cr.CRDescription, cr.ListOrder, 111, 'Rural Health'
 from Resources r, CRGroups cr, Categories cat, Resources_Groups rg, Groups g 
 where g.GroupEnabled = 1
 and r.CRGroup_ID = cr.CRGroupID 
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 
 and YEAR (r.ReviewDate) > 2000
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30 
 and r.ResourceID = rg.Resource_ID
 and rg.Group_ID = g.GroupID
 and r.Display = 1
 and r.Archive = 0
 
 and r.Approved = 1 
 and ({d '2018-02-06'} between r.OnDate and r.OffDate
 or (r.OnDate = r.OffDate and {d '2018-02-06'} >= r.OnDate))
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGRoupName not in ('None')
 and cat.CategoryID = r.Category_ID
 and cat.CategoryEnabled = 1
 and cat.CategoryID = 111)
 

 order by ContentCategory, ContentGroup DESC
ListSubCategories (Datasource=msdhsitenewdsn, Time=0ms, Records=3) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:38.038
 (select cr.CRGroupID as ContentGroup, cr.CRGroupName as ContentCategory, cr.CRDescription as Description, cr.ListOrder as ListOrder, 401 as CategoryID, 'Tanning Facilities' as CategoryName
 from Content c, CRGroups cr, Content_Groups cg, Groups g, Categories cat, PageTypes pt, Content_PageTypes cpt 
 where g.GroupEnabled = 1
 and c.CRGRoup_ID = cr.CRGroupID
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30
 and c.ContentID = cg.Content_ID
 and cg.Group_ID = g.GroupID
 and c.ContentDisplay = 1
 
 and c.Approved = 1 
 and ({d '2018-02-06'} between c.OnDate and c.OffDate
 or (c.OnDate = c.OffDate and {d '2018-02-06'} >= c.OnDate))
 
 and YEAR (c.ReviewDate) > 2000
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGroupName not in ('None')
 and pt.PageTypeID = cpt.PageType_ID
 and cpt.Content_ID = c.ContentID 
 and pt.PageTypeName in ('Feature Page','Page')
 and cat.CategoryID = c.Category_ID
 and cat.CategoryEnabled = 1 
 and cat.CategoryID = 401)
 
 union
 
 (select cr.CRGroupID, cr.CRGroupName, cr.CRDescription, cr.ListOrder, 401, 'Tanning Facilities'
 from Resources r, CRGroups cr, Categories cat, Resources_Groups rg, Groups g 
 where g.GroupEnabled = 1
 and r.CRGroup_ID = cr.CRGroupID 
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 
 and YEAR (r.ReviewDate) > 2000
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30 
 and r.ResourceID = rg.Resource_ID
 and rg.Group_ID = g.GroupID
 and r.Display = 1
 and r.Archive = 0
 
 and r.Approved = 1 
 and ({d '2018-02-06'} between r.OnDate and r.OffDate
 or (r.OnDate = r.OffDate and {d '2018-02-06'} >= r.OnDate))
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGRoupName not in ('None')
 and cat.CategoryID = r.Category_ID
 and cat.CategoryEnabled = 1
 and cat.CategoryID = 401)
 

 order by ContentCategory, ContentGroup DESC
ListSubCategories (Datasource=msdhsitenewdsn, Time=0ms, Records=1) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:38.038
 (select cr.CRGroupID as ContentGroup, cr.CRGroupName as ContentCategory, cr.CRDescription as Description, cr.ListOrder as ListOrder, 75 as CategoryID, 'Vital Statistics' as CategoryName
 from Content c, CRGroups cr, Content_Groups cg, Groups g, Categories cat, PageTypes pt, Content_PageTypes cpt 
 where g.GroupEnabled = 1
 and c.CRGRoup_ID = cr.CRGroupID
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30
 and c.ContentID = cg.Content_ID
 and cg.Group_ID = g.GroupID
 and c.ContentDisplay = 1
 
 and c.Approved = 1 
 and ({d '2018-02-06'} between c.OnDate and c.OffDate
 or (c.OnDate = c.OffDate and {d '2018-02-06'} >= c.OnDate))
 
 and YEAR (c.ReviewDate) > 2000
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGroupName not in ('None')
 and pt.PageTypeID = cpt.PageType_ID
 and cpt.Content_ID = c.ContentID 
 and pt.PageTypeName in ('Feature Page','Page')
 and cat.CategoryID = c.Category_ID
 and cat.CategoryEnabled = 1 
 and cat.CategoryID = 75)
 
 union
 
 (select cr.CRGroupID, cr.CRGroupName, cr.CRDescription, cr.ListOrder, 75, 'Vital Statistics'
 from Resources r, CRGroups cr, Categories cat, Resources_Groups rg, Groups g 
 where g.GroupEnabled = 1
 and r.CRGroup_ID = cr.CRGroupID 
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 
 and YEAR (r.ReviewDate) > 2000
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30 
 and r.ResourceID = rg.Resource_ID
 and rg.Group_ID = g.GroupID
 and r.Display = 1
 and r.Archive = 0
 
 and r.Approved = 1 
 and ({d '2018-02-06'} between r.OnDate and r.OffDate
 or (r.OnDate = r.OffDate and {d '2018-02-06'} >= r.OnDate))
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGRoupName not in ('None')
 and cat.CategoryID = r.Category_ID
 and cat.CategoryEnabled = 1
 and cat.CategoryID = 75)
 

 order by ContentCategory, ContentGroup DESC
ListSubCategories (Datasource=msdhsitenewdsn, Time=16ms, Records=11) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:38.038
 (select cr.CRGroupID as ContentGroup, cr.CRGroupName as ContentCategory, cr.CRDescription as Description, cr.ListOrder as ListOrder, 76 as CategoryID, 'Water Supply' as CategoryName
 from Content c, CRGroups cr, Content_Groups cg, Groups g, Categories cat, PageTypes pt, Content_PageTypes cpt 
 where g.GroupEnabled = 1
 and c.CRGRoup_ID = cr.CRGroupID
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30
 and c.ContentID = cg.Content_ID
 and cg.Group_ID = g.GroupID
 and c.ContentDisplay = 1
 
 and c.Approved = 1 
 and ({d '2018-02-06'} between c.OnDate and c.OffDate
 or (c.OnDate = c.OffDate and {d '2018-02-06'} >= c.OnDate))
 
 and YEAR (c.ReviewDate) > 2000
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGroupName not in ('None')
 and pt.PageTypeID = cpt.PageType_ID
 and cpt.Content_ID = c.ContentID 
 and pt.PageTypeName in ('Feature Page','Page')
 and cat.CategoryID = c.Category_ID
 and cat.CategoryEnabled = 1 
 and cat.CategoryID = 76)
 
 union
 
 (select cr.CRGroupID, cr.CRGroupName, cr.CRDescription, cr.ListOrder, 76, 'Water Supply'
 from Resources r, CRGroups cr, Categories cat, Resources_Groups rg, Groups g 
 where g.GroupEnabled = 1
 and r.CRGroup_ID = cr.CRGroupID 
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 
 and YEAR (r.ReviewDate) > 2000
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30 
 and r.ResourceID = rg.Resource_ID
 and rg.Group_ID = g.GroupID
 and r.Display = 1
 and r.Archive = 0
 
 and r.Approved = 1 
 and ({d '2018-02-06'} between r.OnDate and r.OffDate
 or (r.OnDate = r.OffDate and {d '2018-02-06'} >= r.OnDate))
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGRoupName not in ('None')
 and cat.CategoryID = r.Category_ID
 and cat.CategoryEnabled = 1
 and cat.CategoryID = 76)
 

 order by ContentCategory, ContentGroup DESC
ListSubCategories (Datasource=msdhsitenewdsn, Time=0ms, Records=1) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:38.038
 (select cr.CRGroupID as ContentGroup, cr.CRGroupName as ContentCategory, cr.CRDescription as Description, cr.ListOrder as ListOrder, 127 as CategoryID, 'Water Systems Revolving Fund' as CategoryName
 from Content c, CRGroups cr, Content_Groups cg, Groups g, Categories cat, PageTypes pt, Content_PageTypes cpt 
 where g.GroupEnabled = 1
 and c.CRGRoup_ID = cr.CRGroupID
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30
 and c.ContentID = cg.Content_ID
 and cg.Group_ID = g.GroupID
 and c.ContentDisplay = 1
 
 and c.Approved = 1 
 and ({d '2018-02-06'} between c.OnDate and c.OffDate
 or (c.OnDate = c.OffDate and {d '2018-02-06'} >= c.OnDate))
 
 and YEAR (c.ReviewDate) > 2000
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGroupName not in ('None')
 and pt.PageTypeID = cpt.PageType_ID
 and cpt.Content_ID = c.ContentID 
 and pt.PageTypeName in ('Feature Page','Page')
 and cat.CategoryID = c.Category_ID
 and cat.CategoryEnabled = 1 
 and cat.CategoryID = 127)
 
 union
 
 (select cr.CRGroupID, cr.CRGroupName, cr.CRDescription, cr.ListOrder, 127, 'Water Systems Revolving Fund'
 from Resources r, CRGroups cr, Categories cat, Resources_Groups rg, Groups g 
 where g.GroupEnabled = 1
 and r.CRGroup_ID = cr.CRGroupID 
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 
 and YEAR (r.ReviewDate) > 2000
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30 
 and r.ResourceID = rg.Resource_ID
 and rg.Group_ID = g.GroupID
 and r.Display = 1
 and r.Archive = 0
 
 and r.Approved = 1 
 and ({d '2018-02-06'} between r.OnDate and r.OffDate
 or (r.OnDate = r.OffDate and {d '2018-02-06'} >= r.OnDate))
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGRoupName not in ('None')
 and cat.CategoryID = r.Category_ID
 and cat.CategoryEnabled = 1
 and cat.CategoryID = 127)
 

 order by ContentCategory, ContentGroup DESC
ListContent (Datasource=msdhsitenewdsn, Time=62ms, Records=0) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q5.cfm @ 10:39:38.038
 select c.ContentID, c.ContentTitle, c.ContentTeaser as Teaser, c.ListOrder, 'Page' as ContentType, '' as ContentPath
 from Content c, Categories cat, CRGroups cr, Content_Groups cg, Groups g, PageTypes pt, Content_PageTypes cpt 
 where c.ContentDisplay = 1
 
 and c.Approved = 1 
 and ({d '2018-02-06'} between c.OnDate and c.OffDate
 or (c.OnDate = c.OffDate and {d '2018-02-06'} >= c.OnDate))
 
 and c.ContentID = cg.Content_ID
 and cg.Group_ID = g.GroupID
 and g.GroupEnabled = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30
 and c.CRGRoup_ID = cr.CRGroupID
 and cr.CRGroupName in ('None') 
 and cr.CRGroupEnabled = 1
 and c.Category_ID = cat.CategoryID
 and cat.CategoryName in ('None')
 and cat.CategoryName not in ('AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cat.CategoryEnabled = 1
 and pt.PageTypeID = cpt.PageType_ID
 and cpt.Content_ID = c.ContentID 
 and pt.PageTypeName in ('Page')
 and pt.Enabled = 1
 order by c.ListOrder DESC, c.ContentID DESC
GetContent (Datasource=msdhsitenewdsn, Time=94ms, Records=1) in F:\inetpub\wwwroot\msdhsite\_queries\handler3_q1.cfm @ 10:39:38.038
 select c.ContentID, c.ContentTitle, c.ContentTeaser, c.ClientImageFile, c.DisplayImage, c.Author_ID, c.DateAuthored, c.DateApproved,
 c.DateUpdated, c.OnDate, c.OffDate, c.Category_ID, c.ListOrder, c.Author_ID, c.CRGroup_ID, c.ContentViews, c.Lastview, c.PeriodViews, c.Approved, c.OnDate, c.OffDate, pt.PageTypeName, cg.Group_ID
 from Content c, Categories cat, CRGroups cr, Content_Groups cg, Groups g, PageTypes pt, Content_PageTypes cpt 
 where c.ContentID = cg.Content_ID
 and cg.Group_ID = g.GroupID
 and c.ContentDisplay = 1
 
 and c.Approved = 1 
 and ({d '2018-02-06'} between c.OnDate and c.OffDate
 or ({d '2018-02-06'} >= c.OnDate and c.OnDate = c.OffDate)) 
 
 and YEAR (c.ReviewDate) > 2000
 
 and c.CRGRoup_ID = cr.CRGroupID
 and cr.CRGroupEnabled = 1
 and cr.CRGroupName not in ('None')
 and c.Category_ID = cat.CategoryID
 and cat.CategoryEnabled = 1
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and pt.PageTypeID = cpt.PageType_ID
 and cpt.Content_ID = c.ContentID 
 and pt.PageTypeName in ('Feature Page') 
 and cr.CRGroupName in ('Physical Activity in Child Care')
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30
 and g.GroupEnabled = 1
 and c.Category_ID = 183
 order by c.ListOrder DESC, c.DateAuthored DESC, c.ContentID DESC 
 
ListContent (Datasource=msdhsitenewdsn, Time=281ms, Records=0) in F:\inetpub\wwwroot\msdhsite\_queries\handler3_q2.cfm @ 10:39:38.038
 (select c.ContentID as ContentID, c.DateAuthored as DateAuthored, c.DateUpdated as DateUpdated, c.ContentTitle as Title, '' as FileSize, cr.CRGroupID as Category,
 c.ContentTeaser as Teaser, c.ListOrder as ListOrder, '.anw' as ServerFile, '' as ClientFile, c.Author_ID as Author_ID, c.Approved as Approved, c.OnDate as OnDate, c.OffDate as OffDate, pt.PageTypeName as PageTypeName
 from Content c, Categories cat, CRGroups cr, Content_Groups cg, Groups g, PageTypes pt, Content_PageTypes cpt 
 where c.ContentID = cg.Content_ID
 and cg.Group_ID = g.GroupID
 and c.ContentDisplay = 1
 
 and c.Approved = 1 
 and ({d '2018-02-06'} between c.OnDate and c.OffDate
 or ({d '2018-02-06'} >= c.OnDate and c.OnDate = c.OffDate))
 
 and YEAR (c.ReviewDate) > 2000
 
 and pt.PageTypeID = cpt.PageType_ID
 and cpt.Content_ID = c.ContentID 
 and pt.PageTypeName in ('Page') 
 
 and g.GroupPublic = 1
 
 and g.GroupEnabled = 1
 and g.GroupID = 30
 and c.Category_ID = cat.CategoryID
 and cat.CategoryEnabled = 1
 and cat.CategoryName not in ('AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and c.CRGRoup_ID = cr.CRGroupID
 and cr.CRGroupEnabled = 1
 and cr.CRGroupName in ('Physical Activity in Child Care')
 and c.Category_ID = 183)

 union
 
 (select r.ResourceID, r.DateUploaded, r.LastUpdated, r.Title, r.FileSize, cat.CategoryID,
 r.Teaser, r.ListOrder, r.ServerFile, r.ClientFile, r.Author_ID, r.Approved, r.OnDate, r.OffDate, r.ServerFile
 from Resources r, CRGroups cr, Categories cat, Resources_Groups rg, Groups g
 where r.ResourceID = rg.Resource_ID
 and rg.Group_ID = g.GroupID
 and r.Display = 1
 
 and r.Approved = 1 
 and ({d '2018-02-06'} between r.OnDate and r.OffDate
 or ({d '2018-02-06'} >= r.OnDate and r.OnDate = r.OffDate))
 
 and YEAR (r.ReviewDate) > 2000
 
 and r.Archive = 0
 
 and g.GroupPublic = 1
 
 and g.GroupEnabled = 1
 and g.GroupID = 30
 and r.CRGroup_ID = cr.CRGroupID
 and cr.CRGroupEnabled = 1
 and r.Category_ID = cat.CategoryID 
 and cat.CategoryEnabled = 1
 and cat.CategoryName not in ('AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGroupName in ('Physical Activity in Child Care') 
 and cat.CategoryName in ('Child Care & Youth Camps')
 and r.Category_ID = 183)

 union

 (select wa.WebApplicationID, wr.DateUpdated, wr.DateUpdated, wr.WebAppRegMenuName, '', cr.CRGroupID, 
 wa.WebAppDescription, wa.ListOrder, '.app', '', '', '', wa.OnDate, wa.OffDate, '.app'
 from WebApplications wa, WebApplicationsRegister wr, Groups_WebApplications gw, Categories cat, CRGroups cr, Groups g
 where g.GroupEnabled = 1
 and wa.WebAppReg_ID = wr.WebAppRegID
 and gw.WebApplication_ID = wa.WebApplicationID
 and g.GroupID = gw.Group_ID
 and wr.WebAppRegEnabled = 1 
 and wr.WebAppRegPublic = 1
 
 and g.GroupPublic = 1
 
 and g.GroupEnabled = 1
 and g.GroupID = 30 
 and wa.CRGroup_ID = cr.CRGroupID
 and cr.CRGroupEnabled = 1
 and wa.Category_ID = cat.CategoryID
 and cat.CategoryEnabled = 1
 and cat.CategoryName not in ('AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGroupName in ('Physical Activity in Child Care')
 and wa.Category_ID = 183
 and ({d '2018-02-06'} between wa.OnDate and wa.OffDate
 or (wa.OnDate = wa.OffDate and {d '2018-02-06'} >= wa.OnDate)))

 order by 
 
 

 ListOrder DESC, DateAuthored DESC, ContentID DESC
GetApprover (Datasource=msdhsitenewdsn, Time=0ms, Records=1) in F:\inetpub\wwwroot\msdhsite\common\getReviewerForPage_module.cfm @ 10:39:38.038
 select u.FirstName, u.LastName, u.Email, u.UserID
 from Content c, Users u
 where u.UserID = c.Approver_ID
 and c.ContentID = 11055 
GetCatApprover (Datasource=msdhsitenewdsn, Time=0ms, Records=1) in F:\inetpub\wwwroot\msdhsite\common\getReviewerForPage_module.cfm @ 10:39:38.038
 select cat.Approver_ID, u.Email
 from Categories as cat, Users u
 where u.UserID = cat.Approver_ID
 and cat.CategoryID = 183 
ApproverIsReviewerQuery (Datasource=msdhsitenewdsn, Time=0ms, Records=0) in F:\inetpub\wwwroot\msdhsite\common\getReviewerForPage_module.cfm @ 10:39:38.038
 select Distinct(g.GroupID), g.GroupName, g.ListOrder
 from Groups g, Users_Groups ug
 where g.GroupID = ug.Group_ID
 and ug.User_ID = 62
 and g.GroupName in ('Reviewers')
 order by g.GroupName
GetContentBodyHTML (Datasource=msdhsitenewdsn, Time=16ms, Records=1) in F:\inetpub\wwwroot\msdhsite\_queries\contentbody_q1.cfm @ 10:39:38.038
 select ContentBodyHTML
 from Content
 where ContentID = 11055 
GetPageTypeContext (Datasource=msdhsitenewdsn, Time=0ms, Records=1) in F:\inetpub\wwwroot\msdhsite\_queries\dynamicinclude_q1.cfm @ 10:39:38.038
 select CategoryContext, CRGroupContext, PageContext
 from PageTypes
 where Enabled = 1 
 and PageTypeName in ('Feature Item');
GetContent (Datasource=msdhsitenewdsn, Time=0ms, Records=0) in F:\inetpub\wwwroot\msdhsite\_queries\dynamicinclude_q1.cfm @ 10:39:38.038
 select c.ContentID, c.DateAuthored, c.DateUpdated, c.ContentTitle, c.ContentTeaser, c.ContentBodyHTML, c.ClientImageFile, c.Approved, c.OnDate, c.OffDate,
 c.DisplayImage, c.Author_ID, c.ContentViews, c.PeriodViews, c.ListOrder, 
 pt.PageTypeName, pt.ShowTitle, pt.ShowTeaser, pt.ShowContentBodyHTML, pt.Searchable,
 u.FirstName, u.LastName, u.Email
 from Content c, Content_Groups cg, CRGroups cr, Categories cat, Groups g, PageTypes pt, Content_PageTypes cpt, Users u
 where g.GroupEnabled = 1
 and cat.CategoryEnabled = 1
 and cr.CRGroupEnabled = 1
 and c.ContentDisplay = 1
 
 and cat.CategoryName not in ('AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and c.Category_ID = cat.CategoryID
 
 and cat.CategoryID = 183 
 and c.CRGroup_ID = cr.CRGroupID
 
 and cr.CRGroupID = 526 
 and c.ContentID = cg.Content_ID
 and cg.Group_ID = g.GroupID
 
 and c.Approved = 1 
 and ({d '2018-02-06'} between c.OnDate and c.OffDate
 or ({d '2018-02-06'} >= c.OnDate and c.OnDate = c.OffDate))
 
 and c.Author_ID = u.UserID 
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30 
 and pt.PageTypeID = cpt.PageType_ID
 and cpt.Content_ID = c.ContentID 
 and pt.PageTypeName in ('Feature Item')
 order by c.ListOrder DESC,c. ContentID DESC
GetPageTypeContext (Datasource=msdhsitenewdsn, Time=0ms, Records=0) in F:\inetpub\wwwroot\msdhsite\_queries\dynamicinclude_q1.cfm @ 10:39:38.038
 select CategoryContext, CRGroupContext, PageContext
 from PageTypes
 where Enabled = 1 
 and PageTypeName in ('Footer');


Scope Variables

Application Variables:
acceptedfiletypes=pdf,jpg,gif,txt,zip,doc,xls,ppt,rtf,mp3,pps,dot,mov,docx,xlsx
adminemail=web@msdh.ms.gov
anlanguage=ENGLISH
antext=Struct (265)
appactions=savelogin,imgleft,subwebsmenu,newoff,infopagesoff,topresetoff,contextliston,pagedatesoff,filedatesoff,executecfml,formmailoff,summarymodeoff,menuleft,emailerroroff,searchon,nextoff,monfiles,dhtmlmenuon,exceperroroff,logerroroff,ENGLISH
applicationname=AssetNow_28ED30DC-C485-3E07-CF7B3E5165A6B75F
appname=AssetNow
companydescription=
companyname=Mississippi State Department of Health
custom_root=custom/
downloademail=web@msdh.ms.gov
downloadpath=_resources\
dsn=msdhsitenewdsn
encryptkey=62338386
erroremail=web@msdh.ms.gov
globalappid=28ED30DC-C485-3E07-CF7B3E5165A6B75F
imageloadpath=images/
infoemail=web@msdh.ms.gov
mailserver=relay.ms.gov
rootappname=AssetNow
rootid=4
server_rootpath=F:\inetpub\wwwroot\msdhsite\
site_root=/msdhsite/
siteapptitle=Mississippi State Department of Health
siteurl=msdh.ms.gov
supportemail=MSDHNews@msdh.ms.gov
useremail=web@msdh.ms.gov
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=F:\inetpub\wwwroot\msdhsite\index.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=
HTTP_ACCEPT_ENCODING=gzip,deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=msdh.ms.gov
HTTP_REFERER=
HTTP_URL=/msdhsite/index.cfm/30,0,183,526,html
HTTP_USER_AGENT=28ED30DC-C485-3E07-CF7B3E5165A6B75F
LOCAL_ADDR=10.121.1.213
PATH_INFO=/30,0,183,526,html
PATH_TRANSLATED=F:\inetpub\wwwroot\msdhsite\index.cfm
QUERY_STRING=
REMOTE_ADDR=10.121.1.213
REMOTE_HOST=10.121.1.213
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/msdhsite/index.cfm
SERVER_NAME=msdh.ms.gov
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Cookie Variables:
CFID=92413
CFSESSION=103937
CFTOKEN=7e5c574e33b7fe95-37DEDFEA-E818-CD87-237F7DB316CF77D2
Server Variables:
coldfusion=Struct (10)
os=Struct (5)
Session Variables:
cfid=92413
cftoken=7e5c574e33b7fe95-37DEDFEA-E818-CD87-237F7DB316CF77D2
groupid=30
groupname=Regulation & Licensure
sessionid=ASSETNOW_28ED30DC-C485-3E07-CF7B3E5165A6B75F_92413_7e5c574e33b7fe95-37DEDFEA-E818-CD87-237F7DB316CF77D2
urltoken=CFID=92413&CFTOKEN=7e5c574e33b7fe95-37DEDFEA-E818-CD87-237F7DB316CF77D2
URL Parameters:
ANRESOURCE=30,0,183,526,html
CONTENTID=11055
CRDescription=
CRGroupID=526
Category=Physical Activity in Child Care
CategoryDescription=
CategoryID=183
CategoryName=Child Care & Youth Camps
ContentType=html
GID=30
GKW=
GN=Regulation & Licensure
GND=Regulation of health professionals and health facilities such as hospitals, nursing homes, and child care
GPP=1
Debug Rendering Time: 16 ms