Tag descriptions and wikis, all

0

Please login or register to vote for this query.

(click on this box to dismiss)

Lifehacks

Q&A for people looking to bypass life's everyday problems with simple tricks

SELECT
t.Id,
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
where LEN(x.Body) is not null 
ORDER BY t.Count DESC;

Enter Parameters

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