Top tags based on question count

0

Please login or register to vote for this query.

(click on this box to dismiss)

Select 200 tags with most questions

Islam Meta

Q&A about the site for Muslims, experts in Islam, and those interested in learning more about Islam

-- Top tags based on question count
-- Select 200 tags with most questions

select top 1000 t.tagname as 'Tag', count(tagid) as 'Questions'
from tags t join posttags pt on pt.tagid = t.id
group by t.id, t.tagname 
order by count(tagid) desc 

Enter Parameters

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