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]

Choosing a Child Care Provider

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

This page will help you select the right kind of child care based on your needs and those of your child.

Choosing a Caregiver

  • What sort of person is your caregiver? A good caregiver should be well-trained, warm and loving toward children.
  • Whether your child is an infant, toddler, preschooler or school-ager, the caregiver should encourage the child's interests and stimulate the child to explore and discover new things.
  • Whether you use in-home care, family day care, or center care, the facilities should be safe and healthy.
  • The equipment - games, toys and furniture - should be in good repair and appropriate for your child.
  • The number of children in your child's group should be small enough to allow your child to receive individual attention.
  • What will the cost of care be? Day care costs can vary widely, depending on the type of care you use, the days and hours you need care, the part of the state you live in, and other factors. You should investigate the costs of different kinds of day care available, including the costs of transportation for your child to and from the day care setting.
  • Any kind of day care can be good for your child if the care provides the warmth, supervision and individual attention your child needs. In fact, you may want to use more than one kind of care for your children - for example, in-home care for your infant and center-based care for your preschooler.

Types of Child Care Facilities

In-Home Care

An in-home caregiver is someone who comes to, or lives in, your home. The caregiver can be a relative or a friend or can also be someone you pay to come to your home. If you have three or more children needing care, in-home care may be less expensive than other kinds of care. It can also save you from the worry of getting several children, all with different schedules, to and from a day care arrangement outside your home.

You may also want to use in-home care if your child needs special care because of a physical, mental or emotional problem; if you need care for an infant or toddler, or care for a child at night; if you need only after-school care. You should know, however, that in-home care can be costly, especially if you have only one or two children and are paying someone for full-time care. In interviewing in-home caregivers, you'll want to find out about their training and experience, their attitude toward children, and their ability to handle children who disobey.

Family Day Care

This kind of day care is provided in the home of the caregiver, who is often a mother with children of her own. You may find a relative, friend or neighbor who is willing to care for your child in this way. Or you may find a family day care home run by someone you do not already know.

Family day care can be a good arrangement: if you are a single parent raising a child alone; if you live in a rural area where family day care is likely to be the easiest to find; if you have only one or two children needing care; if you have a school-age child.

Keep in mind that a family day care provider may go out of business or stop caring for children at any time. And because many of these homes are not inspected or licensed by local or State agencies, it will be up to you to make sure that adequate health and safety standards are met.

Center-Based Care

Day care centers are established settings where children are cared for in a group away from their homes for all or part of the day. There are many different kinds of center-based care, including nursery schools, preschools, and parent cooperatives. Some of these centers are set up primarily to keep children safe and secure; others are designed to prepare children for their school years. Center-based care is most frequently available in a town or city.

Many day care centers have an organized program of activities to help children learn. Some centers follow a formal plan, perhaps one developed by a well-known educator. Others use a more informal program based on their day-to-day experience working with children.

You may be interested in center-based care: if you want to keep your child in the same day care setting for an extended period; if your child needs special care because of a physical or mental handicap or an emotional problem; if you want certain educational or religious activities for your child.

Keep in mind that center-based care may not provide the "home" atmosphere some children like. Your child may not be comfortable in a large group for a major part of each day.

In considering a particular day care center, check out the facilities available, the qualifications of the staff, and the number of children cared for by each caregiver (the "child/staff ratio"). Talk to the director to make sure the center's program has the approach you like and includes the kinds of activities you want for your child.

Safety and Health

Child care settings should offer a variety of activities for your child, both alone and with other children. Activities and their setting must be designed for safety.

  • What kind of playground is available? Look for fences around outdoor areas and well-constructed equipment with soft landing places made of sand or wood chips under swings and slides.
  • Emergencies: are poison control and ambulance phone numbers clearly posted?
  • Are there smoke alarms throughout the building?
  • Are the toys kept clean? Washable toys should be washed every day with a disinfectant cleaner.
  • Does the staff regularly clean all surfaces with a disinfectant?
  • Children and adults should wash their hands before eating, after touching their mouths and noses, and after toileting. The staff should wash before feeding, handling food, diapering, and washing surfaces. Hand washing is the most important line of defense against the spread of infectious disease.
  • Are the children protected from strangers? Clearly establish with the caregiver the identity of the parent or guardian responsible for picking up the child.

Activities and Environment

