List of Most reputed users in a given location - Case Sensitive

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.

Ukrainian Language

Q&A for linguists, teachers and students of the Ukrainian language

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

Enter Parameters

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