On a certain SE site, I'm interested in seeing how many people have both of two different badges (Promoter & Tumbleweed).
Is there a way to do this?
Meta Stack Exchange is a question and answer site for meta-discussion of the Stack Exchange family of Q&A websites. It only takes a minute to sign up.Sign up to join this community
The following query will return the users who has the Promoter, Tumbleweed badges on a specific site.
SELECT TOP 1000 UserId AS [User Link] FROM Badges WHERE Name IN ('Promoter', 'Tumbleweed') GROUP BY UserId HAVING COUNT(DISTINCT Name) = 2
TOP 1000 to avoid the timeout issue,