See here for close reason 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
from posthistory p
inner join posthistorytypes q on p.posthistorytypeid = q.id
inner join posts r on p.PostId = r.Id
where q.id = 10