Blog entries and blogmarks and quotations by month

Owned by simonw, visibility: Public

SQL query 
with content as (
  select created from blog_entry
  union all select created from blog_blogmark
  union all select created from blog_quotation
)
select
  to_char(date_trunc('month', created), 'YYYY-MM') as bar_label,
  count(*) as bar_quantity
from content
group by bar_label
order by bar_label desc