[~[tlist_sql;
	SELECT 
		cc.id,
		pgfinalgrades.finalgradename,
		pgfinalgrades.grade
	FROM pgfinalgrades
	JOIN sections ON sections.id = pgfinalgrades.sectionid
	JOIN students ON students.id = pgfinalgrades.studentid
	JOIN cc ON cc.studentid = students.id
		AND cc.sectionid = sections.id
		AND cc.termid > 0
	JOIN terms ON terms.id = sections.termid
		AND terms.schoolid = sections.schoolid
		AND terms.yearid = ~(curyearid)
	JOIN sectionteacher ON sectionteacher.sectionid = sections.id
	WHERE sectionteacher.teacherid = ~[x:userid]
;]
	{
		"ccid":"~(ccid)",
		"storecode":"~(sc;JSON)",
		"grade":"~(grade;JSON)"
	},
[/tlist_sql]{}]