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],
  Convert(datetime, v.CreationDate, 102) AS [Vote day],
  Convert(datetime, Min(p.CreationDate), 102) AS [Post day],
  DateDiff(second, Min(p.CreationDate), v.CreationDate) 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