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