Q&A for Joomla! administrators, users, developers and designers
SELECT TagName, count(*) as CNT FROM ( SELECT p.id, T.TagName 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