r cx ON cx.calendarID = x.calendarID AND cx.summerschool = 0
INNER JOIN schoolyear syx ON syx.endyear = x.endyear AND syx.active = 1
WHERE x.personID = p.pers... 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 s
al ON E.calendarID = Cal.calendarID AND Cal.summerSchool = 'false'
JOIN SchoolYear SY ON Cal.endYear = SY.endYear AND SY.active = 'true'
JOIN [IDENTITY] I ON P.cu... 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 POSIdenti