Closed questions that won't be auto-deleted within a month

1

Please login or register to vote for this query.

(click on this box to dismiss)

Closed questions that either have answers or haven't been downvoted. These won't go away unless you make them. (This only checks for the 30-days rule; see http://meta.stackoverflow.com/a/92006 for the full criteria.)

Software Engineering

Q&A for professionals, academics, and students working within the systems development life cycle

SELECT Score,
       Id                                                       AS [Post Link],
       CASE WHEN AnswerCount = 0 THEN NULL ELSE AnswerCount END AS Answers,
       OwnerUserId                                              AS [User Link]
FROM   Posts
WHERE  ClosedDate IS NOT NULL -- closed
       AND (Score >= 0 OR (AnswerCount IS NOT NULL AND AnswerCount > 0)) -- either not downvoted, or has answers
ORDER  BY Score ASC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results