Question Views per tag last 6 months

0

Please login or register to vote for this query.

(click on this box to dismiss)

Enter Query Description

SharePoint

Q&A for SharePoint enthusiasts

-- Question Views per tag last 6 months
-- Enter Query Description

SELECT  tagname, SUM(p.ViewCount) k
FROM 
Posts p 
INNER JOIN PostTags pt
ON p.iD = pt.PostId
INNER JOIN Tags t
ON pt.TagID = t.Id
WHERE
p.PostTypeId = 1
and p.creationDate >  DATEADD(Month, -6, DATEADD(dd, DATEDIFF(dd, 0, getdate()), 0) )
GROUP BY tagName

Enter Parameters

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