Find Stack Overflow Users In Your City (with user-links)

0

Please login or register to vote for this query.

(click on this box to dismiss)

A simply query to find users in your city or country. Added user links to the original version.

Project Management Meta

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

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results