Gets a list of most reputed users from a given location.
Q&A for people who love being outdoors enjoying nature and wilderness, and learning about the required skills and equipment
-- List of Users in a given location SELECT Top ##Top## ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], Id AS [User Link], * FROM Users WHERE location like '%##Location##%' ORDER BY Reputation DESC