How many moderators have the "Sportsmanship" badge?

1

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.

Stack Overflow

Q&A for professional and enthusiast 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

Enter Parameters

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