total_answers_by_year

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 A.CreationDate, A.AnswerCount from
(
select CONVERT(DATE, CreationDate) as CreationDate, 
count(*) as AnswerCount
from posts
where posttypeid = 2 group by CONVERT(DATE, creationDate)
)A
--on Q.CreationDate = A.CreationDate
--)

Enter Parameters

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