High Rep users without the peer pressure badge

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) don't have the peer pressure badge.

Movies and TV Meta

Q&A about the site for movie and tv enthusiasts

DECLARE @RepLimit int = ##ReputationLimit##

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

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results