Question 1

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla Meta

Q&A about the site for Joomla! administrators, users, developers and designers

select year(CreationDate) as "Year", month(CreationDate) as "Month", count(Id) as "Posts"
from Posts
group by year(CreationDate), month(CreationDate)
order by year(CreationDate), month(CreationDate)

Enter Parameters

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