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 ##NumResults:int?50## p.Id, 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 --inner join pendingflags pf on p.Id = pf.PostId where pht.id = 10 --and pf.CloseAsOffTopicReasonTypeId = ##CustomCloseReason:int?4##