Most duplicated questions

1

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

SELECT TOP 200 count(*) AS dups, 
 q.Id AS [Post Link]

FROM PostLinks
 JOIN Posts q ON q.Id=RelatedPostId
 JOIN PostTags p ON p.PostId=q.Id
 JOIN Tags t ON p.TagId=t.id

WHERE
 LinkTypeId=3 AND
 q.Tags LIKE '%<##TagName##>%'

GROUP BY
q.Id,
q.ClosedDate,
q.Title

ORDER BY count(*) DESC

Enter Parameters

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