<?
require_once('phplib/phplib.php');
require_once('common.php');

check_admin();

$db = mdb2_open($dsn);

$herinfo = get_herinfo($db);

$lijst = mdb2_query($db, <<<EOQ
SELECT rex.rex_id, rex2.rex_id AS rex2_id, ppl.ppl_login, ppl.ppl_forename, ppl.ppl_prefix, ppl.ppl_surname, rex2.info, grp.grp_name, ppl2.ppl_login AS ppl2_login
FROM rex
JOIN rex AS rex2 ON rex2.pta_id = rex.pta_id AND rex2.ppl_id = rex.ppl_id
JOIN $kldv.ppl ON rex.ppl_id = ppl.ppl_id
JOIN ptas ON rex.pta_id = ptas.pta_id
JOIN $kldv.subj ON subj.subj_id = ptas.subj_id
JOIN $kldv.ppl2grp ON ppl2grp.ppl_id = ppl.ppl_id
AND ppl2grp.ppl_enter <= {$herinfo['period_deadline']}
AND ppl2grp.ppl_exit > {$herinfo['period_deadline']}
JOIN $kldv.grp2subj ON grp2subj.grp_id = ppl2grp.grp_id AND grp2subj.subj_id = ptas.subj_id
JOIN $kldv.grp ON grp.grp_id = ppl2grp.grp_id
JOIN $kldv.ppl2grp2subj ON ppl2grp2subj.grp2subj_id = grp2subj.grp2subj_id
JOIN $kldv.ppl AS ppl2 ON ppl2.ppl_id = ppl2grp2subj.ppl_id
WHERE rex.period_id = 2 AND rex2.period_id = 5
EOQ
);

html_start("" , "Compare");
mdb2_res_table($lijst);
?>

<? html_end(); ?>