Excludes tags that have been synonymized with another tag.
Q&A about the site for Ubuntu users and developers
SELECT t.TagName, t.Count AS [Q Count], --ex.Body AS [Excerpt], --wiki.Body AS [Wiki], CONCAT('https://stackoverflow.com/q/', ex.Id) AS [Wiki Link] FROM Tags t JOIN Posts ex ON ex.Id = t.ExcerptPostId JOIN Posts wiki ON wiki.Id = t.WikiPostId LEFT JOIN TagSynonyms ts ON ts.SourceTagName = t.TagName WHERE ex.Body = '' AND wiki.Body <> '' AND ts.Id IS NULL ORDER BY t.TagName ASC