0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

SELECT 

questions.Id as QuestionId, 

Title, 

Tags, 

Body, 

Answers.AnswerBody, 

AcceptedAnswerId, 

questions.Score as QuestionScore, 

ViewCount, 

AnswerCount, 

CommentCount, 

FavoriteCount, 

questions.CreationDate as QuestionCreationDate, 

LastEditDate, 

LastActivityDate, 

ClosedDate 

FROM Posts as questions 

LEFT OUTER JOIN ( SELECT Id as AnswerId, Body as AnswerBody 

FROM Posts WHERE PostTypeId = 2) as Answers 

ON questions.AcceptedAnswerId = answers.AnswerId 

WHERE questions.PostTypeId = 1 

AND questions.CreationDate >= '01-01-2015 00:00:00' 

AND questions.Tags LIKE '%azure%' 

AND questions.score > 0 

AND questions.DeletionDate IS NULL 

AND ParentId IS NULL 

AND questions.CommunityOwnedDate IS NULL 

AND YEAR(questions.CreationDate) > 2020

fork query

edited apr 4 anonymous

created may 21 22 jon.doe39040