Q&A for apps, scripts, and development with the Stack Exchange API
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);