test

0

Please login or register to vote for this query.

(click on this box to dismiss)

Reverse Engineering Meta

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

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 >= 500 and 

 

Users.LastAccessDate >= dateadd(month, -3, getdate()) and 

 

( 

 

lower(Users.Location) like '%united states%' or lower(Users.Location) like '%usa%' or lower(Users.Location) like '%nyc%' or lower(Users.Location) like '%new york%' 

 

) and 

 

Tags.TagName in ( 

 

'python' 

 

) 

 

order by 

 

Users.Reputation desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results