Tag distribution

3

Please login or register to vote for this query.

(click on this box to dismiss)

History of Science and Math

Q&A for people interested in the history and origins of science and mathematics

-- tagname:Name of tag 

select row_number() over (order by count(*) desc) as [#]
     , 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

Enter Parameters

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