Top 500 answerers on the site

0

Please login or register to vote for this query.

(click on this box to dismiss)

A list of the top 500 users with the highest average answer score excluding community wiki / closed posts or users with less than 10 answers

Tridion

Q&A for Tridion developers and administrators

SELECT u.Id AS [User Link],
      CONCAT('https://stackoverflow.com/users/', u.Id) AS [Profile Link],
      u.DisplayName,
      u.Location,
      u.WebsiteUrl,
      u.AboutMe,
      u.Views,
      u.UpVotes,
      u.DownVotes
FROM Users u
JOIN(
  SELECT DISTINCT UserId
  FROM Badges
  WHERE LOWER(Name) IN ('solidity') AND
       Class IN (1, 2, 3) AND
       TagBased = 1
) tag_badges
ON tag_badges.UserId = u.Id

Enter Parameters

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