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

3

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.)

Raspberry Pi

Q&A for users and developers of hardware and software for Raspberry Pi

SELECT Score,
       Id                                                                AS [Post Link],
       CASE WHEN AnswerCount = 0 THEN NULL ELSE AnswerCount END          AS Answers,
       CASE WHEN AcceptedAnswerId   IS NOT NULL THEN 'Yes' ELSE NULL END AS Accepted,
       CASE WHEN CommunityOwnedDate IS NOT NULL THEN 'Yes' ELSE NULL END AS Wiki,
       CommentCount                                                      AS Comments,
       ViewCount                                                         AS Views,
       OwnerUserId                                                       AS [User Link],
       ClosedDate                                                        AS ClosedDate
FROM   Posts
WHERE  ClosedDate IS NOT NULL -- closed
AND ClosedDate <= DATEADD(mm, -1, GETDATE())
AND (Score >= 0  OR (AnswerCount IS NOT NULL AND AnswerCount > 0)) -- either not downvoted, or has answers
AND Score < 20
ORDER BY Score ASC, ClosedDate

Enter Parameters

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