A simply query to find users in your city or country. Added user links to the original version.
Q&A about the site for project managers
-- 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 u.id as [User Link] , sum(score) as totalscore from posts p inner join posttags pt on pt.postid = p.id or pt.postid = p.parentid inner join tags t on t.id = pt.tagid inner join users u on u.id = p.owneruserid where tagname = ##tag1:string## collate SQL_Latin1_General_CP1_CI_AI and location like '%'+ ##location:string## + '%' collate SQL_Latin1_General_CP1_CI_AI group by u.id order by sum(score) desc