Top Users: Turkey

0

Please login or register to vote for this query.

(click on this box to dismiss)

Russian Language

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language

-- top users: Turkey
-- List of Turkey-based users by reputation score. Query, naturally, by a turkish user.
-- 
-- This is the original query!

SELECT
TOP (10) ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], 
    Id AS [User Link], 
    Reputation
FROM
    Users u
    
        JOIN (
                    SELECT DISTINCT UserId
                    FROM Badges
                    WHERE LOWER(Name) IN ('.net', 'c#', 'asp.net-mvc', 'javascript', 'css',
                   'flutter') AND
                          Class IN (1, 2, 3) AND
                          TagBased = 1
                  ) tag_badges
             ON tag_badges.UserId = u.Id
             
WHERE
 UPPER(Location) LIKE 'ISTANBUL'
    OR LOWER(Location) LIKE 'istanbul'
ORDER BY
    Reputation DESC;

Enter Parameters

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