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.

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

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 to main site
loading Hold tight while we fetch your results