Questions that have been closed (not protected), along with their close reasons, ordered by their view count.
Q&A for professional and enthusiast programmers
q.ViewCount AS Views,
q.Id AS [Post Link],
WHEN '1' THEN 'Exact Duplicate'
WHEN '2' THEN 'Off-topic'
WHEN '3' THEN 'Subjective and argumentative'
WHEN '4' THEN 'Not a real question'
WHEN '7' THEN 'Too localized'
WHEN '10' THEN 'General reference'
WHEN '20' THEN 'Noise or pointless (Meta sites only)'
WHEN '101' THEN 'Duplicate'
WHEN '102' THEN 'Off-topic'
WHEN '103' THEN 'Unclear what you''re asking'
WHEN '104' THEN 'Too broad'
WHEN '105' THEN 'Primarily opinion-based'
END AS [Close Reason]
FROM Posts q
INNER JOIN PostHistory h ON q.Id = h.PostId
WHERE h.PostHistoryTypeId = 10
AND q.ViewCount >= 10000
AND q.ClosedDate IS NOT NULL
ORDER BY q.ViewCount DESC