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]

Cavity-Free Kids Training

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

Cavity Free Kids is a free train-the-trainer oral health curriculum that provides education about dental cavities and how they can be prevented.

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=0ms, Records=1) in F:\inetpub\wwwroot\msdhsite\Application.cfm @ 10:39:51.051
 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=15ms, Records=1) in F:\inetpub\wwwroot\msdhsite\urlmapping.cfm @ 10:39:51.051
 select Distinct GroupName, GroupDescription, GroupKeywords, GroupPublic
 from Groups 
 where GroupEnabled = 1
 and GroupID = 30 
 and GroupPublic = 1
 
GetContentTitle (Datasource=msdhsitenewdsn, Time=16ms, Records=1) in F:\inetpub\wwwroot\msdhsite\urlmapping.cfm @ 10:39:51.051
 select c.ContentTitle, c.ContentTeaser
 from Content c, Content_PageTypes cpt, PageTypes pt
 where c.ContentDisplay = 1
 and c.Approved = 1
 and c.contentID = cpt.Content_ID
 and cpt.PageType_ID = pt.PageTypeID
 and pt.Enabled = 1
 and pt.Searchable = 1
 and c.ContentID = 10001;
 
GetCategoryName (Datasource=msdhsitenewdsn, Time=0ms, Records=1) in F:\inetpub\wwwroot\msdhsite\urlmapping.cfm @ 10:39:51.051
 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:51.051
 select CRGroupName, CRDescription
 from CRGroups
 where CRGroupEnabled = 1
 and CRGroupName not in ('None')
 and CRGroupID = 437 
GetLayout (Datasource=msdhsitenewdsn, Time=0ms, Records=1) in F:\inetpub\wwwroot\msdhsite\_queries\layout_q1.cfm @ 10:39:51.051
 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:51.051
 select CategoryContext, CRGroupContext, PageContext
 from PageTypes
 where Enabled = 1 
 and PageTypeName in ('Header');
