3

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Drupal developers and administrators

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

fork query

edited mar 24 17

created mar 24 17 peterh