Also finds tags that have a blank excerpt. Excludes tag synonyms.
Q&A for folks dedicated to a lifestyle that can be maintained indefinitely without depleting available resources
SELECT ROW_NUMBER() OVER(ORDER BY [Count] DESC, TagName) AS RowId, TagName, [Count], concat('1. [tag:',concat(TagName,concat('] (', concat([Count],')')))) AS [Easy List Formatting] FROM Tags LEFT JOIN Posts pe on pe.Id = Tags.ExcerptPostId LEFT JOIN TagSynonyms on SourceTagName = Tags.TagName WHERE coalesce(len(pe.Body),0) = 0 and ApprovalDate is null ORDER BY [Count] DESC, TagName