The fastest shots on the west

1

Please login or register to vote for this query.

(click on this box to dismiss)

Moderators

Q&A for community managers, administrators, and moderators

SELECT TOP 100
  Q.Id AS [Post Link],
  Q.CreationDate AS Asked,
  A.LastEditDate AS Answered,
  DATEDIFF(s, Q.CreationDate, A.LastEditDate) AS Seconds
FROM Posts Q, Posts A
WHERE
  A.ParentId = Q.Id
  AND
  A.OwnerUserId <> Q.OwnerUserId
  AND
  A.OwnerUserId >= 1
  AND
  Q.OwnerUserId >= 1
  AND
  A.LastEditDate >= Q.CreationDate
ORDER BY Seconds

Enter Parameters

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