SELECT t.TagName AS name, COUNT(t.TagName) AS count FROM...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS Meta

Q&A about the site for administrators, end users, developers and designers for Craft CMS

-- Enter Query Title
-- Enter Query Description

SELECT 
  t.TagName AS name, 
  COUNT(t.TagName) AS count 
FROM 
  Posts as p 
LEFT JOIN 
  PostTags as pt ON pt.PostId = p.Id
LEFT JOIN 
  Tags as t ON t.Id = pt.TagId
GROUP BY t.TagName
ORDER BY count DESC;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results