0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

SELECT id, CONCAT('https://stackoverflow.com/users/', Id) AS [Profile Link], DisplayName, Location, WebsiteUrl, AboutMe, LastAccessDate
FROM Users
WHERE (
-- From Russia
    upper(Location) LIKE upper('%Russ%')
   OR
    upper(Location) LIKE upper('%Росс%')
   OR
    upper(Location) LIKE upper('%Рашк%')
   OR
    upper(Location) LIKE upper('%Рус%')
    )
  AND (
-- keywords
    upper(AboutMe) LIKE upper('%k8s%')
   OR
    upper(AboutMe) LIKE upper('%aws%')
   OR
    upper(AboutMe) LIKE upper('%kuber%')
   OR
    upper(AboutMe) LIKE upper('%azur%')
   OR
    upper(AboutMe) LIKE upper('%ops%')
   OR
    upper(AboutMe) LIKE upper('%Jenkins%')
   OR
    upper(AboutMe) LIKE upper('%Terraform%')
   OR
    upper(AboutMe) LIKE upper('%ansible%')
   OR
    upper(AboutMe) LIKE upper('%Teamcity%')
   OR
    upper(AboutMe) LIKE upper('%Amazon%')
   OR
    upper(AboutMe) LIKE upper('%gcp%')
   OR
    upper(AboutMe) LIKE upper('%google cloud%')
   OR
    upper(AboutMe) LIKE upper('%cicd%')
   OR
    upper(AboutMe) LIKE upper('%ci/cd%')
   OR
    upper(AboutMe) LIKE upper('%linux%')
   OR
    upper(AboutMe) LIKE upper('%docker%')
   OR
    upper(AboutMe) LIKE upper('%bash%')
   OR
    upper(AboutMe) LIKE upper('%sre%')
   OR
    upper(AboutMe) LIKE upper('%site reliability engineering%')
   OR
    upper(AboutMe) LIKE upper('%system engineer%')
   OR
    upper(AboutMe) LIKE upper('%system administrator%')
    )
  AND (
-- Users with site or email
    upper(Users.AboutMe) like upper('%http%')
   OR
    upper(Users.AboutMe) like upper('%mail%')
   OR
    upper(Users.AboutMe) like upper('%@%')
   OR
    upper(Users.AboutMe) like upper('%.ru%')
   OR
    upper(Users.AboutMe) like upper('%.com%')
   OR
    upper(Users.WebsiteUrl) <> ''
    )
  AND NOT upper(Users.AboutMe) LIKE upper('%software%')
  AND NOT upper(Users.AboutMe) LIKE upper('%developer%')

-- Max reputation to top
ORDER BY Reputation DESC

fork query

edited sep 26

created sep 26 anonymous