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
  v.PostId AS [Post Link],
  (DateDiff(second, Min(p.CreationDate), v.CreationDate) + 86400) / 86400 AS [Age],
  Count(*) AS [Upvotes]
FROM Votes v
LEFT JOIN Posts p ON p.Id = v.PostId
WHERE v.VoteTypeId = 2 -- upvote
GROUP BY v.PostId, v.CreationDate
ORDER BY [Upvotes] DESC

Enter Parameters

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