0

Please login or register to vote for this query.

(click on this box to dismiss)

This query lists all users in a given location sorted by reputation.

Q&A for people looking to bypass life's everyday problems with simple tricks

-- List of Users in a given location
-- This query lists all users in a given location sorted by reputation.

-- Declare @location varchar = ##location##


SELECT Users.ID AS [User Link], Users.Reputation
FROM Posts, Users, PostTags, Tags
WHERE Posts.Id = PostTags.PostId and
location like '%##Location##%'
AND PostTags.TagId = Tags.Id
AND Tags.TagName = '##TagName##'
AND Posts.OwnerUserId = Users.Id
AND Users.Reputation >= ##MinReputation##
ORDER BY Posts.Id ASC;

fork query

edited nov 18 12 anonymous

created jun 15 10 lkessler