0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for gardeners and landscapers

SELECT

    uq.Id AS QuestionAuthorId,
    
    uq.DisplayName AS QuestionAuthor,

    q.Id as QuestionId,

    q.Body AS Question,

    ua.Id AS AnswerAuthorId,
    
    ua.DisplayName AS AnswerAuthor,    

    a.Id AS AnswerId,

    a.Body AS Answer
    
FROM Posts AS q

JOIN (

    SELECT

        p1.Id,

        p1.ParentId,

        p1.Body,

        p1.OwnerUserId

    FROM Posts AS p1

    WHERE p1.PostTypeId = 2

) AS a ON q.Id = a.ParentId

JOIN Users AS uq ON q.OwnerUserId = uq.Id

JOIN Users AS ua ON a.OwnerUserId = ua.Id

WHERE q.PostTypeId = 1

AND a.Id = q.AcceptedAnswerId

AND q.Tags LIKE '%<kubernetes>%';

view current version

edited feb 29

created feb 29 anonymous