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!
TOP (10) ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#],
Id AS [User Link],
SELECT DISTINCT UserId
Class IN (1, 2, 3) AND
TagBased = 1
ON tag_badges.UserId = u.Id
LOWER(Location) LIKE '%turkey%'
OR UPPER(Location) LIKE '%TR'
OR UPPER(Location) LIKE 'ISTANBUL'
OR LOWER(Location) LIKE 'istanbul'
OR UPPER(Location) LIKE 'IZMIR'
OR LOWER(Location) LIKE 'izmir'