Q&A for music historians, critics, and fans
select top 5 targettagname, count(sourcetagname) as counts into #tempTable from tagsynonyms group by targettagname order by count(sourcetagname) desc select distinct t.targettagname, t.counts, s.sourcetagname from #tempTable t left join tagsynonyms s on t.targettagname = s.targettagname order by t.counts desc