Find users by location

5

Please login or register to vote for this query.

(click on this box to dismiss)

Shows all the users for the supplied location parameter, sorted by reputation. The Location parameter is an SQL wild card. For example: %Africa%

Monero Meta

Q&A for developers and users of the secure, private and untraceable cryptocurrency Monero

-- Find users by location
-- Shows all the users for the supplied location parameter, sorted by reputation.  The parameter is a wild card.
SELECT TOP(100)
  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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results