0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people who like playing board games, designing board games or modifying the rules of existing board games

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://www.google.com/search/?q=', LOWER(REPLACE(Users.DisplayName COLLATE DATABASE_DEFAULT, ' ', '+'))) AS GoogleSearchUrl,
    CONCAT('https://plus.google.com/s/', LOWER(REPLACE(Users.DisplayName COLLATE DATABASE_DEFAULT, ' ', '+'))) AS GooglePlusSearchUrl,
    CONCAT('https://github.com/search?type=Users&q=', LOWER(REPLACE(Users.DisplayName COLLATE DATABASE_DEFAULT, ' ', '+'))) AS GitHubSearchUrl,
    CONCAT('https://www.linkedin.com/vsearch/p?keywords=', LOWER(REPLACE(Users.DisplayName COLLATE DATABASE_DEFAULT, ' ', '+'))) AS LinkedInSearchUrl,
    CONCAT('https://twitter.com/search?mode=users&q=', LOWER(REPLACE(Users.DisplayName COLLATE DATABASE_DEFAULT, ' ', '+'))) AS TwitterSearchUrl
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
    Users.Reputation >= 100 
    AND Users.LastAccessDate >= DATEADD(MONTH, -24, GETDATE())
    AND (
        LOWER(Users.Location) LIKE '%sindias%' OR 
        LOWER(Users.Location) LIKE '%hyderabad%' OR 
        LOWER(Users.Location) LIKE '%poland%' OR
        LOWER(Users.Location) LIKE '%warsaw%' OR
        LOWER(Users.Location) LIKE '%shyderabad%'
    )
    AND Tags.TagName = 'database'
ORDER BY
    Users.Reputation DESC;

fork query

edited dec 8

created dec 8 anonymous