Closed questions with highest (current) OP reputation

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

SELECT TOP 100
  Posts.Id AS [Post Link],
  Posts.Id AS PostId,
  Posts.Score,
  Users.Id AS [User Link],
  Users.Id AS UserId,
  Users.Reputation AS UserReputation
FROM Posts, Users
WHERE
  Posts.OwnerUserId = Users.Id
  AND
  Posts.ClosedDate IS NOT NULL
ORDER BY
  Users.Reputation DESC, Users.Id

Enter Parameters

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