Questions by top count of deleted votes

1

Please login or register to vote for this query.

(click on this box to dismiss)

Blender Meta

Q&A about the site for people who use Blender to create 3D graphics, animations, or games

WITH Raw AS (
  SELECT TOP ##TopN:int?100##
    COALESCE(PostsWithDeleted.ParentId, PostsWithDeleted.Id) AS PostId,
    COUNT(*) AS Count
  FROM PostsWithDeleted, Votes
  WHERE
    Votes.PostId = PostsWithDeleted.Id
    AND
    PostsWithDeleted.DeletionDate IS NOT NULL
    AND
    PostsWithDeleted.PostTypeId BETWEEN 1 AND 2
  GROUP BY COALESCE(PostsWithDeleted.ParentId, PostsWithDeleted.Id)
  ORDER BY Count DESC
)
SELECT
  'site:///questions/' + CAST(PostId AS VARCHAR(MAX)) + '?noredirect=1|'
    + CAST(PostId AS VARCHAR(MAX)) AS [Post Link ],
  Count
FROM Raw
ORDER BY Count DESC, PostId

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results