SELECT Top(4) EventID, ISNULL(b.EventName + ISNULL('
' + e.Subtitle, ''), e.EventName + ISNULL('
' + e.Subtitle, '')) AS EventName, dbo.Elipse(ISNULL(e.Notes, ''), 100) As Notes, CASE WHEN LEN(ISNULL(e.Notes, '')) > 100 THEN 1 ELSE 0 END AS More, ISNULL(e.PhotoGalleryCategoryID, 0) AS CatID, e.PhotoGalleryCategoryID, URL FROM EventsNews e LEFT JOIN ems_Booking b ON b.ID = e.ems_BookingID WHERE dbo.WebArea(e.Webpages, 'HO') = 1 AND e.IsNews = 1 AND GetDate() BETWEEN e.PublishDate AND e.ExpireDate AND e.Active = 1 ORDER BY ISNULL(DisplayOrder, 0), ISNULL(b.TimeEventStart, e.PublishDate), EventName
Holy Spirit Catholic Church