Lugnuts stub status

SQL

SELECT COUNT(*) articles, 
	SUM(CASE WHEN rev_len < 2500 THEN 1 ELSE 0 END) as smallCreations, 
    SUM(CASE WHEN rev_len < 2500 AND page_len < 3000 AND page_is_redirect = 0 THEN 1 ELSE 0 END) as smallCurrent,
    SUM(page_is_redirect) as redirectCurrent,
    TRUNCATE(rev_timestamp,-8) as month
FROM revision
JOIN actor_revision ON actor_id = rev_actor
JOIN page ON page_id = rev_page
WHERE rev_parent_id = 0
  AND actor_name = "Lugnuts"
  AND page_namespace = 0
  AND rev_len > 150
GROUP BY month
ORDER BY month DESC;
SQL

Checking query status...
