Forums with ENFORCE_MODERATION enabled

SELECT fr.pk1,
u.email,
cm.course_id,
fm.name,
fr.dtcreated,
fr.dtmodified
FROM forum_registry fr
INNER JOIN forum_main fm ON fr.forummain_pk1 = fm.pk1
INNER JOIN conference_main confm ON fm.confmain_pk1 = confm.pk1 
INNER JOIN course_main cm ONconfm.conference_owner_pk1 = cm.pk1
INNER JOIN (SELECT * from course_users WHERE role = 'P') AS cu ON cm.pk1 = cu.crsmain_pk1
INNER JOIN users u ON cu.users_pk1 = u.pk1
WHERE registry_key LIKE 'ENFORCE%' AND registry_value = 'Y'