A simply query to find users in your city or country. Added user links to the original version.
Q&A for community managers, administrators, and moderators
-- 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
where Location like '%##Location##%'
order by Reputation desc