Monthly Hobbit edits

SQL

SELECT tmp.page_title, 
EXTRACT(Year from DATE_FORMAT(rev_timestamp,'%Y%m%d%H%i%s')) as `year`, 
LPAD(EXTRACT(Month from DATE_FORMAT(rev_timestamp,'%Y%m%d%H%i%s')), 2, '0') as `month`, 
COUNT(rev_id) AS revisions FROM revision r
JOIN 
	(SELECT page_id, page_title
	FROM enwiki_p.page AS p
	INNER JOIN enwiki_p.categorylinks AS cl
	ON 
	p.page_id = cl.cl_from 
	WHERE cl.cl_to IN ('The_Hobbit_(film_series)')
	AND cl.cl_type = 'page'
	AND p.page_namespace = 0) tmp 
ON r.rev_page = tmp.page_id 
GROUP BY tmp.page_title, `year`, `month` 
ORDER BY tmp.page_title ASC, `year` ASC, `month` ASC;
SQL

Checking query status...
