Top Pandas Duplicates

0

Please login or register to vote for this query.

(click on this box to dismiss)

Operations Research Meta

Q&A about the site for operations research and analytics professionals, educators, and students

select top 10000
 PL.RelatedPostId as [Post Link],
 count(*) as "Number of duplicates"

from PostLinks PL
 join (select distinct P.Id from Posts P
     join PostTags PT on PT.PostId = P.Id
     join Tags T on T.Id = PT.TagId
     where T.TagName in ('pandas')
 ) as P on P.Id = PL.RelatedPostId

where LinkTypeId=3

group by PL.RelatedPostId
order by count(*) desc

Enter Parameters

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