GetCategories (Datasource=msdhsitenewdsn, Time=62ms, Records=22) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q2.cfm @ 10:39:51.051
 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:51.051
 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:51.051
 (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:51.051
 (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=32ms, Records=12) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:51.051
 (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=0ms, Records=15) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:51.051
 (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=15ms, Records=0) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:51.051
 (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:51.051
 (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:51.051
 (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=16ms, Records=2) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:51.051
 (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:51.051
 (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:51.051
 (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:51.051
 (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:51.051
 (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:51.051
 (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=0ms, Records=9) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:51.051
 (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:51.051
 (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:51.051
 (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=15ms, Records=0) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:51.051
 (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:51.051
 (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:51.051
 (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=16ms, Records=1) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:51.051
 (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=0ms, Records=11) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:51.051
 (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=16ms, Records=1) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:51.051
 (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=46ms, Records=0) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q5.cfm @ 10:39:52.052
 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=63ms, Records=1) in F:\inetpub\wwwroot\msdhsite\_queries\handler4_q1.cfm @ 10:39:52.052
 select c.ContentID, c.DateAuthored, c.DateUpdated, c.DateApproved, c.ContentTitle, c.ContentTeaser, c.ContentBodyHTML, c.ClientImageFile, c.Approved, c.OnDate, c.OffDate,
 c.DisplayImage, c.Author_ID, c.Category_ID, pt.PageTypeName, c.ContentViews, c.PeriodViews, c.ListOrder, u.FirstName, u.LastName, u.Email, cg.Group_ID
 from Content c, Content_Groups cg, CRGroups cr, Categories cat, Groups g, PageTypes pt, Content_PageTypes cpt, Users u
 where c.ContentID = cg.Content_ID
 and c.CRGroup_ID = cr.CRGroupID 
 and cr.CRGroupEnabled = 1
 
 and cr.CRGroupID = 437 
 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 c.Author_ID = u.UserID 

 
 and g.GroupID = 30 
 and g.GroupEnabled = 1
 and cg.Group_ID = g.GroupID

 
 and g.GroupPublic = 1
 
 and YEAR (c.ReviewDate) > 2000
 

 and pt.PageTypeID = cpt.PageType_ID
 and cpt.Content_ID = c.ContentID 
 and pt.Searchable = 1 
 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.ContentID = 10001 
GetContextContent (Datasource=msdhsitenewdsn, Time=94ms, Records=2) in F:\inetpub\wwwroot\msdhsite\_queries\handler4_q2.cfm @ 10:39:52.052
 select c.ContentID, c.ContentTitle, c.ContentTeaser, c.ListOrder, c.DateAuthored, c.Category_ID
 from Content c, Content_Groups cg, CRGroups cr, Categories cat, 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 ({d '2018-02-06'} >= c.OnDate and c.OnDate = c.OffDate))
 
 and g.GroupEnabled = 1
 
 and g.GroupPublic = 1
 
 and cat.CategoryEnabled = 1 
 and cr.CRGroupEnabled = 1 
 and g.GroupID = 30 
 and cat.CategoryID = 183 
 and cr.CRGroupID = 437 
 and YEAR (c.ReviewDate) > 2000
 
 
 and pt.Searchable = 1
 and c.CRGroup_ID = cr.CRGroupID 
 and c.Category_ID = cat.CategoryID
 and pt.PageTypeName in ('Page')
 and pt.PageTypeName not in ('Archive') 
 and pt.PageTypeID = cpt.PageType_ID
 and cpt.Content_ID = c.ContentID 
 and c.ContentID = cg.Content_ID
 and cg.Group_ID = g.GroupID
 order by c.ListOrder DESC, c.DateAuthored DESC, c.ContentID DESC
GetApprover (Datasource=msdhsitenewdsn, Time=15ms, Records=1) in F:\inetpub\wwwroot\msdhsite\common\getReviewerForPage_module.cfm @ 10:39:52.052
 select u.FirstName, u.LastName, u.Email, u.UserID
 from Content c, Users u
 where u.UserID = c.Approver_ID
 and c.ContentID = 10001 
GetCatApprover (Datasource=msdhsitenewdsn, Time=0ms, Records=1) in F:\inetpub\wwwroot\msdhsite\common\getReviewerForPage_module.cfm @ 10:39:52.052
 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:52.052
 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
GetPageTypeContext (Datasource=msdhsitenewdsn, Time=0ms, Records=0) in F:\inetpub\wwwroot\msdhsite\_queries\dynamicinclude_q1.cfm @ 10:39:52.052
 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,10001,183,437,html
HTTP_USER_AGENT=28ED30DC-C485-3E07-CF7B3E5165A6B75F
LOCAL_ADDR=10.121.1.213
PATH_INFO=/30,10001,183,437,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=92428
CFSESSION=103951
CFTOKEN=ce1ada55bd7bca04-37E0FD05-FE92-BA1F-047B6F950CAE4D5B
Server Variables:
coldfusion=Struct (10)
os=Struct (5)
Session Variables:
cfid=92428
cftoken=ce1ada55bd7bca04-37E0FD05-FE92-BA1F-047B6F950CAE4D5B
groupid=30
groupname=Regulation & Licensure
sessionid=ASSETNOW_28ED30DC-C485-3E07-CF7B3E5165A6B75F_92428_ce1ada55bd7bca04-37E0FD05-FE92-BA1F-047B6F950CAE4D5B
urltoken=CFID=92428&CFTOKEN=ce1ada55bd7bca04-37E0FD05-FE92-BA1F-047B6F950CAE4D5B
URL Parameters:
ANRESOURCE=30,10001,183,437,html
CRDescription=
CRGroupID=437
Category=Provider Training
CategoryDescription=
CategoryID=183
CategoryName=Child Care & Youth Camps
ContentID=10001
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
ThisPageDescription=
ThisPageTitle=Cavity-Free Kids Training
Debug Rendering Time: 16 ms