Tags that are used together - Manual edition

5

Please login or register to vote for this query.

(click on this box to dismiss)

This might give some interesting insight in the types of tags used together..

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

-- Tags that are used together - Manual edition
-- This might give some interesting insight in the types of tags used together..

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

Enter Parameters

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