Questions with most close/reopen cycles

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP ##topn:int?50##
   p.Id AS [Post Link], MAX(p.ClosedDate) AS CurrentCloseDate, COUNT(*) AS ClosePlusReopenCount
FROM Posts p INNER JOIN PostHistory h ON p.Id=h.PostId
WHERE h.PostHistoryTypeId=10 or h.PostHistoryTypeId=11
GROUP BY p.Id
ORDER BY ClosePlusReopenCount DESC

Enter Parameters

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