Posts which are not closed and have high number of reopen reviews


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow на русском Meta

Вопросы и ответы о сайте для программистов

SELECT TOP(##num?100##)
rt.PostId AS [Post Link],
timeline = 'site://posts/' + CAST(rt.PostId AS varchar)+'/timeline'
FROM ReviewTasks rt INNER JOIN Posts p ON p.Id=rt.PostId
WHERE (rt.ReviewTaskTypeId=##type?6##) AND (p.ClosedDate IS NULL)
GROUP BY rt.PostId
ORDER BY Count(rt.Id) DESC
----ReviewTaskTypeId (listed in ReviewTaskTypes)
----1 = Suggested Edit
----2 = Close Votes
----3 = Low Quality Posts
----4 = First Post
----5 = Late Answer
----6 = Reopen Vote
----7 = Community Evaluation
----8 = Link Validation
----9 = Flagged Posts
----10 = Triage
----11 = Helper

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results