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.Id AS [Post Link] -- h.Comment, -- h.PostId FROM Posts q INNER JOIN PostTypes pt ON q.PostTypeId = pt.id INNER JOIN CloseAsOffTopicReasonTypes cotrt ON cotrt.Id = pt.id --INNER JOIN PostHistory h ON q.Id = h.PostId --WHERE h.PostHistoryTypeId = 10 -- AND h.Comment=##reason:int?102## -- AND q.ClosedDate IS NOT NULL --ORDER BY score ASC