Tags in which an user meets the Generalist badge requirements

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

select T.TagName, sum(PA.Score) as TotalScore
from Tags T
inner join PostTags PT on PT.TagId = T.Id
inner join Posts PQ on PQ.Id = PT.PostId
inner join Posts PA on PA.ParentId = PQ.Id
inner join (
  select top 40 T.Id as TagId, count(P.Id) as QuestionCount
  from Tags T
  inner join PostTags PT on PT.TagId = T.Id
  inner join Posts P on P.Id = PT.PostId
  group by T.Id
  order by QuestionCount desc
  ) C on C.TagId = T.Id
where PA.OwnerUserId = ##UserId?811##
  and PA.CommunityOwnedDate is null
group by T.Id, T.TagName
having sum(PA.Score) >= 15
order by TotalScore desc

Enter Parameters

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