'),
'geen toetsen gekoppeld') AS toetsen,
CONCAT('wijz') AS wijz
FROM period2maxflags
LEFT JOIN (
SELECT period2maxflags_id, flags, max, CONCAT(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 leerjr, pta_target target, flags sflags, CONCAT(SUBSTRING(year_long, 3, 2), SUBSTRING(year_long, 8, 2)) sy, SUBSTRING(year_long, 1, 4) - pta_leerjr AS cohort
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