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]

Care for Their Air: Secondhand Smoke Education

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

Care for Their Air is free education for child care providers about the harmful effects of exposure to secondhand smoke.

This training curriculum was developed for child care directors and staff who work closely with parents, children, and babies.

Get health alerts and our free newsletter by e-mail: 
Last reviewed on May 10, 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:52.052
 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:52.052
 select Distinct GroupName, GroupDescription, GroupKeywords, GroupPublic
 from Groups 
 where GroupEnabled = 1
 and GroupID = 30 
 and GroupPublic = 1
 
GetContentTitle (Datasource=msdhsitenewdsn, Time=15ms, Records=1) in F:\inetpub\wwwroot\msdhsite\urlmapping.cfm @ 10:39:52.052
 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 = 18791;
 
GetCategoryName (Datasource=msdhsitenewdsn, Time=0ms, Records=1) in F:\inetpub\wwwroot\msdhsite\urlmapping.cfm @ 10:39:52.052
 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:52.052
 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:52.052
 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:52.052
 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:52.052
 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:52.052
 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:52.052
 (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:52.052
 (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=15ms, Records=12) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:52.052
 (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:52.052
 (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:52.052
 (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:52.052
 (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:52.052
 (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:52.052
 (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:52.052
 (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:52.052
 (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:52.052
 (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:52.052
 (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=15ms, Records=1) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:52.052
 (select cr.CRGroupID as ContentGroup, cr.CRGroupName as ContentCategory, cr.CRDescription as Description, cr.ListOrder as ListOrder, 101 as CategoryID, 'Newborn Screening' as CategoryName
 from Content c, CRGroups cr, Content_Groups cg, Groups g, Categories cat, PageTypes pt, Content_PageTypes cpt 
 where g.GroupEnabled = 1
 and c.CRGRoup_ID = cr.CRGroupID
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30
 and c.ContentID = cg.Content_ID
 and cg.Group_ID = g.GroupID
 and c.ContentDisplay = 1
 
 and c.Approved = 1 
 and ({d '2018-02-06'} between c.OnDate and c.OffDate
 or (c.OnDate = c.OffDate and {d '2018-02-06'} >= c.OnDate))
 
 and YEAR (c.ReviewDate) > 2000
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGroupName not in ('None')
 and pt.PageTypeID = cpt.PageType_ID
 and cpt.Content_ID = c.ContentID 
 and pt.PageTypeName in ('Feature Page','Page')
 and cat.CategoryID = c.Category_ID
 and cat.CategoryEnabled = 1 
 and cat.CategoryID = 101)
 
 union
 
 (select cr.CRGroupID, cr.CRGroupName, cr.CRDescription, cr.ListOrder, 101, 'Newborn Screening'
 from Resources r, CRGroups cr, Categories cat, Resources_Groups rg, Groups g 
 where g.GroupEnabled = 1
 and r.CRGroup_ID = cr.CRGroupID 
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 
 and YEAR (r.ReviewDate) > 2000
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30 
 and r.ResourceID = rg.Resource_ID
 and rg.Group_ID = g.GroupID
 and r.Display = 1
 and r.Archive = 0
 
 and r.Approved = 1 
 and ({d '2018-02-06'} between r.OnDate and r.OffDate
 or (r.OnDate = r.OffDate and {d '2018-02-06'} >= r.OnDate))
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGRoupName not in ('None')
 and cat.CategoryID = r.Category_ID
 and cat.CategoryEnabled = 1
 and cat.CategoryID = 101)
 

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

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

 order by ContentCategory, ContentGroup DESC
ListContent (Datasource=msdhsitenewdsn, Time=62ms, Records=0) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q5.cfm @ 10:39: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 = 18791 
GetContextContent (Datasource=msdhsitenewdsn, Time=78ms, 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=16ms, 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 = 18791 
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=1) 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 = 5534
 and g.GroupName in ('Reviewers')
 order by g.GroupName
GetPageTypeContext (Datasource=msdhsitenewdsn, Time=15ms, 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,18791,183,437,html
HTTP_USER_AGENT=28ED30DC-C485-3E07-CF7B3E5165A6B75F
LOCAL_ADDR=10.121.1.213
PATH_INFO=/30,18791,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=92429
CFSESSION=103952
CFTOKEN=ba58e9fe47aa467f-37E119A5-D752-4AA5-A89818777BEE9FB3
Server Variables:
coldfusion=Struct (10)
os=Struct (5)
Session Variables:
cfid=92429
cftoken=ba58e9fe47aa467f-37E119A5-D752-4AA5-A89818777BEE9FB3
groupid=30
groupname=Regulation & Licensure
sessionid=ASSETNOW_28ED30DC-C485-3E07-CF7B3E5165A6B75F_92429_ba58e9fe47aa467f-37E119A5-D752-4AA5-A89818777BEE9FB3
urltoken=CFID=92429&CFTOKEN=ba58e9fe47aa467f-37E119A5-D752-4AA5-A89818777BEE9FB3
URL Parameters:
ANRESOURCE=30,18791,183,437,html
CRDescription=
CRGroupID=437
Category=Provider Training
CategoryDescription=
CategoryID=183
CategoryName=Child Care & Youth Camps
ContentID=18791
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=Care for Their Air: Secondhand Smoke Education
Debug Rendering Time: 0 ms