0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people interested in the history and origins of science and mathematics

SELECT DISTINCT
    Users.DisplayName,
    Users.Location,
    Users.CreationDate AS RegistrationDate,
    Users.LastAccessDate,
    Users.Reputation,
    Users.Views,
    CONCAT('https://stackoverflow.com/users/', Users.Id) AS ProfileUrl,
    Users.WebsiteUrl,
    CONCAT('https://github.com/search?type=Users&q=', LOWER(REPLACE(Users.DisplayName COLLATE database_default, ' ', '+'))) AS GitHubSearchUrl,
    CONCAT('site:linkedin.com/in/', LOWER(REPLACE(Users.DisplayName COLLATE database_default, ' ', '+'))) AS LinkedInSearchUrl,
    CONCAT('https://www.t.me/', LOWER(REPLACE(Users.DisplayName COLLATE database_default, ' ', '+'))) AS TelegramSearchUrl
FROM
    Users
INNER JOIN Posts AS Answers ON Answers.OwnerUserId = Users.Id AND
    Answers.PostTypeId = 2 AND
    Answers.Score >= 1
INNER JOIN Posts AS Questions ON Questions.Id = Answers.ParentId
INNER JOIN PostTags ON PostTags.PostId = Questions.Id
INNER JOIN Tags ON Tags.Id = PostTags.TagId
WHERE
    (Location LIKE '%Minsk%' OR Location LIKE '%Belarus%') AND
    Users.Reputation >= 100 AND
    Users.LastAccessDate >= DATEADD(month, -24, GETDATE())
GROUP BY
    Users.DisplayName, Users.Location, Users.CreationDate, Users.LastAccessDate, Users.Reputation, Users.Views, Users.Id, Users.WebsiteUrl
HAVING
    COUNT(CASE WHEN Tags.TagName = 'php' THEN 1 END) > 10
ORDER BY
    Users.Reputation DESC

fork query

edited dec 4

created dec 4 anonymous