0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Drupal developers and administrators

-- Find users by location
-- Shows all the users for the supplied location parameter, sorted by reputation.  The parameter is a wild card.


SELECT TOP(200)
  u.Id,
  u.DisplayName,
  u.Reputation,
  u.WebsiteUrl,
  u.Age,
  u.LastAccessDate,
  u.Location
FROM Users u
WHERE u.Location like ##Location:string##
ORDER by u.Reputation DESC

fork query

edited feb 6 12

created feb 6 12 anonymous