Posts count for all tags


Please login or register to vote for this query.

(click on this box to dismiss)

Health Meta

Q&A about the site for professionals in medical and allied health fields, students of those professions, related academics, and others with a sound understanding of medicine and healthcare-related sciences

-- @author: Moradnejad --
SELECT TagName, count(*) as cnt
from posts as p
inner join PostTags as pt on pt.PostId=p.Id
inner join Tags as t on t.Id=pt.TagId
) as t1
group by TagName
order by cnt desc

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results