cloud engineers, sysops from russia with contacts

0

Please login or register to vote for this query.

(click on this box to dismiss)

Russian Language

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language

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('%Russi%')
        OR upper(Location) LIKE upper('%Росс%')
        OR upper(Location) LIKE upper('%Моск%')
        OR upper(Location) LIKE upper('%Mosc%')
        OR upper(Location) LIKE upper('%СПб%')
        OR upper(Location) LIKE upper('%spb%')
        OR upper(Location) LIKE upper('%питер%')
        OR upper(Location) LIKE upper('%петербург%')
        OR upper(Location) LIKE upper('%petersburg%')
    )
  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('%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%')
        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.AboutMe) like upper('%.me%')
        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

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results