Tag count by date

0

Please login or register to vote for this query.

(click on this box to dismiss)

ExpressionEngine® Answers

Q&A for administrators, end users, developers and designers for ExpressionEngine® CMS

select t.TagName, 
  count(case when p.CreationDate between '2007-1-1' and '2019-2-1' then 1 else null end) as Total
from Posts p
join PostTags pt on pt.PostId = p.Id
join Tags t on t.Id = pt.TagId
and t.TagName in ('css', 'cucumber', 'cuda', 'd', 'dart', 'elixir', 'elm')
group by t.TagName

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results