Und was spricht gegen folgende Abfrage?
SQL-Code:
SELECT *
FROM #__eventusers u
WHERE FIND_IN_SET(Notification, Mail_All)
OR ( FIND_IN_SET(Notification, Mail_Own)
AND EXISTS (SELECT *
FROM #__eventhelper
WHERE event_id = 10
AND helper_id = u.login_id))