All reputation for a particular tag (answers + questions)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select p.OwnerUserId as [User Link]
     , sum(p.score) as post_repuation 
from posts p
inner join posttags pt on pt.postid = coalesce(p.parentid, p.id)
inner join tags t on t.id = pt.tagid
where p.OwnerUserId = ##userid?3702377##
-- and p.posttypeid = 2 -- answers
and t.tagname = ##TAG:string##
group by p.OwnerUserId

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results