0

Please login or register to vote for this query.

(click on this box to dismiss)

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

SELECT format(CreationDate,'yyyy - MM') AS Time, PostTypeId,
count(*) AS 'Number of Post'
FROM posts
WHERE PostTypeId = '1'
GROUP BY format(CreationDate,'yyyy - MM'),PostTypeId
ORDER BY Time DESC

fork query

edited jan 17 20

created jan 17 20 anonymous