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


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.

Motor Vehicle Maintenance and Repair

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

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)

Enter Parameters

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