Answer Count by User and Tag Since Date

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 COUNT(Answers.Id) AS [Answer Count], 
SUM(Answers.Score) AS [Total Score],
SUM(Questions.ViewCount) AS Views,
Users.DisplayName AS Name

FROM Posts as Answers, Posts as Questions, Users

WHERE Questions.Id = Answers.ParentId
AND (Answers.OwnerUserId = 1278297
OR Answers.OwnerUserId =30632
OR Answers.OwnerUserId =8383152
OR Answers.OwnerUserId =3035921
OR Answers.OwnerUserId =174777
OR Answers.OwnerUserId =4686192
OR Answers.OwnerUserId =203801
OR Answers.OwnerUserId =1043510
OR Answers.OwnerUserId =225749
OR Answers.OwnerUserId =10885720
OR Answers.OwnerUserId =9336087
OR Answers.OwnerUserId =240004
OR Answers.OwnerUserId =663360
OR Answers.OwnerUserId =10981662
OR Answers.OwnerUserId =1735716)
AND Questions.Tags like ##Tag:string?%amazon-web-services%##
AND Answers.CreationDate >= ##StartDate:string?2019-01-01##
AND Users.Id = Answers.OwnerUserId

GROUP BY Answers.OwnerUserId, Users.DisplayName

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results