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 (SELECT 1)) AS RowId, TagName, [Count], concat('| [tag:', concat(TagName, concat('] | ', concat([Count], ' | ')))) AS [Easy Table 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