Wikiless tags

0

Please login or register to vote for this query.

(click on this box to dismiss)

Show tags that have no wiki excerpt or no wiki body.

Stack Overflow

Q&A for programmers

SELECT
  'site://tags/' + t.TagName + '|' + t.TagName AS [Tag],
  t.Count AS [Uses],
  e.Body AS [Excerpt],
  b.Body AS [Wiki]
FROM Tags t
LEFT JOIN Posts e ON e.Id = t.ExcerptPostId
LEFT JOIN Posts b ON b.Id = t.WikiPostId
WHERE (e.Body IS NULL OR b.Body IS NULL OR Len(e.Body) = 0 OR Len(b.Body) = 0)
ORDER BY Count DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached