select t2.TagName, count(*) 'Frequency' from TagSynonyms ts

0

Please login or register to vote for this query.

(click on this box to dismiss)

Emacs

Q&A for those using, extending or developing Emacs

select t2.TagName, count(*) 'Frequency' 
from 
TagSynonyms ts
inner join Tags t
on ts.SourceTagName = t.TagName
inner join PostTags pt
on t.Id = pt.TagId
inner join PostTags pt2
on pt.PostId = pt2.PostId and pt.TagId <> pt2.TagId
inner join Tags t2
on pt2.TagId = t2.Id
where 
ts.TargetTagName like 'asp.net-mvc%'
group by t2.TagName
order by 2 desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results