~[DirectTable.Select:U_NT_MERIT_POINTS;id:-1] ~[tlist_sql; SELECT s.dcid AS gdcid FROM students s WHERE s.dcid = CASE WHEN ~(gpv.sdcid;num) > 0 THEN ~(gpv.sdcid;num) ELSE ~(rn) END AND s.schoolid = ~(curschoolid) AND s.enroll_status = 0 AND ('~[wc:meritstore/meritPrefTeacherScope]' = 'school' OR EXISTS ( SELECT 1 FROM cc JOIN sections sec ON sec.id = cc.sectionid WHERE cc.studentid = s.id AND cc.schoolid = ~(curschoolid) AND cc.termid BETWEEN ~(curyearid)00 AND ~(curyearid)99 AND (sec.teacher = ~[x:userid] OR EXISTS (SELECT 1 FROM sectionteacher st WHERE st.sectionid = sec.id AND st.teacherid = ~[x:userid]))))] [/tlist_sql] ~[submitbutton]

~[tlist_sql; SELECT COUNT(*) AS meritrowcount FROM u_nt_merit_points p JOIN students s ON s.dcid = p.studentsdcid WHERE p.studentsdcid = CASE WHEN ~(gpv.sdcid;num) > 0 THEN ~(gpv.sdcid;num) ELSE ~(rn) END AND s.schoolid = ~(curschoolid)] MERIT_ROWS:~(meritrowcount): [/tlist_sql]