0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Ubuntu users and developers

SELECT TOP 5
   t1.TagName AS [Tag Link], t2.TagName AS [Tag Link], COUNT(pt1.PostId) AS [Post Count]
FROM PostTags pt1 
   JOIN PostTags pt2 ON pt1.PostId = pt2.PostId
   JOIN Tags t1 ON t1.Id = pt1.TagId
   JOIN Tags t2 ON t2.Id = pt2.TagId
WHERE t1.TagName < t2.TagName AND
    t1.TagName LIKE ##TagName:string##
GROUP BY t1.TagName, t2.TagName
ORDER BY COUNT(pt1.PostId) DESC

fork query

edited feb 23 18

created feb 23 18 anonymous