nlwiki species-redirects to re-categorize

SQL

SELECT p3.page_title AS rd_from, rd_title, t.cat_title AS cat
FROM categorylinks cl2, page p3, (
    SELECT DISTINCT p2.page_title AS cat_title, p1.page_title AS subcat_title
    FROM page p1, revision, categorylinks cl1, page p2
    WHERE
        p1.page_namespace=14 AND p1.page_title NOT REGEXP '^Wikipedia:' AND p2.page_namespace=14 AND
        rev_page=p1.page_id AND rev_parent_id=0 AND rev_actor=(SELECT actor_id FROM actor WHERE actor_name='Bitbotje') AND
  		cl1.cl_from=p1.page_id AND cl1.cl_to=p2.page_title
	) t, redirect
WHERE cl2.cl_to=t.cat_title AND cl2.cl_from=p3.page_id AND
	p3.page_namespace=0 AND p3.page_is_redirect=1 AND p3.page_title REGEXP '^[A-Z][a-z]+_(\\([A-Z][a-z]+\\)_)?[a-z]+$' AND
    REGEXP_REPLACE(p3.page_title,'_.*','')=REGEXP_REPLACE(t.subcat_title,'_\\(.*\\)$','') AND rd_from=p3.page_id
# 61 results in 14s
SQL

Checking query status...
