Moderator election badges

1

Please login or register to vote for this query.

(click on this box to dismiss)

Interpersonal Skills

Q&A for people looking to improve their interpersonal communication skills

select usr.[Id],
       iif(bag.[Id] is null, 0, 1) as [HasBadge]
  from [Users]  usr
           left join
       [Badges] bag on bag.[UserId] = usr.[Id]
                   and bag.[Name] in
(
         'Civic Duty', 
         'Cleanup',
         'Constituent',
         'Convention',
         'Copy Editor',
         'Deputy',
         'Electorate',
         'Enthusiast',
         'Explainer',
         'Investor',
         'Marshal',
         'Organizer',
         'Quorum',
         'Refiner',
         'Sportsmanship',
         'Strunk & White',
         'Tag Editor',
         'Reviewer',
         'Steward', 
         'Yearling'
)
 where usr.[Id] in (##UserIds##)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results