A simply query to find users in your city or country. Added user links to the original version.
Q&A for professional, enthusiast and amateur photographers
-- 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 top 10 U.Id, U.Reputation, sum(P.Score), U.DisplayName from Posts P left join Users U on P.OwnerUserId = U.Id where Location like '%##Location##%' --and PostTypeid =1 and score > 0 and P.Tags like '%php%' group by U.Id, U.Reputation, U.DisplayName order by Reputation desc