[~[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
	, ~[if#fld1.~(gpv.fld1)#]~(gpv.fld1;keep_ascii=46,48-57,65-90,95,97-122)[else#fld1]''[/if#fld1]
	, ~[if#fld2.~(gpv.fld2)#]~(gpv.fld2;keep_ascii=46,48-57,65-90,95,97-122)[else#fld2]''[/if#fld2]
	, ~[if#fld3.~(gpv.fld3)#]~(gpv.fld3;keep_ascii=46,48-57,65-90,95,97-122)[else#fld3]''[/if#fld3]
	, ~[if#fld4.~(gpv.fld4)#]~(gpv.fld4;keep_ascii=46,48-57,65-90,95,97-122)[else#fld4]''[/if#fld4]
FROM tchrStudents
	~[if#tbl1.~(gpv.tbl1)#]
		LEFT JOIN ~(gpv.tbl1;keep_ascii=48-57,65-90,95,97-122) ON ~(gpv.tbl1;keep_ascii=48-57,65-90,95,97-122).studentsdcid = tchrStudents.dcid
	[/if#tbl1]
	~[if#tbl2.~(gpv.tbl2)#]
		LEFT JOIN ~(gpv.tbl2;keep_ascii=48-57,65-90,95,97-122) ON ~(gpv.tbl2;keep_ascii=48-57,65-90,95,97-122).studentsdcid = tchrStudents.dcid
	[/if#tbl2]
	~[if#tbl3.~(gpv.tbl3)#]
		LEFT JOIN ~(gpv.tbl3;keep_ascii=48-57,65-90,95,97-122) ON ~(gpv.tbl3;keep_ascii=48-57,65-90,95,97-122).studentsdcid = tchrStudents.dcid
	[/if#tbl3]
	~[if#tbl4.~(gpv.tbl4)#]
		LEFT JOIN ~(gpv.tbl4;keep_ascii=48-57,65-90,95,97-122) ON ~(gpv.tbl4;keep_ascii=48-57,65-90,95,97-122).studentsdcid = tchrStudents.dcid
	[/if#tbl4]
;]
	{
		"studentid":"~(id)",
		"email1":"~(emailAddr;JSON)",
		"email2":"~(emailAddr1;JSON)",
		"email3":"~(emailAddr2;JSON)",
		"email4":"~(emailAddr3;JSON)"
	},
[/tlist_sql]{}]