grp?'), ': ', COUNT(ppl_id), ')') title, momentlocation_id, COUNT(ppl_id) aantal FROM moments JOIN rooster USING (moment_id, period_id) JOIN ptas USING (pta_id) JOIN rex USING (period_id, pta_id, subj_id) LEFT JOIN ( SELECT grp.grp_id, ppl_id, subj_id, grp_name FROM $kldv.grp2subj JOIN $kldv.ppl2grp ON ppl2grp.grp_id = grp2subj.grp_id AND ppl2grp.ppl_enter <= {$herinfo['period_deadline']} AND ppl2grp.ppl_exit > {$herinfo['period_deadline']} JOIN $kldv.grp ON grp.grp_id = ppl2grp.grp_id JOIN $kldv.year2grp2subj ON year2grp2subj.grp2subj_id = grp2subj.grp2subj_id AND year_id = {$herinfo['year_id']} AND grp2subj_enter <= {$herinfo['period_deadline']} AND grp2subj_exit > {$herinfo['period_deadline']} ) AS grp USING (ppl_id, subj_id) LEFT JOIN newdetailrooster USING (rooster_id, grp_id) WHERE moment_id = %i GROUP BY pta_id, grp_id ORDER BY title EOQ , $_GET['moment_id']); $reserves = mdb2_all_assoc_rekey($db, "SELECT reserve_order, reserve FROM reserves WHERE moment_id = %i ORDER BY reserve_order", $_GET['moment_id']); function get_activiteit($no) { if ($no <= 0) return 'gangwacht'; return 'reserve '.$no; } html_start(<<

Indeling : moment – terug naar roostervriend

$info) { ?>
voeg momentlocatie toe
$info) { ?>
:
:
: