sibomots

Nevermind, I think I found the linkage:
 
select M.name, M.email from ibf_core_members M where exists (select P.notification_key from ibf_core_notification_preferences P where P.member_id = M.member_id and P.preference = 'email') I can work it from this.