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.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