Historically accepted answers for Question 1474489

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
  Q.Id AS [Post Link],
  A.Id AS [Post Link],
  A.CreationDate AS AnswerDate,
  A.DeletionDate,
  V.CreationDate AS AcceptanceDate
FROM Posts Q
LEFT JOIN PostsWithDeleted A ON (A.parentId = Q.Id AND A.PostTypeId = 2)
LEFT JOIN Votes V ON (A.Id = V.PostId)
WHERE Q.Id = 1474489
  AND V.VoteTypeId = 1

Enter Parameters

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