0

Please login or register to vote for this query.

(click on this box to dismiss)

See here for close reason types: http://data.stackexchange.com/stackoverflow/query/36599/show-all-types Note that if a question has been closed and reopened multiple times, all reasons will show up in the results.

Q&A for professional and enthusiast programmers

SELECT
  q.ViewCount AS Views,
  q.Id AS [Post Link],
  CASE h.Comment
    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

view current version

edited jul 4 14 anonymous

created dec 3 11 Mark Trapp