0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for serious players and enthusiasts of chess

WITH TOP_TAGS AS (
SELECT TOP 5 P1.TagId AS 'TagId1'
,P2.TagId AS 'TagId2'
FROM PostTags P1
INNER JOIN PostTags P2 ON P1.PostId = P2.PostId
AND P1.TagId < P2.TagId
GROUP BY P1.TagId, P2.TagId
ORDER BY Count(*) DESC
)
SELECT T.TagName
FROM TOP_TAGS TT
INNER JOIN Tags T ON T.Id = TT.TagId1
OR T.Id = TT.TagId2

view current version

edited sep 20

created sep 20 Janis123