Questions with the largest count of total reviews (with their answers)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Reverse Engineering Meta

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

SELECT TOP 100
  COALESCE(PostsWithDeleted.ParentId, PostsWithDeleted.Id) AS [Post Link],
  COUNT(*) AS Count
FROM ReviewTasks, PostsWithDeleted
WHERE
  ReviewTasks.PostId
    = COALESCE(PostsWithDeleted.ParentId, PostsWithDeleted.Id)
GROUP BY COALESCE(PostsWithDeleted.ParentId, PostsWithDeleted.Id)
ORDER BY
  Count DESC,
  COALESCE(PostsWithDeleted.ParentId, PostsWithDeleted.Id);

Enter Parameters

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