Q&A about the site for biology researchers, academics, and students
select e.id, count(t.tagName), string_agg(TagSynonyms.SourceTagName, ',') as synonyms, t.tagName, e.body as 'Excerpt' from tags t left join Posts e on t.ExcerptPostId = e.Id left join Posts w on t.WikiPostId = w.Id left join TagSynonyms on TagSynonyms.TargetTagName = t.tagName group by t.tagName, e.body, w.body, e.id order by count(t.tagName) desc