select * -- t.TagName, t2.TagName, count(*) 'Frequency' f...

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 * -- t.TagName, 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
where 
ts.TargetTagName like 'asp.net-mvc%'

/*
inner join PostTags pt2
on pt.PostId = pt2.PostId and pt.TagId <> pt2.TagId
inner join Tags t2
on pt2.TagId = t2.Id
group by t.TagName, t2.TagName
order by 3 desc
*/

Enter Parameters

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