Q&A for meta-discussion of the Stack Exchange family of Q&A websites
SELECT CONCAT('site://q/', q.Id) Link, -- magic column runs out of query resources... q.Id, q.CreationDate, MAX(a.Score) MaxAnswerScore, COUNT(*) AnswerCount FROM Posts q INNER JOIN Posts a ON a.ParentId = q.Id -- rule: at least one answer WHERE q.Score >= 0 -- rule: question score AND q.ClosedDate IS NULL -- rule: question not closed AND q.DeletionDate IS NULL -- rule: question not deleted AND a.DeletionDate IS NULL -- rule: answer not deleted (maybe redundant) AND q.AcceptedAnswerId IS NULL -- rule: no accepted answer AND DATEDIFF(DAY, q.LastActivityDate, GETDATE()) > 30 -- rule: 30 days inactive GROUP BY q.Id, q.CreationDate HAVING MAX(a.Score) = 0 -- rule: answer score, at least one answer scoring 0 ORDER BY CreationDate DESC