0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

SELECT

    q.Body AS Question,

    a.Body AS Answer
    
FROM Posts AS q

JOIN (

    SELECT

        p1.Id,

        p1.ParentId,

        p1.Body,

        p1.OwnerUserId,

        p1.Score

    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 '%<java>%'

ORDER BY a.Score DESC;

fork query

created jun 3 anonymous