Tag Count By Month/Year

1

Please login or register to vote for this query.

(click on this box to dismiss)

Lifehacks

Q&A for people looking to bypass life's everyday problems with simple tricks

SELECT MONTH(creationdate) MONTH, 
       YEAR(creationdate)  YEAR, 
       t.TagName, 
       COUNT(p.id)           cnt 
FROM   posts p 
       INNER JOIN posttags pt 
         ON p.id = pt.tagid 
       INNER JOIN tags t 
         ON pt.tagid = t.id 
WHERE  p.posttypeid = 1 
GROUP BY
       MONTH(creationdate),
       YEAR(creationdate),
       t.TagName

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results