select u.Id, u.Reputation, u.WebsiteUrl, u.Location from ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

select u.Id, u.Reputation, u.WebsiteUrl, u.Location from Users as u
inner join (
  select a.OwnerUserId, sum(a.Score) as ScoreSum from Posts as a
  where a.ParentId in (
    select p.Id from Posts as p
    where p.Id in (
      select PostId from PostTags as pt
      where pt.TagId in (
        select Id from Tags
        where TagName in ('rust', 'swift', 'go')
      )
    )
  )
  group by a.OwnerUserId
  order by ScoreSum desc
  offset 0 rows
  fetch next 100 rows only
) as a on a.OwnerUserId = u.Id;

Enter Parameters

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