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