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 distinct
       usr.[Id],
       bag.[Name],
       iif(usr.[Id] is null, 0, 1) as [HasBadge]
  from [Badges] bag
           left join
       [Users]  usr on usr.[Id] = bag.[UserId]
 where usr.[Id] in (##UserIds##)
   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'
)
 order by bag.[Name]

Enter Parameters

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