0

Please login or register to vote for this query.

(click on this box to dismiss)

Show the posts that have accumulated the most votes a week or more after they were posted

Q&A for professional and enthusiast programmers

SELECT TOP 1000
  p.Id As [Post Link],
  Max(p.OwnerUserId) As [User Link],
  Count(*) As [Late Votes]
FROM Votes v, Posts p
WHERE v.PostId = p.Id
AND DateDiff(second, p.CreationDate, v.CreationDate) > 7*24*3600
GROUP BY p.Id
ORDER BY Count(*) DESC

fork query

created jan 17 12 Gilles