Hughesdarren plants stub status

Articles in a flora category, created Hughesdarren, grouped by creation month.

Also provides information on the current status of the articles.

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)/100000000 as month
FROM (
  SELECT DISTINCT page_id, rev_len, page_len, page_is_redirect, rev_timestamp
  FROM (
    SELECT *
    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 = "Hughesdarren"
      AND page_namespace = 0
      AND rev_len > 150)
  JOIN categorylinks ON cl_from = page_id
  WHERE cl_to LIKE '%Flora%')
GROUP BY month
ORDER BY month DESC

SQL

Checking query status...