SELECT u.user_id, u.username
FROM phpbb_auth_access aa, phpbb_user_group ug, phpbb_groups g, phpbb_users u
WHERE aa.forum_id = 13
AND 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
GROUP BY u.user_id, u.username
ORDER BY u.user_id
www.vivan.no
Hjelp
Søk
Medlemsliste
Grupper
Bli Medlem
Profil
Sjekk private meldinger
Logg Inn