Questions ripe for deletion: Unanswered, downvoted, and closed questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Want to exercise your democratic 10k rights? Can't find questions to delete? Want to give that barrel a good ol' bottom-scraping? Behold, the worst questions ever. Sorted by score and how long they've been closed.

Physics

Q&A for active researchers, academics and students of physics

SELECT q.Id
FROM   Posts q
WHERE  q.PostTypeId = 1               -- get questions
       AND q.ClosedDate IS NULL       -- that are NOT already closed
       AND q.AcceptedAnswerId IS NULL -- and do not have an accepted answer
       AND (q.AnswerCount IS NULL     -- and do not have any upvoted answers
            OR q.AnswerCount = 0      -- strangely enough, AnswerCount can be either 0 or NULL
            OR NOT EXISTS (           -- there is probably a better way of doing this but whatever
              SELECT Id
              FROM   Posts a
              WHERE  a.PostTypeId = 2
                     AND a.ParentId = q.Id
                     AND a.Score > 0)
           )
ORDER  BY q.Id ASC

Enter Parameters

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