Ripe zombies


Please login or register to vote for this query.

(click on this box to dismiss)

Open questions with answers, at least one answer having score 0, no answer having score > 0 (a.k.a. zombies ready for killing)

Code Review

Q&A for peer programmer code reviews

DECLARE @username AS NVARCHAR(60) = ##DisplayName:string? ##;
DECLARE @userId AS INT = ##UserId:int?-1##;

SELECT TOP ##Limit:int?100##
  u.Id AS [User Link],
  q.Id AS [Post Link],
FROM Posts a
  JOIN Users u ON a.OwnerUserId = u.Id
  JOIN (
    SELECT q.Id, MAX(a.Score) MaxAnswerScore, q.CreationDate
    FROM Posts q
    JOIN Posts a ON a.ParentId = q.Id
    WHERE q.AcceptedAnswerId IS NULL
    GROUP BY q.Id, q.CreationDate
  ) q
  ON a.ParentId = q.Id
  (@username = '' OR u.DisplayName = @username)
  AND (@userId = -1 OR u.Id = @userId)
  AND a.Score = 0
  AND q.MaxAnswerScore = 0
ORDER BY a.CreationDate

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results