Answers for Tridion (Scores and Numbers)


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 "User Link"
  ,count( as "Nr"
  ,sum(answers.score) as "Score"
from users
join posts answers on ( = answers.owneruserid)
join posts parent on (answers.parentid =
join posttags on ( = posttags.postid)
where posttags.tagid = @tag_id
and answers.posttypeid = 2  -- answers only
and answers.creationDate >  DATEADD(Month, -2, DATEADD(dd, DATEDIFF(dd, 0, getdate()), 0) )
group by
order by Nr desc

Enter Parameters

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