[~[tlist_sql;
WITH tchrStudents AS(
	SELECT 
		distinct students.dcid, students.id
	FROM sections
	JOIN cc ON cc.sectionid = sections.id
	JOIN students ON students.id = cc.studentid
	JOIN sectionteacher ON sectionteacher.sectionid = sections.id
	WHERE sectionteacher.teacherid = ~[x:userid]
	AND cc.termid LIKE '~(curyearid)__'
)
SELECT 
	tchrStudents.id,
	COALESCE(emailAddress.emailaddress,pcas_emailcontact.emailaddress) guardianEmail
FROM tchrStudents
JOIN studentContactAssoc ON studentContactAssoc.studentdcid = tchrStudents.dcid
JOIN person ON person.id = studentContactAssoc.personid
LEFT JOIN personEmailAddressAssoc ON personEmailAddressAssoc.personid = person.id
	AND personemailaddressassoc.isprimaryemailaddress = 1
LEFT JOIN emailAddress ON personEmailAddressAssoc.emailAddressid = emailAddress.emailAddressId
LEFT JOIN codeset emailType ON emailType.codesetid = personEmailAddressAssoc.emailtypecodesetid
JOIN guardianPersonAssoc ON guardianPersonAssoc.personid = person.id
JOIN guardian ON guardian.guardianid = guardianPersonAssoc.guardianid
JOIN guardianstudent ON guardianstudent.guardianid = guardian.guardianid
	AND guardianstudent.studentsdcid = tchrStudents.dcid
JOIN pcas_account ON pcas_account.pcas_accounttoken = guardian.accountidentifier
	AND pcas_account.pcas_serviceid = 10000
	AND pcas_account.isenabled = 1
JOIN pcas_emailcontact ON pcas_account.pcas_accountid = pcas_emailcontact.pcas_accountid
;]
	{
		"studentid":"~(id)",
		"contactEmail":"~(email;JSON)"
	},
[/tlist_sql]{}]