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

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS

Q&A for administrators, end users, developers and designers for Craft CMS

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('%Portugal%')
               OR UPPER(Location) LIKE UPPER('%Portugal%')
               OR UPPER(Location) LIKE UPPER('%جزائر%')
               )  
             
ORDER BY Reputation DESC

Enter Parameters

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