Questions with MSFT Azure tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS Meta

Q&A about the site for administrators, end users, developers and designers for Craft CMS

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

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results