Q&A for ebook publishers and readers
select Q.id as [Post Link], Q.CreationDate, Q.ClosedDate, ph.Comment, pht.Name from Posts Q inner join PostHistory ph on Q.id = ph.PostId and ph.PostHistoryTypeId = 10 left outer join CloseReasonTypes pht on ph.Comment = pht.Id where Q.PostTypeId = 1 and Q.CreationDate > '1 May 2015' and Q.ClosedDate is not null order by Q.ClosedDate