Top Iranian users in StackOverflow, the other select queries have many issues, one of them that is suggested by Google select some users of Tirana from Albania. But my query works well and has a limitation to show users more than 999 reputations.
Q&A about the site for professional linguists and others with an interest in linguistic research and theory
-- top users: Iran -- List of Iranian-based users by reputation score. SELECT ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], Id AS [User Link], Reputation, Location FROM Users WHERE LOWER(Location) LIKE '%, iran%' OR LOWER(Location) = 'iran' AND Reputation >= 1000 ORDER BY Reputation DESC;