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 10 ph.PostId, p.Id AS [Post Link] from posthistory ph inner join posthistorytypes pht on ph.posthistorytypeid = pht.id inner join posts p on ph.PostId = p.Id where pht.id = 10