[~[tlist_sql;
	SELECT 
		cc.id,
		students.id,
		sections.id,
		students.lastfirst,
		emailaddress.emailaddress,
		students.guardianemail
	FROM sections
	JOIN cc ON cc.sectionid = sections.id
	JOIN students ON students.id = cc.studentid
	JOIN sectionteacher ON sectionteacher.sectionid = sections.id
	LEFT JOIN personemailaddressassoc emassoc ON emassoc.personid = students.person_id
  	LEFT JOIN emailaddress ON emailaddress.emailaddressid = emassoc.emailaddressid
	WHERE sectionteacher.teacherid = ~[x:userid]
	AND cc.termid LIKE '~(curyearid)__'
;]
	{
		"ccid":"~(ccid)",
		"studentid":"~(studentid)",
		"sectionid":"~(sectionid)",
		"name":"~(name;JSON)",
		"email":"~(email;JSON)",
		"guardianemails":["~(guardianemail;JSON)"],
		"grades":{}
	},
[/tlist_sql]{}]