dozenten_with_lernmodule_plugins.sql

SELECT auth_user_md5.*
FROM plugins
	INNER JOIN plugins_activated ON (plugins_activated.`pluginid` = plugins.`pluginid` AND state = 'on')
	INNER JOIN seminar_user ON (CONCAT('sem', seminar_user.Seminar_id) = plugins_activated.`poiid` AND seminar_user.status = 'dozent')
	INNER JOIN auth_user_md5 ON (auth_user_md5.user_id = seminar_user.user_id)
WHERE plugins.pluginclassname = 'LernmodulePlugin'
GROUP BY auth_user_md5.user_id