0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

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

view current version

edited jun 4 15

created jan 17 14 rolfl