WITH PostTagCombinations AS ( SELECT pt.PostId, STRING_AG...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Bicycles Meta

Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

WITH PostTagCombinations AS (
    SELECT 
        pt.PostId,
        STRING_AGG(t.TagName, ',') WITHIN GROUP (ORDER BY t.TagName) AS TagCombination
    FROM PostTags pt,
         Tags t
    WHERE pt.TagId = t.Id
    GROUP BY pt.PostId
),
CombinationCounts AS (
    SELECT 
        TagCombination,
        COUNT(*) AS CombinationCount
    FROM PostTagCombinations
    GROUP BY TagCombination
)
SELECT TOP 5
    TagCombination
FROM CombinationCounts
ORDER BY CombinationCount DESC;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results