SELECT uq.Id AS QuestionAuthorId, uq.DisplayName AS Que...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping

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 q.Tags LIKE '%<aws-cloudformation>%';

Enter Parameters

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