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.

Q&A for community managers, administrators, and moderators

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

fork query

created dec 24 13 Martijn Pieters