[Andreas]

Moderators
[SQL]SELECT moderator.userid, user.username FROM moderator LEFT JOIN user ON (moderator.userid=user.userid) GROUP BY moderator.userid[/SQL]

Super-Moderators
[SQL]SELECT user.username, user.userid
FROM user, usergroup
WHERE (user.usergroupid = usergroup.usergroupid OR usergroup.usergroupid
IN (user.membergroupids)) AND (usergroup.adminpermissions & 1) AND !(usergroup.adminpermissions & 2)[/SQL]

Admins
[SQL]SELECT user.username, user.userid
FROM user, usergroup
WHERE (user.usergroupid = usergroup.usergroupid OR usergroup.usergroupid
IN (user.membergroupids)) AND (usergroup.adminpermissions & 2)[/SQL]