Get number of accepted answers in 2019

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS

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

SELECT count(*)
FROM Posts q
INNER JOIN Posts a on q.AcceptedAnswerId = a.Id
WHERE year(a.CreationDate)=2019
      and q.PostTypeId = 1
      and a.PostTypeId = 2 -- answers

Enter Parameters

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