Also finds tags that have a blank excerpt. Excludes tag synonyms.
Q&A for professional and enthusiast programmers
SELECT 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