Q&A for developers and researchers interested in open data
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 Users.Reputation >= 100 and Users.LastAccessDate >= dateadd(month, -24, getdate()) and ( lower(Users.Location) like '%moscow%' or lower(Users.Location) like '%russia%' ) and Tags.TagName in ( 'axapta' ) order by Users.Reputation desc