SELECT t.TagName AS name, DATEPART("yy", p.CreationDate)...

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,
  DATEPART("yy", p.CreationDate) + DATEPART("mm", p.CreationDate) + DATEPART("dd", p.CreationDate) AS creation_date
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