A simply query to find users in your city or country. Added user links to the original version.
Q&A for administrators and users of the CiviCRM Constituent Relationship Management software
-- 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