Training/Certification
Special Areas
Upcoming Events
select CategoryID from Categories
where CategoryName='Events'
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
