Q&A for project managers
-- List of users in Ukraine SELECT Top ##Top## ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], Id AS [User Link], Reputation, Location, --CreationDate, LastAccessDate, UpVotes, DownVotes FROM Users WHERE ( lower(Location) LIKE '%ukrain%' -- includes ukraine -- http://sustainablesources.com/resources/country-abbreviations/ OR Location LIKE '%UA' OR lower(Location) LIKE '%alchevsk%' OR lower(Location) LIKE '%brovary%' OR lower(Location) LIKE '%cherkassy%' OR lower(Location) LIKE '%cherkasy%' OR lower(Location) LIKE '%chernihiv%' OR lower(Location) LIKE '%chernivtsi%' OR lower(Location) LIKE '%chernivtsy%' OR lower(Location) LIKE '%crimea%' OR lower(Location) LIKE '%dnepropetrovsk%' OR lower(Location) LIKE '%dnipropetrovs%' OR lower(Location) LIKE '%donets%' OR lower(Location) LIKE '%feodosiya%' OR lower(Location) LIKE '%gulyaypole%' OR lower(Location) LIKE '%ivano-frankivs%' OR lower(Location) LIKE '%ivano-frankivs%' OR lower(Location) LIKE '%kerch%' OR lower(Location) LIKE '%kharkiv%' OR lower(Location) LIKE '%kharkov%' OR lower(Location) LIKE '%kherson%' OR lower(Location) LIKE '%khmel%' --Khmel'nyts'kyy & Khmelnitsky OR lower(Location) LIKE '%kiev%' OR lower(Location) LIKE '%kirovohrad%' OR lower(Location) LIKE '%kiyv%' OR lower(Location) LIKE '%konotop%' OR lower(Location) LIKE '%korman%' OR lower(Location) LIKE '%kramators%' -- Kramators'k OR lower(Location) LIKE '%kremenchuk%' OR lower(Location) LIKE '%kryvyy rih%' OR lower(Location) LIKE '%kyiv%' OR lower(Location) LIKE '%lugansk%' OR lower(Location) LIKE '%luhans''k%' OR lower(Location) LIKE '%luts%' --luts'k & lutsk OR lower(Location) LIKE '%lviv%' OR lower(Location) LIKE '%l''viv%' OR lower(Location) LIKE '%odesa%' OR lower(Location) LIKE '%odessa%' ) -- exclusions and not( lower(Location) LIKE '%donetsk, russia%' --testing OR lower(Location) = 'ukraine' OR lower(Location) = 'ukrain' OR lower(Location) LIKE '%alchevsk%' OR lower(Location) LIKE '%brovary%' OR lower(Location) LIKE '%cherkassy%' OR lower(Location) LIKE '%cherkasy%' OR lower(Location) LIKE '%chernihiv%' OR lower(Location) LIKE '%chernivtsi%' OR lower(Location) LIKE '%chernivtsy%' OR lower(Location) LIKE '%crimea%' OR lower(Location) LIKE '%dnepropetrovsk%' OR lower(Location) LIKE '%dnipropetrovs%' OR lower(Location) LIKE '%donets%' OR lower(Location) LIKE '%feodosiya%' OR lower(Location) LIKE '%gulyaypole%' OR lower(Location) LIKE '%ivano-frankivs%' OR lower(Location) LIKE '%kerch%' OR lower(Location) LIKE '%kharkiv%' OR lower(Location) LIKE '%kharkov%' OR lower(Location) LIKE '%kherson%' OR lower(Location) LIKE '%khmel%' --Khmel'nyts'kyy & Khmelnitsky OR lower(Location) LIKE '%kiev%' OR lower(Location) LIKE '%kirovohrad%' OR lower(Location) LIKE '%kiyv%' OR lower(Location) LIKE '%konotop%' OR lower(Location) LIKE '%korman%' OR lower(Location) LIKE '%kramators%' -- Kramators'k OR lower(Location) LIKE '%kremenchuk%' OR lower(Location) LIKE '%kryvyy rih%' OR lower(Location) LIKE '%kyiv%' OR lower(Location) LIKE '%lugansk%' OR lower(Location) LIKE '%luhans''k%' OR lower(Location) LIKE '%luts%' --luts'k & lutsk OR lower(Location) LIKE '%lviv%' OR lower(Location) LIKE '%l''viv%' OR lower(Location) LIKE '%odesa%' OR lower(Location) LIKE '%odessa%' ) and LEN(Location) > 1 --and Reputation > 1 --Temporarily sort by location to more easily pick out false positive entries ORDER BY Location ASC;