How many tags am I the "Top User" in?

0

Please login or register to vote for this query.

(click on this box to dismiss)

Open Data

Q&A for developers and researchers interested in open data

/*
select distinct qTags.TagId from Posts ans
join
  PostTags qTags on qTags.PostId = ans.ParentId
  
where 
ans.OwnerUserId = ##UserId##
and
ans.ParentId is not null
*/
select top 20 OwnerUserId, sum(Score), count(Score) from 
PostTags pt
  join Posts p on p.Id = pt.PostId
where 
pt.TagId = 1
group by OwnerUserId
order by sum(Score) desc, count(Score) desc

Enter Parameters

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