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 = 'php' AND ( Questions.ClosedDate <> '' OR Questions.Score < 0 ) GROUP BY Users.Id, Users.DisplayName ORDER BY Reputation DESC