A simply query to find users in your city or country. Added user links to the original version.
Q&A about the site for people seeking specific hardware recommendations
-- Find Stack Overflow Users In Your City (with user-links) -- A simply query to find users in your city or country. Added user links. --select Id [User Link], Reputation, DisplayName, Location --from Users --where Location like '%##Location##%' --order by Reputation desc DECLARE @tagName nvarchar(35) = '##tagName##' select * from (SELECT top 50 TagName, SUM(case votes.votetypeid WHEN 2 THEN 1 -- upvote WHEN 3 THEN -1 -- downvote END) as Rep, Users.Id [User Link], Users.Id, number = ROW_NUMBER() OVER (ORDER BY TagName) FROM Tags INNER JOIN PostTags ON PostTags.TagId = Tags.id INNER JOIN Posts ON Posts.ParentId = PostTags.PostId INNER JOIN Users ON Posts.OwnerUserId = Users.Id INNER JOIN Votes ON Votes.PostId = Posts.Id WHERE Tags.TagName = @tagName AND Posts.CommunityOwnedDate IS NULL GROUP BY TagName, DisplayName, Users.Id ORDER BY Rep DESC) t JOIN Users u on t.Id = u.Id where u.Location like '%##Location##%' order by Reputation desc