0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

Select q.Id as [Post Link],
       q.Score,
       q.OwnerUserId as [User Link],
       q.CreationDate as [Created],
       q.ClosedDate as [Closed]
from Posts q
inner join PostHistory ph on q.Id = ph.PostId
where PostTypeId = 1
  and ClosedDate is not null
  and ph.PostHistoryTypeId = 10
  and ph.Comment = 104
order by q.Score DESC

fork query

edited may 21 15

created may 21 15 rolfl