', kaartverkoop.barcode, '') barcode,
CASE
WHEN ppl.ppl_id IS NOT NULL
THEN CONCAT(ppl.ppl_forename, ' ', ppl.ppl_prefix, ' ', ppl.ppl_surname, ' (', IFNULL(klas.grp_name, 'KLAS?'), ')')
WHEN intro.ppl_id IS NOT NULL
THEN CONCAT('introducee van ', intro.ppl_forename, ' ',
intro.ppl_prefix, ' ', intro.ppl_surname)
ELSE 'onbekend'
END gast,
CASE
WHEN timestamp_delete IS NULL
THEN CONCAT('verwijderen')
ELSE CONCAT('verwijderd door ', IF(delete_ppl_id = delete_ppl_eid, delete_ppl_id,
CONCAT(delete_ppl_id, '/', delete_ppl_eid)), ' op ', timestamp_delete)
END status
FROM kaartverkoop
LEFT JOIN $kldv.ppl ON barcode = ppl_login
LEFT JOIN (
SELECT * FROM $kldv.ppl2grp
JOIN (
SELECT * FROM $kldv.grp
WHERE grp_home = 1
) AS stamklas USING (grp_id)
WHERE ppl_enter <= UNIX_TIMESTAMP()
AND ppl_exit > UNIX_TIMESTAMP()
) AS klas USING (ppl_id)
LEFT JOIN (
SELECT * FROM introducees
LEFT JOIN $kldv.ppl ON llnr = ppl_login
) AS intro USING (barcode, feest_id)
EOQ;
?>