haal met onder:wqstaande query een lijst met examendocenten uit het rooster
en importeer deze in tabel vergoeding

SELECT NULL as, bla.*, 0,0, ppl_id, 8 FROM (
	    SELECT DISTINCT docenten.entity_name, CONCAT(entities.entity_name,
		        vakken.entity_name)
		FROM entities
		JOIN grp2grp ON grp2grp.lesgroep_id = entities.entity_id
		JOIN entities2lessen ON entities2lessen.entity_id = grp2grp.lesgroep2_id
		JOIN files2lessen ON files2lessen.les_id = entities2lessen.les_id AND files2lessen.file_id = 2342
		JOIN entities2lessen AS vakken2lessen ON vakken2lessen.les_id = entities2lessen.les_id
		JOIN entities AS vakken ON vakken.entity_id = vakken2lessen.entity_id AND vakken.entity_type = 6
		JOIN entities2lessen AS docenten2lessen ON docenten2lessen.les_id = entities2lessen.les_id
		JOIN entities AS docenten ON docenten.entity_id = docenten2lessen.entity_id
		AND docenten.entity_type = 2
		WHERE entities.entity_name = '5H' OR entities.entity_name = '6V'
		ORDER BY docenten.entity_name
	) bla
JOIN kldv.ppl ON ppl.ppl_login = bla.entity_name

