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)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

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],
  u2.Id AS [User Link],
FROM Posts q
  JOIN Users u ON q.OwnerUserId = u.Id
  JOIN Posts a ON a.ParentId = q.Id
  JOIN Users u2 ON a.OwnerUserId = u2.Id
  (@username = '' OR u.DisplayName = @username)
  AND (@userId = -1 OR u.Id = @userId)
  AND q.AcceptedAnswerId IS NULL
  AND q.ClosedDate IS NULL
GROUP BY q.Id, u.Id, q.CreationDate, u2.Id, a.CreationDate
HAVING MAX(a.Score) = 0
ORDER BY q.CreationDate

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results