test

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping Meta

Q&A about the site for gardeners and landscapers

SELECT TOP 100
  u.Id AS [User Link],
  
  Count(*) AS [Total upvotes]
FROM Votes v, Posts p, Users u
WHERE v.VoteTypeId = 2 -- upvote
  AND v.PostId = p.Id
  AND p.OwnerUserId = u.Id
GROUP BY u.Id
ORDER BY [Total upvotes]
-- GROUP BY Convert(datetime, v.CreationDate, 112)
-- ORDER BY Convert(datetime, v.CreationDate, 112) DESC

Enter Parameters

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