Low activity, many votes

1

Please login or register to vote for this query.

(click on this box to dismiss)

Anime and Manga Meta

Q&A about the site for anime and manga fans

SELECT TOP 1000
  Users.Id AS [User Link],
  MIN(Users.Reputation) AS Rep,
  COUNT(*) AS Posts,
  MIN(Users.UpVotes) AS Ups,
  MIN(Users.DownVotes) AS Downs,
  MIN(Users.UpVotes) + MIN(Users.DownVotes) AS Votes,
  1.0 * MIN(Users.UpVotes) / COUNT(*) AS UpsPerPosts,
  1.0 * MIN(Users.DownVotes) / COUNT(*) AS DownsPerPosts,
  1.0 * (MIN(Users.UpVotes) + MIN(Users.DownVotes)) / COUNT(*)
    AS VotesPerPosts
FROM Posts, Users
WHERE
  Posts.OwnerUserId = Users.Id
GROUP BY Users.Id
ORDER BY VotesPerPosts DESC, Users.Id

Enter Parameters

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