Rise of the Frontroom Threads

[Sigurd]

SELECT * FROM Users WHERE Users.TehBan > 1 SORT BY Users.TehBan

123456,"Devastatin Dave",153
123457,"Tribesman",97
...

*cough*ORDER BY*cough*

Id like to see who the most ignored members were

you know the guys that talk talking but no ones listening

That’s easy:

SELECT TOP 1 UserName, IgnoredNo FROM Users ORDER BY IgnoredNo DESC

----------
Sigurd Fafnesbane, 2777