Q&A about the site for speakers of other languages learning English
SELECT ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], Id AS [User Link], DisplayName, Reputation, Location, Views, ProfileImageUrl, AboutMe FROM Users WHERE Reputation >= '##repcap##' AND LOWER(Location) LIKE LOWER('%##Location##%') ORDER BY Reputation DESC;