NoSQL datastore questions by year

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

select tags.tagname, year(cast(Posts.CreationDate As Date)) as year, count(Posts.id) 
from
  Tags, PostTags, Posts
  where Tags.TagName IN ('cassandra','scylla','mongodb')
and Tags.Id = PostTags.TagId
and PostTags.PostId = Posts.id
and Posts.CreationDate > '2013-01-01'
and Posts.CreationDate < '2020-01-01'
GROUP BY tags.tagname, year(cast(Posts.CreationDate As Date))
ORDER BY tags.tagname, year DESC

Enter Parameters

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