Tags without excerpts ordered by use

0

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).

Philosophy Meta

Q&A about the site for those interested in the study of the fundamental nature of knowledge, reality, and existence

SELECT 
  t.tagname AS [TagName],
  t.count AS TagCount
FROM tags t
LEFT JOIN Posts e
  ON t.ExcerptPostId = e.Id
LEFT JOIN tagsynonyms ts
  ON ts.sourcetagname = t.tagname
  WHERE LEN(e.body) < 10
GROUP BY
  t.tagname,
  t.count
ORDER BY t.count DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results