Questions with multiple duplicate targets

1

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics

Q&A for people studying math at any level and professionals in related fields

SELECT TOP(##num?1000##)
  p.Id AS [Post Link],
  'site://q/' + CAST(p.Id AS varchar),
  'site://posts/' + CAST(p.Id AS varchar)+'/revisions' AS [Revision History],
  COUNT(pl.RelatedPostId) AS [# of duplicates]
FROM Postlinks pl INNER JOIN Posts p ON pl.PostId=p.Id
WHERE (pl.LinkTypeId=3) AND (p.PostTypeId=1)
GROUP BY p.ID
HAVING COUNT(pl.RelatedPostId)>1
ORDER BY COUNT(pl.RelatedPostId) DESC

Enter Parameters

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