Views per Month

1

Please login or register to vote for this query.

(click on this box to dismiss)

Robotics

Q&A for professional robotic engineers, hobbyists, researchers and students

SELECT
  DATEADD(month, DATEDIFF(month, 0, q.CreationDate), 0) AS Month,
  SUM(q.ViewCount) AS TotalViews
from posts as q
INNER JOIN PostTags AS P ON P.PostId = Q.Id
INNER JOIN Tags AS T ON T.Id = P.TagId
WHERE q.PostTypeId = 1 -- This filters to only questions (PostTypeId = 1)
AND (T.TagName = 'itext'
or T.TagName = 'xmlworker'
or T.TagName = 'itext7'
or T.TagName = 'itextpdf'
or T.TagName = 'itextsharp'
or T.TagName = 'itextg')
GROUP BY DATEADD(month, DATEDIFF(month, 0, q.CreationDate), 0)
ORDER BY Month DESC

Enter Parameters

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