Look at the child care program from the perspective of your child:

  • Are there plenty of toys, games, and arts and crafts material?
  • Are the toys and materials easy to see and reach?
  • Is the center bright and cheerful?
  • Are the children there absorbed in what they are doing? Listen for the sounds of children talking and playing. Do they sound happy?
  • Are adults talking to the children respectfully, encouraging them to ask questions and express themselves?
  • Are the caregivers talking to, singing to, and holding infants? Do they move to the floor to play with toddlers and preschoolers?
  • Are the caregivers helping school age children develop skills, talents and creativity?
  • What are the center's policies on discipline?
  • Does the center keep its policies in writing?

After you have selected a child care program, your job is not over. Remain involved. Talk regularly with your child care provider about activities, your child's development and behavior, and any other concerns you, your caregiver, or your child may have. Drop in on the program at different times and assess how things are going.

Regulations and Other Information

For regulations and licensing concerning Child Care Providers, see our Child Care Providers regulations section.

For other child care provider information, see the listings at the bottom of this page.

Get In Touch - Find Out More

To learn more about child care and child care providers, contact your local health office, or call the Health Info Hotline at 1-866-HLTHY4U (1-866-458-4948).

Subscribe to our free newsletter and health alerts: 
Last reviewed on May 9, 2017

Related resources

pdf To view/print pdf documentation you will need Adobe Reader
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:46.046
 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:46.046
 select Distinct GroupName, GroupDescription, GroupKeywords, GroupPublic
 from Groups 
 where GroupEnabled = 1
 and GroupID = 30 
 and GroupPublic = 1
 
GetCategoryName (Datasource=msdhsitenewdsn, Time=0ms, Records=1) in F:\inetpub\wwwroot\msdhsite\urlmapping.cfm @ 10:39:46.046
 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:46.046
 select CRGroupName, CRDescription
 from CRGroups
 where CRGroupEnabled = 1
 and CRGroupName not in ('None')
 and CRGroupID = 742 
GetLayout (Datasource=msdhsitenewdsn, Time=16ms, Records=1) in F:\inetpub\wwwroot\msdhsite\_queries\layout_q1.cfm @ 10:39:46.046
 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:46.046
 select CategoryContext, CRGroupContext, PageContext
 from PageTypes
 where Enabled = 1 
 and PageTypeName in ('Header');
