SELECT aa.forum_id, u.username
FROM nuke_bbauth_access aa, nuke_bbuser_group ug, nuke_bbgroups g, nuke_users u
WHERE aa.auth_mod = '1' AND g.group_single_user = '1' AND ug.group_id = aa.group_id AND g.group_id = aa.group_id
AND u.user_id = ug.user_id and u.user_id= and aa.forum_id=7