'),
'geen toetsen gekoppeld') AS toetsen,
CONCAT('wijz') AS wijz
FROM period2maxflags
LEFT JOIN (
SELECT period2maxflags_id, flags, max,
CONCAT(pta_leerjr, target, '.', sy, '/', CASE WHEN inhaalregime = 0 THEN 'TP' ELSE 'per' END,
pta_tp, ': ', GROUP_CONCAT(CONCAT(subj_abbrev, ' ', info)
ORDER BY subj_abbrev, info SEPARATOR ', ')) stuff
FROM period2maxflags
LEFT JOIN (
SELECT inhaalregime, pta_tp, subj_abbrev, CONCAT(stvt, shortdesc) info, pta_leerjr, pta_target target, flags sflags, CONCAT(SUBSTRING(year_long, 3, 2), SUBSTRING(year_long, 8, 2)) sy, pta_leerjr - ( SUBSTRING(year_long, 6, 4) - ( SELECT SUBSTRING(year_long, 6, 4) FROM kldv.years WHERE year_id = {$period['year_id']} ) ) AS leerjr, year_id
FROM ptas
JOIN $kldv.subj USING (subj_id)
JOIN $kldv.years USING (year_id)
JOIN (
SELECT * FROM period2selectable WHERE period_id = {$period['period_id']}
) AS tmp USING (pta_id)
-- WHERE year_id = {$period['year_id']}
) AS current USING (leerjr, target)
WHERE period_id = {$period['period_id']} AND flags & sflags
GROUP BY pta_tp, inhaalregime, period2maxflags_id
) AS tmp2 USING (period2maxflags_id)
WHERE period_id = {$period['period_id']}
GROUP BY period2maxflags_id
EOQ
);
html_start(''); ?>
Maxflags
toevoegen