Negative Roles are "virtual Roles", which are used for permissions, but not assigned to any users (in UserRoles). Admins Role of Portal 0 usually have RoleID = 0, but this is not guaranteed.
To exclude Superusers, please use:
SELECT U.UserID,
U.Username,
U.FirstName,
U.LastName,
U.Email,
R.RoleID
FROM UserRoles R
JOIN Users U ON R.UserID = U.UserID
WHERE (R.RoleID = 1)
AND (U.IsSuperUser = 0)
and U.userID not IN (SELECT UserID FROM UserRoles WHERE RoleID = 0)

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN