0

Please login or register to vote for this query.

(click on this box to dismiss)

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
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

created jul 2 jon.doe39040