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)
--on Q.CreationDate = A.CreationDate

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results