Calendar

Query failed: SELECT ca.EventID AS EventID, ca.StartDate AS StartDate, ca.EndDate AS EndDate, de.Name AS DepartmentName, se.SeminarTitle AS SeminarTitle, ca.Title AS Title, ca.Location AS Location, ca.Contact AS Contact, ca.ContactPhone AS ContactPhone, CAST(ca.Description AS TEXT) AS Description, sp.FirstName AS SpeakerFirst, sp.LastName AS SpeakerLast, sp.Title AS SpeakerSuffix, sp.Affiliation AS SpeakerAffiliation, sp.FullTitle AS SpeakerTitle FROM Calendar_Web ca LEFT JOIN Calendar_Department de ON ca.DepartmentID = de.DepartmentID LEFT JOIN Calendar_Seminar se ON ca.LectureID = se.SeminarID LEFT JOIN Calendar_Speaker sp ON ca.EventID = sp.EventID WHERE ca.Active = 1 AND (ca.DepartmentID = '66') AND MONTH(ca.StartDate) = '05' AND YEAR(ca.StartDate) = '2013' ORDER BY StartDate