Most Upvoted Questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

The top 20 questions with the most up-votes (ignores down-votes)

Chess

Q&A for serious players and enthusiasts of chess

SELECT TOP ##n##
  COUNT(Votes.PostID) AS [Vote count],
  Votes.PostID AS [Post Link]
FROM Votes
INNER JOIN Posts ON Posts.ID = Votes.PostID
WHERE PostTypeID = 1 AND VoteTypeID=2
GROUP BY Votes.PostID,Posts.body
ORDER BY [Vote count] DESC

Enter Parameters

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