SELECT DISTINCT U.UserId AS UserID, P.Id AS PostID, T.Tag...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Language Learning

Q&A for students, teachers, polyglots, and anyone interested in the techniques of second-language acquisition

SELECT
    DISTINCT U.UserId AS UserID,
    P.Id AS PostID,
    T.TagName AS PostTag
FROM
    (
        SELECT
            UserId,
            PostId
        FROM
            Comments
    
        UNION
    
        SELECT
            OwnerUserId AS UserId,
            Id AS PostId
        FROM
            Posts
    ) U
JOIN
    Posts P ON U.PostId = P.Id
JOIN
    PostTags PT ON P.Id = PT.PostId
JOIN
    Tags T ON PT.TagId = T.Id;

Enter Parameters

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