Questions that have gone through a close/reopen cycle at least once.
Q&A for programmers
-- Community Controversy
-- Questions that have gone through a close/reopen cycle at least once.
PostId AS [Post Link],
Id AS PostId,
(CASE WHEN ClosedDate IS NULL THEN 0 ELSE 1 END) AS CurrentlyClosed,
(SELECT COUNT(*) FROM PostHistory closed WHERE closed.PostId = p.Id AND closed.PostHistoryTypeId = 10) AS CloseCount,
(SELECT COUNT(*) FROM PostHistory opened WHERE opened.PostId = p.Id AND opened.PostHistoryTypeId = 11) AS ReopenCount
FROM Posts p
WHERE p.PostTypeId = 1
WHERE (CloseCount + ReopenCount) > 1
(CloseCount + ReopenCount) DESC,