Generalist Qualifying Users

4

Please login or register to vote for this query.

(click on this box to dismiss)

The users and how many tags they have with more than 15 score in the top 40. .... need 20 tags with score >= 15 in order to qualify for Generalist.

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

with tags40 as (
  select top 40 TagId from posttags group by tagid order by count(*) desc
), answerers as (
  select OwnerUserId as UserId
  from posts
  where PostTypeId = 2
  group by OwnerUserId
  having count (*) >= 45
), tagsoup as (
  select u.UserId, t.TagId, sum(case when VoteTypeId = 2 then 1 else -1 end) as [TagScore]
  from answerers u,
       posts a,
       posts q,
       votes v,
       tags40 t,
       PostTags pt
  where u.UserId = a.OwnerUserId
    and a.ParentId = q.Id
    and a.parentId = pt.PostId
    and pt.TagId = t.TagId
    and a.Id = v.PostId
    and v.VoteTypeId in (2, 3)
    and a.CommunityOwnedDate is null
    and q.CommunityOwnedDate is null
  group by u.UserId, t.TagId
)

select UserId as [User Link], Tags.TagName as [Tags], TagScore
from TagSoup,
     Tags
where UserId = 31503
  and TagScore >= 15
  and Tags.Id = TagId
order by tagscore desc

Enter Parameters

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