') ``, subj_abbrev vak,
IFNULL(tp1, '-') tp1,
IFNULL(tp2, '-') tp2,
IFNULL(tp3, '-') tp3,
IFNULL(GROUP_CONCAT(
CONCAT(ppl_login, '[del]')), '-') `gemachtigde(n)` ,
IF(accordering_id IS NULL, 'NIET GEACCORDEERD', CONCAT('GEACCORDEEERD (', accord.accordant, ' ', accord.timestamp, ')', '[del]')) geaccordeerd
FROM $kldv.subj
LEFT JOIN gemachtigd USING (subj_id)
LEFT JOIN $kldv.ppl USING (ppl_id)
LEFT JOIN (
SELECT subj_id, COUNT(toets_id) tp1 FROM toets2subj JOIN toets USING (toets_id) WHERE year_id = $year_id AND toets_tp = 'TP1' GROUP BY subj_id
) AS subtp1 USING (subj_id)
LEFT JOIN (
SELECT subj_id, COUNT(toets_id) tp2 FROM toets2subj JOIN toets USING (toets_id) WHERE year_id = $year_id AND toets_tp = 'TP2' GROUP BY subj_id
) AS subtp2 USING (subj_id)
LEFT JOIN (
SELECT subj_id, COUNT(toets_id) tp3 FROM toets2subj JOIN toets USING (toets_id) WHERE year_id = $year_id AND toets_tp = 'TP3' GROUP BY subj_id
) AS subtp3 USING (subj_id)
LEFT JOIN (
SELECT subj_id, accordering_id, ppl_login accordant, timestamp
FROM accorderingen
JOIN $kldv.ppl USING (ppl_id)
WHERE year_id = $year_id
) AS accord USING (subj_id)
WHERE subj_id IN ( $subj_ids )
GROUP BY subj_id
ORDER BY subj_abbrev
EOQ
);
$schooljaar = '';
html_start(<<
Switch user
Gemachtigden
Schooljaar
Het geldende schooljaar is . Het schooljaar kan alleen worden gewijzigd als het systeem dicht staat.