SELECT tagname, count, a.body AS ExcerptBody, b.body AS ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

SELECT  tagname,
        count,
        a.body AS ExcerptBody,
        b.body AS WikiBody
FROM    (
    SELECT  tagname,
            count,
            wikipostid,
            body
    FROM    tags
    JOIN    posts   ON tags.excerptpostid = posts.id
    WHERE   count > 10
) AS a
LEFT JOIN   posts AS b  ON a.wikipostid = b.id

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results