Top Users from Algeria / أعلى المستخدمين من الجزائر

0

Please login or register to vote for this query.

(click on this box to dismiss)

Esperanto Language

Q&A for teachers and students of the Esperanto language

SELECT TOP ##Count:int?100##
        ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#],
        Id AS [User Link],
        Reputation,
        -- Id AS ID,
        Location,
        WebsiteUrl as Wesbite,
        LastAccessDate AS Seen,
        -- Views,
        -- UpVotes,
        -- DownVotes,
        CreationDate   
        
FROM Users 
WHERE 
        Reputation >= ##MinimalReputation:int?1## 

        AND (
               UPPER(Location) LIKE UPPER('%Algeria%')
               OR UPPER(Location) LIKE UPPER('%Algerie%')
               OR UPPER(Location) LIKE UPPER('%جزائر%')
               )
       AND Id like '%isi%'
             
ORDER BY Reputation DESC

Enter Parameters

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