Tags without excerpts ordered by use

2

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

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

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 e.id IS NULL
  AND ts.id IS NULL
GROUP BY
  t.tagname,
  t.count
ORDER BY t.count DESC

Enter Parameters

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