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 COUNT(pt.PostId), YEAR(p.CreationDate) FROM Posts as p
LEFT JOIN PostTags as pt ON p.Id = pt.PostId
LEFT JOIN Tags AS t ON pt.TagId = t.Id
WHERE t.TagName = 'javascript'
GROUP BY p.CreationDate

fork query

edited sep 20 anonymous

created mar 3 14 Shadow Wizard