How many moderators have the "Sportsmanship" badge?

Please login or register to vote for this query.

(click on this box to dismiss)

Note: SEDE currently does not have a good way to determine if a user is a moderator.

Q&A for programmers

-- How many moderators have the "Sportsmanship" badge?
-- Note: SEDE currently does not have a good way to determine if a user is a moderator.

SELECT      u.Id    AS [User Link]
        --, b.Name
          , CASE
                WHEN b.Name IS NULL     THEN N'✖ Not sporting'
                ELSE N'✔ Sporting'
            END AS [Good Sport?]
FROM        Users   u
LEFT JOIN   Badges  b
ON          (   u.Id = b.UserId
                AND
                (b.Name IS NULL     OR LOWER(b.Name) = 'sportsmanship')
            )
-- List of SO mods.  SEDE has no good method for mod detection!
WHERE       u.Id    IN (105971, 1288, 106224, 50776, 54680, 419, 267, 13531, 396458, 102937, 50049, 1228)
ORDER BY    u.DisplayName

created dec 10 11