Monthly growth of given tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Drupal Answers Meta

Q&A about the site for Drupal developers and administrators

-- Enter Query Title
-- Enter Query Description

DECLARE @tag nvarchar(25) = ##tag:string##

select datepart(year, Posts.CreationDate), datepart(month, Posts.CreationDate) , count(tags.tagname) from Posts
inner join PostTags on PostTags.PostId = Posts.id
inner join tags on tags.id = PostTags.TagId
where tags.tagname = @tag
group by datepart(month, Posts.CreationDate), datepart(year, Posts.CreationDate)

Enter Parameters

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