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 TOP ##topn:int?50## q.ViewCount AS Views, q.Score as score, q.Id AS [Post Link], h.Text FROM Posts q INNER JOIN PostHistory h ON q.Id = h.PostId WHERE h.PostHistoryTypeId = 10 AND h.Comment=##reason:int?103## AND q.ClosedDate IS NOT NULL ORDER BY score DESC