Questions Closed, Edited by Any User and Reopened

0

Please login or register to vote for this query.

(click on this box to dismiss)

Politics

Q&A for people interested in governments, policies, and political processes

SELECT i.PostId AS [Post Link]
  FROM PostHistory AS i
  INNER JOIN PostHistory AS c
    ON i.PostId = c.PostId
    AND i.PostHistoryTypeId = 1 -- Post Initial Title
    AND c.PostHistoryTypeId = 10 -- Post Closed
  INNER JOIN PostHistory AS e
    ON c.PostId = e.PostId
   AND e.PostHistoryTypeId = 5 -- Edit Body
   AND c.CreationDate < e.CreationDate
   AND i.UserId = e.UserId
  INNER JOIN PostHistory AS r
    ON c.PostId = r.PostId
   AND r.PostHistoryTypeId = 11 -- Reopen
   AND r.CreationDate > e.CreationDate
   WHERE i.CreationDate >= DATEADD(DAY, -15, GETDATE())
  GROUP BY i.PostId

Enter Parameters

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