number of posts per month by tagname

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT Posts.Id, 
      MONTH(Posts.CreationDate) AS postmonth, 
      YEAR(Posts.CreationDate) AS postyear,
      PostTags.*,
      Tags.Id,
      Tags.TagName
FROM Posts, PostTags, Tags
WHERE
  PostTags.PostId = Posts.id AND PostTags.TagId = Tags.id

Enter Parameters

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