Top 10 duplicate Questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping

Q&A for gardeners and landscapers

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

from PostLinks
 join Posts q on q.Id=RelatedPostId
 join PostTags pq on pq.PostId = q.ParentId

where LinkTypeId=3

group by RelatedPostId
order by count(*) desc

Enter Parameters

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