0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for enthusiasts and scholars of mythology and folklore

-- top users: Iran
-- List of Iran-based users by reputation score.
-- 

SELECT
TOP (200) ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], 
    Id AS [User Link], Location, LastAccessDate,
    Reputation
FROM
    Users
WHERE
    LOWER(Location) LIKE '%iran'
    OR LOWER(Location) LIKE 'tehran'
    OR LOWER(Location) LIKE 'shiraz'
    OR LOWER(Location) LIKE 'tabriz'
    OR LOWER(Location) LIKE 'mashhad'
    OR LOWER(Location) LIKE 'esfahan'
    OR LOWER(Location) LIKE 'kerman'
    OR LOWER(Location) LIKE 'kermanshah'
    OR LOWER(Location) LIKE 'zanjan'
    OR LOWER(Location) LIKE 'ahvaz'
    OR LOWER(Location) LIKE 'ahwaz'
    OR LOWER(Location) LIKE 'azarbaijan'
    OR LOWER(Location) LIKE 'azerbaijan'
    OR LOWER(Location) LIKE 'semnan'
    OR LOWER(Location) LIKE 'bafq'
    OR LOWER(Location) LIKE 'qom'
    OR LOWER(Location) LIKE 'hamedan'
    OR LOWER(Location) LIKE 'hamadan'
    OR LOWER(Location) LIKE 'jahrom'
    OR LOWER(Location) LIKE 'bushehr'
    OR LOWER(Location) LIKE 'ardebil'
    OR LOWER(Location) LIKE 'urmia'
    OR LOWER(Location) LIKE 'karaj'
    OR LOWER(Location) LIKE 'qazvin'
    OR LOWER(Location) LIKE 'golestan'
    OR LOWER(Location) LIKE 'gorgan'
    OR LOWER(Location) LIKE 'yazd'
ORDER BY
    Reputation DESC;

fork query

edited sep 22 19 anonymous

created apr 17 13 Hossein Narimani Rad