0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Drupal developers and administrators

DECLARE @TagName NVarChar(50) = '##TagName##'



SELECT COUNT(Id), Year(CreationDate), Month(CreationDate) FROM Posts
WHERE PostTypeId = 1
AND Tags LIKE '%<' + @TagName+'>%'
GROUP BY Year(CreationDate), Month(CreationDate)
ORDER BY Year(CreationDate), Month(CreationDate)

fork query

edited mar 12 12

created mar 12 12 GregB