All Necromancer candidates

1

Please login or register to vote for this query.

(click on this box to dismiss)

https://stackoverflow.com/help/badges/17/necromancer "Answer a question more than 60 days later with score of 5 or more. This badge can be awarded multiple times."

Computational Science

Q&A for scientists using computers to solve scientific problems

declare @userId int = ##userId##

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) > 60
  and a.OwnerUserId = @userId
GROUP BY
  a.Id, a.Score, a.CreationDate
ORDER BY
  a.Score DESC, a.CreationDate DESC

Enter Parameters

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