0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select t.id,
  count(t.tagName) as synonym_count,
  string_agg(TagSynonyms.SourceTagName, ',') as synonyms,
  t.tagName,
  concat('stackoverflow.com/tags/',t.tagName ,'/info')
from tags t
left join TagSynonyms 
  on TagSynonyms.TargetTagName = t.tagName
group by t.tagName, t.id
order by  count(t.tagName) desc

fork query

edited may 4 21 Amir.Heshmati

created may 4 21 anonymous