0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

  select top 40 t.id, t.tagname, count(pt.postid) K
  from tags t 
     inner join posttags pt
     on pt.tagid = t.id
  
  group by t.tagname, t.id
  order by count(pt.postid) desc

fork query

created jan 4 11 conradfrix