Gets a list of most reputed users from a given location.
Q&A about the site for professional and independent game developers
-- List of Users in a given location SELECT Top ##Top## ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], Id AS [User Link], Reputation, Location, CreationDate, LastAccessDate, UpVotes, DownVotes FROM Users WHERE LOWER(location) like LOWER('%##Location##%') ORDER BY Reputation DESC