Cassandra, CQL posts per year


Please login or register to vote for this query.

(click on this box to dismiss)

Joomla Meta

Q&A about the site for Joomla! administrators, users, developers and designers

SELECT YEAR(p.creationdate) as year, SUM(1) as questionCount
FROM PostTags pt
INNER JOIN Posts p ON = pt.postid
WHERE pt.TagId = 34113
AND p.posttypeid=2
GROUP BY YEAR(p.creationdate)

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results