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`,
    `imp`
FROM `page` p1
JOIN LATERAL (
    SELECT *
    FROM `categorylinks` c2
    JOIN `page` p2 ON p2.`page_id` = c2.`cl_from`
    WHERE
    	p2.`page_namespace` = 1 AND
    	p2.`page_title` = p1.`page_title` 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"
    	)
) talkPage ON 1=1
JOIN `categorylinks` c1 ON p1.`page_id` = c1.`cl_from`
JOIN `revision` ON `page_latest` = `rev_id`
JOIN `actor` ON `rev_actor` = `actor_id`
WHERE
   	c1.`cl_to` = "All_articles_lacking_sources"
SQL

Checking query status...
