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

Ask Different

Q&A for power users of Apple hardware and software

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