Don't touch my junk.

0

Please login or register to vote for this query.

(click on this box to dismiss)

English Language Learners

Q&A for speakers of other languages learning English

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 PostHistoryTypes 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