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.
Q&A for active researchers, academics and students of physics
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
FROM Posts a
WHERE a.PostTypeId = 2
AND a.ParentId = q.Id
AND a.Score > 0)
ORDER BY q.Id ASC