Don't touch my junk.

0

Please login or register to vote for this query.

(click on this box to dismiss)

DevOps Meta

Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

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

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results