Questions for Tridion in the last 12 months (Scores and Numbers)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Network Engineering

Q&A for network engineers

declare @tag_id int = (select id from tags where tagname = 'tridion');

select 
  users.id "User Link"
  ,count(questions.id) as "Nr"
  ,sum(questions.score) as "Score"
  
from users
join posts questions on (users.id = questions.owneruserid)
join posttags on (questions.id = posttags.postid)
where posttags.tagid = @tag_id
and questions.posttypeid = 1  -- questions only
and questions.creationDate >  DATEADD(Month, -12, DATEADD(dd, DATEDIFF(dd, 0, getdate()), 0) )
group by users.id
order by Nr desc

Enter Parameters

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