Top users by reputation after change in the weight of question upvote

0

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts Meta

Q&A about the site for enthusiasts and power users of the Android operating system

SELECT ROW_NUMBER() OVER(ORDER BY Score DESC) AS [#], us.id [User Link],
       us.DisplayName,       
       tuser.Score
       
FROM Users us

JOIN 
(
  SELECT
    count(*)*5 AS Score, p.OwnerUserId AS UserId
  FROM
    Votes v
    JOIN posts p ON p.Id = v.PostId 
  WHERE 
    p.PostTypeId = 1 AND v.VoteTypeId = 2
  GROUP BY 
    p.OwnerUserId
) tuser ON tuser.UserId = us.Id
WHERE Score > ##ScoreThreshold##
ORDER BY Score DESC;

Enter Parameters

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