IronPython Questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Drupal Answers Meta

Q&A about the site for Drupal developers and administrators

WITH TagInfo AS (
    -- Get the tag information for 'flutter'
    SELECT Id AS TagId, TagName
    FROM Tags
    WHERE TagName = 'android-jetpack-compose'
),
Synonyms AS (
    -- Get synonyms for the 'flutter' tag
    SELECT s.SourceTagName AS Synonym, t.TagName
    FROM TagSynonyms s
    JOIN Tags t ON s.TargetTagName = t.TagName
    WHERE t.TagName = 'android-jetpack-compose'
),
AllTags AS (
    -- Combine the main tag and its synonyms
    SELECT TagName AS Tag
    FROM TagInfo
    UNION ALL
    SELECT Synonym
    FROM Synonyms
)
-- Get the count of questions for the main tag and its synonyms
SELECT t.TagName, COUNT(*) AS QuestionCount
FROM Posts p
JOIN PostTags pt ON p.Id = pt.PostId
JOIN Tags t ON pt.TagId = t.Id
WHERE t.TagName IN (SELECT Tag FROM AllTags)
GROUP BY t.TagName
ORDER BY QuestionCount DESC;

Enter Parameters

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