arID = E.calendarID AND C.exclude = 0 AND C.summerSchool = 0
JOIN SchoolYear SY ON SY.endYear = C.endYear AND SY.active = 1
JOIN School S ON S.schoolID = C.schoolID AND S.number IN (402... arID = E.calendarID AND C.exclude = 0 AND C.summerSchool = 0
JOIN SchoolYear SY ON SY.endYear = C.endYear AND SY.active = 1
JOIN School S ON S.schoolID = C.schoolID AND S.number IN (402