[~[tlist_sql;
	SELECT termbins.storecode, terms.abbreviation
	FROM termbins
	JOIN terms ON terms.schoolid = termbins.schoolid
	  AND terms.id = termbins.termid
	WHERE termbins.schoolid = ~(curschoolid)
	AND terms.yearid = ~(curyearid)
	ORDER BY date2, date1 desc
;]
	{	
		"storecode":"~(sc;JSON)",
		"term":"~(trm;JSON)"
	},
[/tlist_sql]{}]