A simply query to find users in your city or country. Added user links to the original version.
Q&A for Joomla! administrators, users, developers and designers
-- 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