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.

Q&A for professional and enthusiast 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

fork query

edited jun 14 12

created jun 14 12 Gilles