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]

About the Child Care Licensure Branch

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

Licensing and Inspection

The Child Care Facilities Licensure Branch and its staff:

  • inspect and license day care facilities and youth camps
  • monitor child residential homes
  • investigate complaints related to licensed child care facilities and providers
  • make inquiries into reports regarding unlicensed facilities
  • hold administrative hearings related to child care licensure

Inspections include, but are not limited to, a program review consisting of the care-giver's records check, children's records checks, immunization records checks, facility policies, facility program content, and building and grounds safety.

Training

Staff provides in-service training to child care providers throughout the state on a regular basis. In addition to the mandatory trainings, which include Child Care Regulations and Licensing, Playground Safety, and Directors' Orientation, sessions are available which address child abuse and child neglect identification and reporting, appropriate discipline and guidance, nutrition and menu planning, hand-washing and sanitation, physical activity in child care facilities, and classes specifically related to the development of infants and toddlers. The agency offers all staff development training to providers at no cost.

Contact

Child Care Licensure Division: (601) 364-2827

Location

143B Lefleur's Square
Jackson, MS

Get health alerts and our free newsletter by e-mail: 
Last reviewed on May 9, 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=0ms, Records=1) in F:\inetpub\wwwroot\msdhsite\Application.cfm @ 10:39:28.028
 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:28.028
 select Distinct GroupName, GroupDescription, GroupKeywords, GroupPublic
 from Groups 
 where GroupEnabled = 1
 and GroupID = 30 
 and GroupPublic = 1
 
GetCategoryName (Datasource=msdhsitenewdsn, Time=16ms, Records=1) in F:\inetpub\wwwroot\msdhsite\urlmapping.cfm @ 10:39:28.028
 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:28.028
 select CRGroupName, CRDescription
 from CRGroups
 where CRGroupEnabled = 1
 and CRGroupName not in ('None')
 and CRGroupID = 61 
GetLayout (Datasource=msdhsitenewdsn, Time=0ms, Records=1) in F:\inetpub\wwwroot\msdhsite\_queries\layout_q1.cfm @ 10:39:28.028
 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:28.028
 select CategoryContext, CRGroupContext, PageContext
 from PageTypes
 where Enabled = 1 
 and PageTypeName in ('Header');
GetCategories (Datasource=msdhsitenewdsn, Time=78ms, Records=22) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q2.cfm @ 10:39:28.028
 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:28.028
 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=0ms, Records=1) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:28.028
 (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:28.028
 (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:28.028
 (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=16ms, Records=15) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:28.028
 (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:28.028
 (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=0ms, Records=0) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:28.028
 (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=15ms, Records=0) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:28.028
 (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:28.028
 (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=0ms, Records=7) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:28.028
 (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=16ms, Records=12) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:28.028
 (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=0ms, Records=0) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:28.028
 (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=16ms, Records=1) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:28.028
 (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:28.028
 (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=15ms, Records=9) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:28.028
 (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:28.028
 (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=0ms, Records=7) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:28.028
 (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=16ms, Records=0) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:28.028
 (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:28.028
 (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=15ms, Records=3) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:28.028
 (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:28.028
 (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:28.028
 (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:28.028
 (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=63ms, Records=0) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q5.cfm @ 10:39:28.028
 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=93ms, Records=1) in F:\inetpub\wwwroot\msdhsite\_queries\handler3_q1.cfm @ 10:39:29.029
 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 ('About Us')
 
 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=312ms, Records=0) in F:\inetpub\wwwroot\msdhsite\_queries\handler3_q2.cfm @ 10:39:29.029
 (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 ('About Us')
 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 ('About Us') 
 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 ('About Us')
 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=16ms, Records=1) in F:\inetpub\wwwroot\msdhsite\common\getReviewerForPage_module.cfm @ 10:39:29.029
 select u.FirstName, u.LastName, u.Email, u.UserID
 from Content c, Users u
 where u.UserID = c.Approver_ID
 and c.ContentID = 289 
GetCatApprover (Datasource=msdhsitenewdsn, Time=0ms, Records=1) in F:\inetpub\wwwroot\msdhsite\common\getReviewerForPage_module.cfm @ 10:39:29.029
 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:29.029
 select Distinct(g.GroupID), g.GroupName, g.ListOrder
 from Groups g, Users_Groups ug
 where g.GroupID = ug.Group_ID
 and ug.User_ID = 1
 and g.GroupName in ('Reviewers')
 order by g.GroupName
GetContentBodyHTML (Datasource=msdhsitenewdsn, Time=0ms, Records=1) in F:\inetpub\wwwroot\msdhsite\_queries\contentbody_q1.cfm @ 10:39:29.029
 select ContentBodyHTML
 from Content
 where ContentID = 289 
GetPageTypeContext (Datasource=msdhsitenewdsn, Time=16ms, Records=1) in F:\inetpub\wwwroot\msdhsite\_queries\dynamicinclude_q1.cfm @ 10:39:29.029
 select CategoryContext, CRGroupContext, PageContext
 from PageTypes
 where Enabled = 1 
 and PageTypeName in ('Feature Item');
GetContent (Datasource=msdhsitenewdsn, Time=93ms, Records=0) in F:\inetpub\wwwroot\msdhsite\_queries\dynamicinclude_q1.cfm @ 10:39:29.029
 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 = 61 
 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:29.029
 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,61,html
HTTP_USER_AGENT=28ED30DC-C485-3E07-CF7B3E5165A6B75F
LOCAL_ADDR=10.121.1.213
PATH_INFO=/30,0,183,61,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=92407
CFSESSION=103928
CFTOKEN=8c3f2cd88e53b553-37DD7A1A-BE71-7452-F9E2D5D9A1656F77
Server Variables:
coldfusion=Struct (10)
os=Struct (5)
Session Variables:
cfid=92407
cftoken=8c3f2cd88e53b553-37DD7A1A-BE71-7452-F9E2D5D9A1656F77
groupid=30
groupname=Regulation & Licensure
sessionid=ASSETNOW_28ED30DC-C485-3E07-CF7B3E5165A6B75F_92407_8c3f2cd88e53b553-37DD7A1A-BE71-7452-F9E2D5D9A1656F77
urltoken=CFID=92407&CFTOKEN=8c3f2cd88e53b553-37DD7A1A-BE71-7452-F9E2D5D9A1656F77
URL Parameters:
ANRESOURCE=30,0,183,61,html
CONTENTID=289
CRDescription=
CRGroupID=61
Category=About Us
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: 0 ms