Longest accepts

1

Please login or register to vote for this query.

(click on this box to dismiss)

History of Science and Math

Q&A for people interested in the history and origins of science and mathematics

WITH Raw AS (
  SELECT Q.Id AS QId, MIN(A.Id) AS AId
  FROM Posts Q, PostsWithDeleted A
  WHERE
    A.ParentId = Q.Id
  GROUP BY Q.Id
)
SELECT TOP 1000
  Raw.AId AS [Post Link],
  Q.CreationDate AS QCreated,
  A.CreationDate AS ACreated,
  DATEDIFF(s, Q.CreationDate, A.CreationDate) AS DiffS
FROM Posts Q, Raw, Posts A
WHERE
  Q.AcceptedAnswerId = A.Id
  AND
  Q.Id = Raw.QId
  AND
  A.Id = Raw.AId
ORDER BY DiffS DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results