SELECT u.USER_DISPLAY_NAME, f.FORUM_ID, f.FORUM_TITLE FROM ubbt_MODERATORS m, ubbt_USERS u, ubbt_FORUMS f WHERE u.USER_ID = m.USER_ID AND m.FORUM_ID = f.FORUM_ID GROUP BY u.USER_DISPLAY_NAME, m.FORUM_ID