0

Please login or register to vote for this query.

(click on this box to dismiss)

Gets a list of most reputed users from a given location.

Q&A for project managers

select Users.Id as [User Link], max(Users.Location) as Location, count(*)*10 as [Technology Reputation], max(Users.Reputation) as [Total Reputation]
  from Votes
  join Posts on Votes.PostId=Posts.Id
  join Users on Posts.OwnerUserId=Users.Id and Users.Id in 
  (select Users.Id from Users where lower(location) like lower('%Vienna%'))
  join Posts Questions on Posts.ParentId=Questions.Id
  where Questions.Tags like '%typescript%' or Questions.Tags like '%typescript%'
  and Users.Reputation >= 1000
  group by Users.Id
  order by [Technology Reputation] desc

fork query

edited mar 2 22 anonymous

created dec 19 13 jon.doe12449