Find posts with over X duplicate targets linking back


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select distinct *
from (
  select count(*) as dups, 
   RelatedPostId as [Post Link]
  from PostLinks
   join Posts q on q.Id=RelatedPostId

  where LinkTypeId=3
  group by RelatedPostId

) d
where dups > ##numdupes##;

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results