Top Stackoverflow Arab Users

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans

Q&A for music historians, critics, and fans

-- Top Arab Users

SELECT
    TOP 200
    ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], 
    Id AS [User Link], 
    Reputation,
    Location,
    CreationDate,
    LastAccessDate,
    Views
FROM
    Users
WHERE
    LOWER(Location) like '%egypt%' or LOWER(Location) like '%algeria%'
    or LOWER(Location) like '%algerie%'
    or LOWER(Location) like '%iraq%' or LOWER(Location) like '%sudan%'
    or LOWER(Location) like '%morocco%' or LOWER(Location) like '%saudi%'
    or LOWER(Location) like '%yemen%' or LOWER(Location) like '%syria%'
    or LOWER(Location) like '%tunis%' or LOWER(Location) like '%somalia%'
    or LOWER(Location) like '%emirat%' or LOWER(Location) like '%jordan%'
    or LOWER(Location) like '%libya%' or LOWER(Location) like '%palestine%'
    or LOWER(Location) like '%lebanon' or LOWER(Location) like '%oman'
    or LOWER(Location) like '%kuwait%' or LOWER(Location) like '%mauritania%'
    or LOWER(Location) like '%qatar%' or LOWER(Location) like '%bahrain%'
    or LOWER(Location) like '%djibouti%' or LOWER(Location) like '%comoros%'
ORDER BY
    Reputation DESC;

Enter Parameters

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