Potential necromancer answers for a given user: answers with questions 60 days older or more

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

SELECT
  Answers.Id AS [Post Link],
  Answers.CreationDate AS "Answered Date",
  Questions.CreationDate AS "Asked Date",
  DATEDIFF(day, Questions.CreationDate, Answers.CreationDate) AS "Date Delta Days",
  Answers.Score
FROM
  Posts AS Answers
INNER JOIN
  Posts AS Questions
ON
  Answers.PostTypeId = 2 AND
  Answers.OwnerUserId = '##UserId?895245##' AND
  Answers.CreationDate < '##Date?9999-01-01##' AND
  Questions.Id = Answers.ParentId AND
  DATEDIFF(day, Questions.CreationDate, Answers.CreationDate) > 60
ORDER BY
  Answers.Score ASC

Enter Parameters

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