0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for physical fitness professionals, athletes, trainers, and those providing health-related needs

-- 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 jul 15 18 anonymous

created apr 17 13 Hossein Narimani Rad