SELECT CONCAT('site://q/', q.Id) Link, -- magic column ru...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Meta Stack Exchange

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

Enter Parameters

Options:
Switch sites
loading Hold tight while we fetch your results