0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for science fiction and fantasy enthusiasts

SELECT 
t.Count, t.TagName, 
x.Body AS ExcerptText, d.Body AS WikiText
FROM (Tags AS t 
LEFT JOIN Posts AS x ON t.ExcerptPostId = x.Id)
LEFT JOIN Posts AS d ON t.WikiPostId = d.Id
ORDER BY t.Count DESC;

fork query

created nov 23 b_jonas