0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for serious players and enthusiasts of chess

-- Enter Query Title
-- Enter Query Description
select 
 Tags.TagName, 
 count(Posts.Id) as count 
from 
 Posts left join 
 PostTags on Posts.Id = PostTags.PostId Left Join 
 Tags on PostTags.TagId = Tags.Id 
where 
 Posts.PostTypeId = 1 
group by 
 Tags.TagName 
order by 
 count Desc

fork query

created aug 4 10 korneel