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