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,
IIF(0 < LEN(x.Body), 1, 0) AS xe, IIF(0 < LEN(d.Body), 1, 0) AS de
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

edited nov 23

created nov 23 b_jonas