Lists the top 100 users (ranked by reputation) that are located in Greece according to their profile information. A range of options is used to pinpoint members from Greece based on popular locations used.
Q&A about the site for gamemasters and players of tabletop, paper-and-pencil role-playing games
-- TOP 100 users from Greece -- Lists the top 100 users (ranked by reputation) that are located in Greece according to their profile information. -- A range of options is used to pinpoint members from Greece based on popular locations used. SELECT TOP 100 Id as [User Link], Reputation, WebsiteUrl, Location FROM Users WHERE Location like N'%Thess%' OR Location like N'%Gr' OR Location like N'%Patra%' ORDER BY reputation DESC