Most common tags with missing wiki and excerpt

1

Please login or register to vote for this query.

(click on this box to dismiss)

Lists the most commonly used tags with empty/missing tag wikis (wiki or excerpt).

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT Count, ('site://tags/' + TagName + '|' + TagName) AS TagName
FROM Tags t
  LEFT JOIN Posts pe ON pe.Id = t.ExcerptPostId
  LEFT JOIN Posts pw ON pw.Id = t.WikiPostId
WHERE (ExcerptPostId IS NULL OR LEN(pe.Body) = 0)
  AND (WikiPostId    IS NULL OR LEN(pw.Body) = 0)
ORDER BY Count DESC

Enter Parameters

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