0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Ubuntu users and developers

select top(10) t.tagname
     , count(*) as [# posts per tag/location]
from posts p
inner join posttags pt on p.id = pt.postid
inner join tags t on t.id = pt.tagid
group by t.tagname
order by count(*) desc

fork query

edited nov 7 21 anonymous

created jan 16 12 sam.saffron