UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support Looking for Sql command

You also might want to try

SELECT * FROM w3t_Users WHERE U_Groups = '-'

As sometimes users with no groups end up with just the separator dash in there.