Top 40 tags

3

Please login or register to vote for this query.

(click on this box to dismiss)

Provides list of the top 40 tags. Modified from Journey to be a Generalist.

Ask Ubuntu

Q&A for Ubuntu users and developers

-- Top 40 tags
-- From Journey to be a Generalist



  select top 40 t.tagname, count(pt.postid) as numposts
  from tags t, posttags pt
  where pt.tagid = t.id
  group by t.tagname
  order by numposts desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results