0

Please login or register to vote for this query.

(click on this box to dismiss)

As the title suggests, this query will find all users for a tag and city and lists them on bases of their rank.

Q&A about the site for expert genealogists and people interested in genealogy or family history

-- Find all the top users for a tag and location

select distinct TOP(250) Users.Id [User Link], Users.Reputation
from Users
join Posts
  on Posts.OwnerUserId = Users.Id
where Users.Location like '%##Location##%'
and Posts.Tags like '%##Tags##%'
order by Users.Reputation desc

fork query

edited may 30 Frenk

created jan 27 16 anonymous