Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs
-- List of users in Ukraine
ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#],
Id AS [User Link],
lower(Location) LIKE '%ukraine%'
OR Location LIKE '%UA'
OR lower(Location) LIKE 'dummy'
lower(Location) LIKE '%dummy%'
and LEN(Location) > 1
--and Reputation > 1
--Temporarily sort by location to more easily pick out false positive entries
ORDER BY Location ASC;