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..

Anime and Manga

Q&A for anime and manga fans

-- 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 to meta site
loading Hold tight while we fetch your results