0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for movie and tv enthusiasts

SELECT
  DATEADD(m, DATEDIFF(m, 0, Posts.CreationDate), 0) AS Month,
  Tags.TagName AS Tag ,
  Count(*) AS Questions
FROM
  Tags
  LEFT JOIN PostTags ON PostTags.TagId = Tags.Id
  LEFT JOIN Posts ON Posts.Id = PostTags.PostId
  LEFT JOIN PostTypes ON PostTypes.Id = Posts.PostTypeId
WHERE
  Tags.TagName ='ionic'
  AND PostTypes.Name = 'Question'
  AND CreationDate >= DATEADD(m, DATEDIFF(m, 0, GETDATE())-50,0)
  AND CreationDate < DATEADD(m, DATEDIFF(m, 0, GETDATE()), 0)
GROUP BY
  Tags.TagName, DATEADD(m, DATEDIFF(m, 0, Posts.CreationDate), 0)
ORDER BY
  Tags.TagName, DATEADD(m, DATEDIFF(m, 0, Posts.CreationDate), 0);

fork query

edited sep 24 18 anonymous

created apr 5 16 Abtin.Forouzandeh