A simply query to find users in your city or country. Added user links to the original version.
Q&A for serious players and enthusiasts of poker
-- 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
DECLARE @tagName nvarchar(35) = '##tagName##'
select * from (SELECT top 50
WHEN 2 THEN 1 -- upvote
WHEN 3 THEN -1 -- downvote
END) as Rep,
Users.Id [User Link],
number = ROW_NUMBER() OVER (ORDER BY TagName)
INNER JOIN PostTags ON PostTags.TagId = Tags.id
INNER JOIN Posts ON Posts.ParentId = PostTags.PostId
INNER JOIN Users ON Posts.OwnerUserId = Users.Id
INNER JOIN Votes ON Votes.PostId = Posts.Id
WHERE Tags.TagName = @tagName
AND Posts.CommunityOwnedDate IS NULL
GROUP BY TagName, DisplayName, Users.Id
ORDER BY Rep DESC) t
JOIN Users u on t.Id = u.Id
where u.Location like '%##Location##%'
order by Reputation desc