1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select distinct PostId AS [Post Link]
from PostHistory as ph
  inner join Posts as p
  on ph.PostId = p.Id
where ph.PostHistoryTypeId = 11 -- revision in which a post was reopened
and p.ClosedDate is null

fork query

edited sep 24 14

created sep 24 14 anonymous