Badge Samaritan - revival - answers that need 1 upvote

1

Please login or register to vote for this query.

(click on this box to dismiss)

http://stackoverflow.com/help/badges/837/revival "Answered more than 30 days later as first answer scoring 2 or more. This badge can be awarded multiple times."

Physics

Q&A for active researchers, academics and students of physics

SELECT TOP 2000
  a.Id AS [Post Link],
  a.Score,
  a.CreationDate
FROM
  Posts AS a
INNER JOIN
  Posts AS q
ON
  a.ParentId = q.Id
INNER JOIN
  PostHistory AS ph
ON
  ph.PostId = q.Id
WHERE
      ph.PostHistoryTypeId != 14
  and DATEDIFF(DAY, q.CreationDate, a.CreationDate) > 30
  and (a.Score = 1)
  and q.AnswerCount = 1
  and a.OwnerUserId = ##User##
GROUP BY
  a.Id, a.Score, a.CreationDate
ORDER BY
  a.CreationDate DESC

Enter Parameters

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