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