SQL to check events linked to this course: SELECT EventID, EventName, StartDate, EndDate, Cancelled, WebCategory, Venue, AccredNum FROM SchoolEvents WHERE SchoolCourseID = 3394 ORDER BY StartDate DESC, EventID DESC SQL used for upcoming (non-cancelled) candidates: SELECT SchoolEvents.EventID, SchoolEvents.Venue, SchoolEvents.City, SchoolEvents.Cancelled, SchoolEvents.AccredNum, CourseVenues.CourseVenueCity, CourseVenues.CourseVenueArea, SchoolEvents.StartDate, SchoolEvents.EndDate, SchoolEvents.CPD, SchoolEvents.AccredNum2, SchoolEvents.Level, SchoolEvents.SACPCMPNum, SchoolEvents.WebCategory, SchoolEvents.SchoolCourseID, SchoolEvents.EventName, SchoolEvents.SACPCMPCategory, SchoolEvents.SACPCMP_CPDPoints, SchoolEvents.SACNASP_ValidationNumber, SchoolEvents.SACNASP_CPD_Points, (SELECT COUNT(*) FROM EventSchedules es0 WHERE es0.EventID = SchoolEvents.EventID) AS ScheduleRowCount, (SELECT MIN(es1.ScheduleDate) FROM EventSchedules es1 WHERE es1.EventID = SchoolEvents.EventID AND es1.ScheduleDate >= '2026-08-28') AS NextScheduleDate, (SELECT MAX(es2.ScheduleDate) FROM EventSchedules es2 WHERE es2.EventID = SchoolEvents.EventID) AS LastScheduleDate FROM SchoolEvents LEFT JOIN CourseVenues ON SchoolEvents.Venue = CourseVenues.CourseVenueName WHERE (SchoolEvents.Cancelled IS NULL OR SchoolEvents.Cancelled <> 1) AND (SchoolEvents.WebCategory IS NULL OR SchoolEvents.WebCategory <> 11) AND SchoolEvents.SchoolCourseID = 3394 ORDER BY SchoolEvents.StartDate, SchoolEvents.EventID