select count(1) as count, month(published_at) as month, year(published_at) as year
from articles
where published_at >= (now() - interval 1 year) and published_at <= now()
group by month(published_at)
order by year asc, month asc