Calendars and Public Meetings
This page has been automatically translated from English. MSDH has not reviewed this translation and is not responsible for any inaccuracies.
select CategoryID from Categories
select ContentID, ContentTitle, ContentTeaser, DateAuthored, ContentDisplay
from Content c, Content_Groups cg, Groups g, Content_Pagetypes cp
where c.Category_ID = #event_category_ID#
and cp.PageType_ID = 4
and cp.Content_ID = c.ContentID
and cg.Content_ID = c.ContentID
and cg.Group_ID = g.GroupID
and g.GroupName = 'News, Events & Alerts'
and c.ContentDisplay = 1
and ((c.OnDate = c.OffDate) OR (#todaysDate# < c.OffDate))
order by c.OffDate ASC
Get health alerts and our free newsletter by e-mail:
Last reviewed on Jul 23, 2003