0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for users of TeX, LaTeX, ConTeXt, and related typesetting systems

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

fork query

edited mar 1 anonymous

created may 21 22 jon.doe39040