2

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for amateur radio enthusiasts

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?200## 

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

fork query

edited jun 20 18

created may 23 15 bigOTHER