3

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- tagname:Name of tag 

select tc.tagname
     , count(*) as [count]
from tags tc
inner join posttags ptc on ptc.tagid = tc.id
inner join posttags pt on pt.postid = ptc.postid
inner join tags t on pt.tagid = t.id
where t.tagname = ##tagname:string##
and tc.tagname <> ##tagname:string##
group by tc.tagname
order by count(*) desc

fork query

edited may 30 17

created jul 6 14 rene