Most common duplicate targets for a tag

3

Please login or register to vote for this query.

(click on this box to dismiss)

Tag filtering is only used for the duplicate target post, not the child post.

Stack Overflow

Q&A for programmers

select top ##TopItems##
  parentPost.Id [Post Link],
  count(childPost.Id) [Dupe Links]
from Posts childPost
inner join PostLinks childPL on 
  childPost.Id = childPL.PostId and 
  childPL.LinkTypeId = 3
inner join Posts parentPost on childPL.RelatedPostId = parentPost.Id
inner join PostTags parentPostTags on parentPost.Id = parentPostTags.PostId
inner join Tags parentTag on 
  parentPostTags.TagId = parentTag.Id and
  parentTag.TagName = '##TargetTag##'
where childPost.PostTypeId = 1
group by parentPost.Id
order by [Dupe Links] desc

Enter Parameters

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