0

Please login or register to vote for this query.

(click on this box to dismiss)

A way to find which users (mostly high rep) have the peer pressure badge. Was just playing around with T-SQL and cooked this. =D

Q&A for anime and manga fans

DECLARE @RepLimit int = ##ReputationLimit##

Select Id as [User Link], DisplayName, Reputation
 from Users
 where Reputation > @RepLimit
   and exists (Select Id from Badges b where b.UserId = Users.Id and b.Name = 'Peer Pressure')   
order by Reputation desc

fork query

edited jan 24 12

created jan 24 12 gideon