'
$concat_end gekoppeld
FROM (
SELECT grp_id, $group_concat(ppl_login) mentor
FROM $kldv.year2grp2subj
JOIN $kldv.grp2subj ON grp2subj.grp2subj_id = year2grp2subj.grp2subj_id
JOIN $kldv.subj ON subj.subj_id = grp2subj.subj_id AND subj_abbrev = 'mt'
JOIN $kldv.ppl2grp2subj ON ppl2grp2subj.grp2subj_id = grp2subj.grp2subj_id
AND ppl2grp2subj.ppl_enter <= {$meeting['eff_meeting_teacher_deadline']}
AND ppl2grp2subj.ppl_exit > {$meeting['eff_meeting_teacher_deadline']}
JOIN $kldv.ppl ON ppl.ppl_id = ppl2grp2subj.ppl_id
WHERE year_id = $year_id
GROUP BY grp_id
) AS tmp
JOIN $kldv.grp ON grp.grp_id = tmp.grp_id
LEFT JOIN eff_meeting2grp ON eff_meeting2grp.grp_id = grp.grp_id AND eff_meeting2grp.eff_meeting_id = %i
ORDER BY grp_name
EOQ
, $_GET['meeting_id']);
html_start(); ?>
Klassen koppelen aan: .