Answers close to the Necromancer badge

4

Please login or register to vote for this query.

(click on this box to dismiss)

All your answers that were posted at least 60 days after the question was posted, with a score of 4 or lower. When any of these reach a score of 5, they should earn you a Necromancer silver badge.

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

DECLARE @UserId int = ##UserId##

SELECT 
    a.Id AS [Post Link], 
    a.Score
FROM
    Posts q
  INNER JOIN
    Posts a ON q.Id = a.ParentId
WHERE
    a.OwnerUserId = @UserId
  AND
    a.PostTypeId = 2
  AND
    a.score <= 4
  AND
    DATEDIFF(d, q.creationdate, a.creationdate) >= 60
ORDER BY
    a.score DESC

Enter Parameters

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