Longest waiting before accepts

3

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

SELECT TOP 100
  Q.Id AS [Post Link],
  Q.CreationDate AS QuestionAsked, Votes.CreationDate AS AnswerAccepted,
  DATEADD(s,
    DATEDIFF(second, Q.CreationDate, Votes.CreationDate),
    CAST('1900-01-01 00:00:00.0000000' AS datetime2)) AS LB,
  DATEDIFF(second, Q.CreationDate, Votes.CreationDate) AS WaitInSeconds
FROM Votes
LEFT JOIN Posts AS A ON Votes.PostId = A.Id
LEFT JOIN Posts AS Q ON A.ParentId = Q.Id
WHERE Votes.VoteTypeId = 1
ORDER BY WaitInSeconds DESC

Enter Parameters

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