SELECT e.*, d.DioceseName, (select ProvinceName from Province p where p.Province = e.Province) as ProvinceName, (select CodeDesc from Lookups l where l.CodeGroup = 'AUDIENCE' AND l.CodeValue = e.Audience) as AudienceName from Events e LEFT OUTER JOIN Diocese d ON (d.DioceseID = e.Diocese) WHERE EventID = #URL.EventID# AND SiteID = 1 AND DateApproved is not NULL SELECT * From SubSites WHERE SiteID = 1 Episcopal Church Calendar Events
SELECT CodeDesc From Lookups WHERE CodeGroup = 'EVENT' AND ( CodeValue = '#KTerm#' OR ) ORDER BY CodeDesc

#EventName#

Event Date: #DateFormat(BeginDate, "mmm d, yyyy")# #TimeFormat(BeginDate, "h:mm tt")# - #DateFormat(EndDate, "mmm d, yyyy")# #TimeFormat(EndDate, "h:mm tt")# -- Cancelled --
Region: #ProvinceName#: Diocese of #DioceseName#
Location: #Location# in #City#, #State#
Contact: #Contact##Contact# at #phone# FAX #FAX#
Web Link: #WebURL#

Event Cancellation Information:

#Replace(description,"#chr(13)##chr(10)#","
","ALL")#


Original Event Details:

#Replace(NewMessage,"#chr(13)##chr(10)#","
","ALL")#


Event Categories: #ValueList(CatList.CodeDesc)#
Event Audience: #AudienceName#



RETURN