x.calendarID AND cx.summerschool = 0
INNER JOIN schoolyear syx ON syx.endyear = x.endyear AND syx.active... endar c ON c.calendarID = e.calendarID
INNER JOIN school s ON s.schoolID = c.schoolID
INNER JOIN district d ON d.districtID = s.districtID
INNER JOIN schoolyear sy ON sy.endyea
al.calendarID AND Cal.summerSchool = 'false'
JOIN SchoolYear SY ON Cal.endYear = SY.endYear AND SY.active ... EA
JOIN Person P ON EA.personID = P.personID
JOIN School S ON EA.schoolID = S.schoolID
JOIN [IDENTITY] I ON P.currentIdentityID = I.identityID
LEFT JOIN POSIdentification PI ON