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.

Q&A about the site for developers and end users of the Sitecore CMS and multichannel marketing software

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

fork query

edited aug 14 20 SomeoneEvil

created jan 24 12 gideon