Questions closed for a specific reason

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.

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT  
  q.Score AS Score,
  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],
  q.ClosedDate
FROM Posts q
INNER JOIN PostHistory h ON q.Id = h.PostId
WHERE h.PostHistoryTypeId = 10
  AND q.Score >= 10
  AND q.ClosedDate IS NOT NULL
ORDER BY q.Score DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results