Most popular duplicate targets by tag

2

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 top 200 p.id as [Post Link],count(l.relatedpostid),p.title as [Title]
from posts p,postlinks l
where p.id=l.relatedpostid
and l.linktypeid=3
and p.tags like '%' + ##TagName:string## + '%'
group by l.relatedpostid,p.id,p.title
order by 2 desc;

Enter Parameters

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