Top 20 reputation whores in PHP tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans Meta

Q&A about the site for music historians, critics, and fans

SELECT TOP 20
    Users.Id AS Id,
    Users.DisplayName AS Nickname ,
    COUNT(Answers.Score) * 10 AS Reputation
   
FROM Posts AS Answers 
    INNER JOIN Posts AS Questions 
    ON Questions.Id = Answers.ParentId
    
    INNER JOIN Users AS Users
    ON Answers.OwnerUserId = Users.Id
    
    INNER JOIN PostTags 
    ON PostTags.PostId = Answers.ParentId
    
    INNER JOIN Tags
    ON Tags.Id = PostTags.TagId
    
WHERE Answers.PostTypeId = 2 
  AND Answers.OwnerUserId IS NOT NULL
  AND Tags.TagName = 'c++'
  AND ( Questions.ClosedDate <> '' 
     OR Questions.Score < 0 )

 
GROUP BY Users.Id, Users.DisplayName
ORDER BY Reputation DESC

Enter Parameters

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