TOP 500 users from Iran

0

Please login or register to vote for this query.

(click on this box to dismiss)

Lists the top 500 users (ranked by reputation) that are located in Iran according to their profile information. Thanks to http://data.stackexchange.com/stackoverflow/qe/1157/top-100-users-from-greece

Stack Overflow

Q&A for professional and enthusiast programmers

-- TOP 500 users from Iran
-- Lists the top 500 users (ranked by reputation) that are located in Iran according to their profile information.
-- Thanks to http://data.stackexchange.com/stackoverflow/qe/1157/top-100-users-from-greece

SELECT TOP 500
   Id,
   DisplayName,
   Reputation,
   WebsiteUrl,
   Location
FROM
   Users
WHERE
   Location like N'%Iran%'
   --DisplayName like '%oradnejad%'
   --OR Location like N'%Kozhi%'
   --OR Location like N'%Kerala%' 
ORDER BY
   reputation DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results