Posts that are the target of the most duplicate closures

2

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

SELECT
  COUNT(PostId) AS [DuplicateCount],
  RelatedPostId AS [Post Link]
FROM
  PostLinks AS pl
WHERE
  pl.LinkTypeId = 3 -- duplicate
GROUP BY
  RelatedPostId
ORDER BY
  [DuplicateCount] DESC

Enter Parameters

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