m.personID AND r.personID2 = g.personID
AND r.guardian = 1
WHERE m.personID = p.personID
AND (m.sta... GETDATE())
WHERE x.personID1 = p.personID AND x.guardian = 1
ORDER BY CASE WHEN m.householdID IS NULL TH
personID1 = S.personID AND RP.endDate IS NULL AND guardian = 'true'
),
HR AS (
SELECT SH.studentPersonID, SH... S.firstName,
S.lastName,
S.grade,
C1.cellPhone AS guardian1Cell,
C1.email AS guardian1Email,
C2.cellPhone AS guardian2Cell,
C2.email AS guardian2Email,
PI.inputData AS lunchPin,
HR.teacherDispl