Stub-class critically endangered species articles

SQL

SELECT
    p1.`page_title` AS `page_title`,
    DATE_FORMAT(`rev_timestamp`, "%Y-%m-%d %H:%i:%s") AS `s_last_edit`,
    `actor_name` AS `s_last_editor`,
    `page_len` AS `s_length`,
    (CASE `t_importance`
        WHEN "Unknown-importance_Philippine-related_articles" THEN 1
        WHEN "Low-importance_Philippine-related_articles" THEN 2
        WHEN "Mid-importance_Philippine-related_articles" THEN 3
        WHEN "High-importance_Philippine-related_articles" THEN 4
        WHEN "Top-importance_Philippine-related_articles" THEN 5
    END) AS `importance`
FROM `page` p1
JOIN `categorylinks` c1 ON p1.`page_id` = c1.`cl_from`
JOIN `revision` ON `page_latest` = `rev_id`
JOIN `actor` ON `rev_actor` = `actor_id`
JOIN (
    SELECT `page_title` AS `t_page_title`, c2.`cl_to` as `t_importance`
    FROM `categorylinks` c2
    JOIN `page` p2 ON p2.`page_id` = c2.`cl_from`
    WHERE
    	p2.`page_namespace` = 1 AND
    	(
    		c2.`cl_to` = "Top-importance_Philippine-related_articles" OR
    		c2.`cl_to` = "High-importance_Philippine-related_articles" OR
    		c2.`cl_to` = "Mid-importance_Philippine-related_articles" OR
    		c2.`cl_to` = "Low-importance_Philippine-related_articles" OR
    		c2.`cl_to` = "Unknown-importance_Philippine-related_articles"
    	)
) ON `t_page_title` = `page_title`
WHERE
   	c1.`cl_to` = "All_articles_lacking_sources"
SQL

Checking query status...
