WHEN title LIKE '%autobiography' THEN 1
END) AS autobio
DATE(cout) >= '2006-01-01'
AND DATE(cout) <= '2013-12-31'
GROUP BY MONTH(cout) , YEAR(cout)
ORDER BY YEAR(cout) , MONTH(cout)
General view of the grid. 2008 and 2010 were the years with most interest. 2006 show very small interest, but this can be because of partial data logs.
Query time: 320s.