Questions with any of the tags

0

Please login or register to vote for this query.

(click on this box to dismiss)

Finds all questions with more than two of: [support], [discussion], [feature-request], [bug].

Tridion

Q&A for Tridion developers and administrators

-- Questions with any of the tags
-- Finds all questions with more than two of: [quorum] [geth] [go-quorum]

WITH RequiredTagIds AS
(
    SELECT Id
        FROM Tags
        WHERE TagName IN ('geth', 'go-ethereum', 'quorum')
)
SELECT
    Id AS [Post Link],
    RequiredTagCount,
    AnswerCount AS cevap_sayisi,
    CommentCount AS yorum_sayisi,
    FavoriteCount AS favori_sayisi,
    ViewCount AS goruntulenme_sayisi,
    Score AS skor,
    CASE WHEN AcceptedAnswerId IS NULL THEN 0 ELSE 1 END AS OnaylanmisCevapVarMi
    
    FROM
    (
        SELECT
            p.Id,
            p.AnswerCount,
            p.CommentCount,
            p.FavoriteCount,
            p.ViewCount,
            p.Score,
            p.AcceptedAnswerId,
            (
                SELECT COUNT(*) FROM PostTags pt
                    WHERE
                        (pt.PostId = p.Id) AND
                        (pt.TagId IN (SELECT Id FROM RequiredTagIds))
            ) AS RequiredTagCount
            FROM Posts p
            WHERE p.PostTypeId = 1
    ) a
    WHERE RequiredTagCount > 0

Enter Parameters

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