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

1

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.

Cognitive Sciences Meta

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

SELECT q.Id               AS [Post Link],
       q.Score,
       CASE WHEN
         q.AnswerCount = 0 THEN NULL -- don't show 0 if there are no answers to highlight questions that do have answers
         ELSE q.AnswerCount
       END                AS Answers,
       CASE WHEN
         q.CommunityOwnedDate IS NOT NULL THEN 'Yes'
         ELSE NULL
       END                AS Wiki,
       q.ClosedDate       AS Closed,
       q.LastActivityDate AS [Last Active],
       q.OwnerUserId      AS [User Link]
FROM   Posts q
WHERE  q.PostTypeId = 1               -- get questions
       AND q.Score < 0                -- negatively voted questions
       AND q.ClosedDate IS NOT NULL   -- that are also 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.Score ASC,
          q.ClosedDate ASC

Enter Parameters

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