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

Robotics Meta

Q&A about the site for professional robotic engineers, hobbyists, researchers and students

       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

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