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
Last reviewed on Jul 23, 2003
Get COVID-19 e-mail updates daily with our free newsletter: