1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people who like playing board games, designing board games or modifying the rules of existing board games

-- List of users in Slovakia
-- Based on: https://data.stackexchange.com/mathoverflow/query/157038/user-list-top-n-ukraine-with-false-positive-exclusions?Top=50
-- List of users in Ukraine
SELECT
    Top ##num?100##
    ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], 
    Id AS [User Link], 
    Reputation,
    Location,
    --CreationDate,
    LastAccessDate,
    UpVotes,
    DownVotes
    
FROM
    Users
WHERE

    (
    Location LIKE '%slovak%' -- includes Slovakia, Slovak Republic
    OR Location LIKE '%slovensk%' COLLATE Latin1_General_CI_AI
    -- includes Slovensko, Slovenská republika
    -- http://sustainablesources.com/resources/country-abbreviations/
    OR Location LIKE '%SK' 
    
    OR Location LIKE '%banovce%' COLLATE Latin1_General_CI_AI
    --both Banovce and Bánovce
    OR Location LIKE '%banska%' COLLATE Latin1_General_CI_AI
    --both Banska and Banská
    --Banská Bystrica, Banská Štiavnica and similar places
    OR Location LIKE '%bardejov%' COLLATE Latin1_General_CI_AI
    OR Location LIKE '%bojnice%' COLLATE Latin1_General_CI_AI
    OR Location LIKE '%bratislav%' COLLATE Latin1_General_CI_AI
    OR Location LIKE '%brezova pod%' COLLATE Latin1_General_CI_AI
    OR Location LIKE '%brezno%' COLLATE Latin1_General_CI_AI
    OR Location LIKE '%bytca%' COLLATE Latin1_General_CI_AI
    OR Location LIKE '%cadca%' COLLATE Latin1_General_CI_AI
    OR Location LIKE '%cifer%' COLLATE Latin1_General_CI_AI
    OR Location LIKE '%dolny kubin%' COLLATE Latin1_General_CI_AI
    OR Location LIKE '%dubnica%' COLLATE Latin1_General_CI_AI
    OR Location LIKE '%galanta%' COLLATE Latin1_General_CI_AI
    OR Location LIKE '%gbely%' COLLATE Latin1_General_CI_AI
    OR Location LIKE '%humenne%' COLLATE Latin1_General_CI_AI
    OR Location LIKE '%kezmarok%' COLLATE Latin1_General_CI_AI
    OR Location LIKE '%komarno%' COLLATE Latin1_General_CI_AI
    OR Location LIKE '%kosic%' COLLATE Latin1_General_CI_AI
    ---both Kosice and Košice
    OR Location LIKE '%levice%' COLLATE Latin1_General_CI_AI
    OR Location LIKE '%liptov%' COLLATE Latin1_General_CI_AI
    --Liptovský Mikuláš, Liptovský Hrádok and other similar places
    OR Location LIKE '%lucenec%' COLLATE Latin1_General_CI_AI    
    OR Location LIKE '%malacky%' COLLATE Latin1_General_CI_AI
    OR Location LIKE '%martin%' COLLATE Latin1_General_CI_AI
    OR Location LIKE '%michalovce%' COLLATE Latin1_General_CI_AI
    OR Location LIKE '%namestovo%' COLLATE Latin1_General_CI_AI
    OR Location LIKE '%nitra%' COLLATE Latin1_General_CI_AI
    OR Location LIKE '%nove zamky%' COLLATE Latin1_General_CI_AI    
    OR Location LIKE '%pezinok%' COLLATE Latin1_General_CI_AI
    OR Location LIKE '%piestany%' COLLATE Latin1_General_CI_AI    
    OR Location LIKE '%poprad%' COLLATE Latin1_General_CI_AI
    OR Location LIKE '%povazsk%' COLLATE Latin1_General_CI_AI
    --Považská Bystrica and similar places
    OR Location LIKE '%prievidza%' COLLATE Latin1_General_CI_AI
    OR Location LIKE '%rimavska%' COLLATE Latin1_General_CI_AI
    --Rimavská Sobota, Rimavská Baňa, ...
    OR Location LIKE '%ruzomberok%' COLLATE Latin1_General_CI_AI
    OR Location LIKE '%senica%' COLLATE Latin1_General_CI_AI
    OR Location LIKE '%smizany%' COLLATE Latin1_General_CI_AI
    OR Location LIKE '%topolcany%' COLLATE Latin1_General_CI_AI
    OR Location LIKE '%trebisov%' COLLATE Latin1_General_CI_AI    
    OR Location LIKE '%trenc%' COLLATE Latin1_General_CI_AI
    --Trenčín, Trenčianksa Teplá, etc.
    OR Location LIKE '%trnav%' COLLATE Latin1_General_CI_AI
    OR Location LIKE '%spissk%' COLLATE Latin1_General_CI_AI
    --Spišská Nová Ves, Spišský Štvrtok, ...
    OR Location LIKE '%zilina%' COLLATE Latin1_General_CI_AI
    OR Location LIKE '%zvolen%' COLLATE Latin1_General_CI_AI
    )
    
    -- exclusions
    and not(
    (Location LIKE '%asquith, sk%' COLLATE Latin1_General_CI_AI --Asquith, SK
    OR Location LIKE '%brezno u%' COLLATE Latin1_General_CI_AI --Březno u Mladé Boleslavi
    OR Location LIKE '%martins%' COLLATE Latin1_General_CI_AI)  
    -- Domingos Martins (Brazil)    
    -- Martinsburg, WV United States
    OR (Location LIKE '%martin%drive%' COLLATE Latin1_General_CI_AI)  -- Martin Drive
    OR (Location LIKE '%martin%irvine%' COLLATE Latin1_General_CI_AI)  -- Martin, CA
    OR (Location LIKE '%martin%street%' COLLATE Latin1_General_CI_AI)  -- Martin Street
    OR (Location LIKE '%martin, tn%' COLLATE Latin1_General_CI_AI)-- Martin, TN, United States
    OR (Location LIKE '%martinez%' COLLATE Latin1_General_CI_AI) -- Martinique
    OR (Location LIKE '%martinique%' COLLATE Latin1_General_CI_AI)
    OR (Location LIKE '%saskatoon%' COLLATE Latin1_General_CI_AI) -- Saskatoon, SK
    OR (Location LIKE '%kenitra%' COLLATE Latin1_General_CI_AI) --Kenitra, Morocco
    ---OR (Location LIKE '%kénitra%')
    OR (Location LIKE '%saint-martin%' COLLATE Latin1_General_CI_AI)
    OR (Location LIKE '%slovenska bistrica%' COLLATE Latin1_General_CI_AI) --Slovenska Bistrica, Slovenia
    OR (Location LIKE '%vlasenica%' COLLATE Latin1_General_CI_AI) --Vlasenica, Bosnia and Herzegovina
    )       
    
 and LEN(Location) > 1
 
ORDER BY Reputation DESC
-- Temporarily sort by location to more easily pick out false positive entries
-- ORDER BY Location ASC;
 
 ---COLLATE Latin1_General_CI_AI
 ---CI = case-sensitive.
 ---AI = accent-insensitive

view current version

edited jun 16 20

created sep 29 19 Martin20528