0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

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

SELECT
TOP (120) ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], 
    Id AS [User Link], 
    Reputation,
    Views
FROM
    Users
WHERE
    LOWER(Location) LIKE '%turkey%'
    OR UPPER(Location) LIKE '%TR'
    OR UPPER(Location) LIKE 'ISTANBUL'
    OR LOWER(Location) LIKE 'istanbul'
    OR LOWER(Location) LIKE 'Istanbul'
    OR UPPER(Location) LIKE 'IZMIR'
    OR LOWER(Location) LIKE 'izmir'
    OR LOWER(Location) LIKE 'Izmir'
    OR UPPER(Location) LIKE 'ANKARA'
    OR LOWER(Location) LIKE 'ankara'
    OR LOWER(Location) LIKE 'Ankara'
ORDER BY
    Reputation DESC;

fork query

edited feb 20 13 anonymous

created jan 2 13 soner.gonul