This might give some interesting insight in the types of posts on a site..
Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more
-- Tags that are used together
-- This might give some interesting insight in the type of posts on a site..
SELECT TOP 20
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
GROUP BY t1.TagName, t2.TagName
ORDER BY COUNT(pt1.PostId) DESC