Don't touch my junk.

0

Please login or register to vote for this query.

(click on this box to dismiss)

Code Review

Q&A for peer programmer code reviews

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 meta site
loading Hold tight while we fetch your results