GetCategories (Datasource=msdhsitenewdsn, Time=78ms, Records=22) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q2.cfm @ 10:39:46.046
 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:46.046
 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:46.046
 (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:46.046
 (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=31ms, Records=12) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:46.046
 (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:46.046
 (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=16ms, Records=0) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:46.046
 (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:46.046
 (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:46.046
 (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=15ms, Records=2) in F:\inetpub\wwwroot\msdhsite\_queries\dmenu_q4.cfm @ 10:39:46.046
 (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:46.046
 (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:46.046
 (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:46.046
 (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:46.046
 (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:46.046
 (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:46.046
 (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:46.046
 (select cr.CRGroupID as ContentGroup, cr.CRGroupName as ContentCategory, cr.CRDescription as Description, cr.ListOrder as ListOrder, 82 as CategoryID, 'Professional Licensure' as CategoryName
 from Content c, CRGroups cr, Content_Groups cg, Groups g, Categories cat, PageTypes pt, Content_PageTypes cpt 
 where g.GroupEnabled = 1
 and c.CRGRoup_ID = cr.CRGroupID
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30
 and c.ContentID = cg.Content_ID
 and cg.Group_ID = g.GroupID
 and c.ContentDisplay = 1
 
 and c.Approved = 1 
 and ({d '2018-02-06'} between c.OnDate and c.OffDate
 or (c.OnDate = c.OffDate and {d '2018-02-06'} >= c.OnDate))
 
 and YEAR (c.ReviewDate) > 2000
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGroupName not in ('None')
 and pt.PageTypeID = cpt.PageType_ID
 and cpt.Content_ID = c.ContentID 
 and pt.PageTypeName in ('Feature Page','Page')
 and cat.CategoryID = c.Category_ID
 and cat.CategoryEnabled = 1 
 and cat.CategoryID = 82)
 
 union
 
 (select cr.CRGroupID, cr.CRGroupName, cr.CRDescription, cr.ListOrder, 82, 'Professional Licensure'
 from Resources r, CRGroups cr, Categories cat, Resources_Groups rg, Groups g 
 where g.GroupEnabled = 1
 and r.CRGroup_ID = cr.CRGroupID 
 and cr.CRGroupEnabled = 1
 AND cr.Visible = 1
 and ({d '2018-02-06'} between g.OnDate and g.OffDate
 or (g.OnDate = g.OffDate and {d '2018-02-06'} >= g.OnDate))
 
 
 and YEAR (r.ReviewDate) > 2000
 
 and g.GroupPublic = 1
 
 and g.GroupID = 30 
 and r.ResourceID = rg.Resource_ID
 and rg.Group_ID = g.GroupID
 and r.Display = 1
 and r.Archive = 0
 
 and r.Approved = 1 
 and ({d '2018-02-06'} between r.OnDate and r.OffDate
 or (r.OnDate = r.OffDate and {d '2018-02-06'} >= r.OnDate))
 
 and cat.CategoryName not in ('None','AssetNow User Guide','AssetNow Image Library','AssetNow Resource Library') 
 and cr.CRGRoupName not in ('None')
 and cat.CategoryID = r.Category_ID
 and cat.CategoryEnabled = 1
 and cat.CategoryID = 82)
 

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

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

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

 union

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

 order by 
 
 

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


Scope Variables

Application Variables:
acceptedfiletypes=pdf,jpg,gif,txt,zip,doc,xls,ppt,rtf,mp3,pps,dot,mov,docx,xlsx
adminemail=web@msdh.ms.gov
anlanguage=ENGLISH
antext=Struct (265)
appactions=savelogin,imgleft,subwebsmenu,newoff,infopagesoff,topresetoff,contextliston,pagedatesoff,filedatesoff,executecfml,formmailoff,summarymodeoff,menuleft,emailerroroff,searchon,nextoff,monfiles,dhtmlmenuon,exceperroroff,logerroroff,ENGLISH
applicationname=AssetNow_28ED30DC-C485-3E07-CF7B3E5165A6B75F
appname=AssetNow
companydescription=
companyname=Mississippi State Department of Health
custom_root=custom/
downloademail=web@msdh.ms.gov
downloadpath=_resources\
dsn=msdhsitenewdsn
encryptkey=62338386
erroremail=web@msdh.ms.gov
globalappid=28ED30DC-C485-3E07-CF7B3E5165A6B75F
imageloadpath=images/
infoemail=web@msdh.ms.gov
mailserver=relay.ms.gov
rootappname=AssetNow
rootid=4
server_rootpath=F:\inetpub\wwwroot\msdhsite\
site_root=/msdhsite/
siteapptitle=Mississippi State Department of Health
siteurl=msdh.ms.gov
supportemail=MSDHNews@msdh.ms.gov
useremail=web@msdh.ms.gov
CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=F:\inetpub\wwwroot\msdhsite\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=
HTTP_ACCEPT_ENCODING=gzip,deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=msdh.ms.gov
HTTP_REFERER=
HTTP_URL=/msdhsite/index.cfm/30,0,183,742,html
HTTP_USER_AGENT=28ED30DC-C485-3E07-CF7B3E5165A6B75F
LOCAL_ADDR=10.121.1.213
PATH_INFO=/30,0,183,742,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=92422
CFSESSION=103946
CFTOKEN=906c709cb17ab801-37E034BB-042A-9990-CD7076701FE23A8C
Server Variables:
coldfusion=Struct (10)
os=Struct (5)
Session Variables:
cfid=92422
cftoken=906c709cb17ab801-37E034BB-042A-9990-CD7076701FE23A8C
groupid=30
groupname=Regulation & Licensure
sessionid=ASSETNOW_28ED30DC-C485-3E07-CF7B3E5165A6B75F_92422_906c709cb17ab801-37E034BB-042A-9990-CD7076701FE23A8C
urltoken=CFID=92422&CFTOKEN=906c709cb17ab801-37E034BB-042A-9990-CD7076701FE23A8C
URL Parameters:
ANRESOURCE=30,0,183,742,html
CONTENTID=972
CRDescription=
CRGroupID=742
Category=Choosing Child Care
CategoryDescription=
CategoryID=183
CategoryName=Child Care & Youth Camps
ContentType=html
GID=30
GKW=
GN=Regulation & Licensure
GND=Regulation of health professionals and health facilities such as hospitals, nursing homes, and child care
GPP=1
Debug Rendering Time: 16 ms