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
SELECT q.Id AS [Post Link],
q.AnswerCount = 0 THEN NULL -- don't show 0 if there are no answers to highlight questions that do have answers
END AS Answers,
q.CommunityOwnedDate IS NOT NULL THEN 'Yes'
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.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.Score ASC,