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


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 for the full criteria.)

Motor Vehicle Maintenance and Repair Meta

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

       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]
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, ClosedDate

Enter Parameters

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