') pta_id, PTA(pta_id) toets, ptas.toetsduur, stdher, COUNT(rex_id) aantal, CONCAT('[wijz]') wijz,
-- IF(COUNT(rex_id) = 0, CONCAT('[del]'), 'del') del,
CONCAT('') ll,
CONCAT('') doc,
CONCAT('') ment, CONCAT('') flags
FROM ptas
LEFT JOIN (
SELECT * FROM period2selectable WHERE period_id = {$herinfo['period_id']}
) AS bla USING (pta_id)
JOIN kldv.years USING (year_id)
LEFT JOIN rex USING (pta_id)
-- WHERE year_id = {$herinfo['year_id']}$addwhere
WHERE TRUE$addwhere
GROUP BY pta_id
EOQ
);
?>