Stub-class critically endangered species articles

SQL

-- DATE_FORMAT(`rev_timestamp`, "%Y-%m-%d %H:%i:%s") AS `Last edit`,
-- `actor_name` AS `Last editor`,
-- `page_len` AS `Length`,

SELECT
    `page_title` AS `page_title`,
    (SELECT `page_len` FROM `page` p2
    JOIN `categorylinks` c2 ON p2.`page_id` = c2.`cl_from`
    JOIN `revision` ON p2.`page_latest` = `rev_id`
    JOIN `actor` ON `rev_actor` =`actor_id`
    WHERE
        p2.`page_namespace` = 0 AND
        p2.`page_title` = p1.`page_title` AND
        c2.`cl_to` = "All_articles_lacking_sources"
    ) AS `s_page_len`,
    (SELECT `rev_id` FROM `page` p2
    JOIN `categorylinks` c2 ON p2.`page_id` = c2.`cl_from`
    JOIN `revision` ON p2.`page_latest` = `rev_id`
    JOIN `actor` ON `rev_actor` =`actor_id`
    WHERE
        p2.`page_namespace` = 0 AND
        p2.`page_title` = p1.`page_title` AND
        c2.`cl_to` = "All_articles_lacking_sources"
    ) AS `s_rev_id`,
    (SELECT `rev_timestamp` FROM `page` p2
    JOIN `categorylinks` c2 ON p2.`page_id` = c2.`cl_from`
    JOIN `revision` ON p2.`page_latest` = `rev_id`
    JOIN `actor` ON `rev_actor` =`actor_id`
    WHERE
        p2.`page_namespace` = 0 AND
        p2.`page_title` = p1.`page_title` AND
        c2.`cl_to` = "All_articles_lacking_sources"
    ) AS `s_rev_timestamp`,
    (SELECT `page_len` FROM `page` p2
    JOIN `categorylinks` c2 ON p2.`page_id` = c2.`cl_from`
    JOIN `revision` ON p2.`page_latest` = `rev_id`
    JOIN `actor` ON `rev_actor` =`actor_id`
    WHERE
        p2.`page_namespace` = 0 AND
        p2.`page_title` = p1.`page_title` AND
        c2.`cl_to` = "All_articles_lacking_sources"
    ) AS `s_page_len`,
    (CASE c1.`cl_to`
        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 `categorylinks` c1
JOIN `page` p1 ON c1.`cl_from` = p1.`page_id`
WHERE
    (`cl_to` = "Top-importance_Philippine-related_articles" OR
    `cl_to` = "High-importance_Philippine-related_articles" OR
    `cl_to` = "Mid-importance_Philippine-related_articles" OR
    `cl_to` = "Low-importance_Philippine-related_articles" OR
    `cl_to` = "Unknown-importance_Philippine-related_articles") AND
    (SELECT TRUE FROM `page` p2
    JOIN `categorylinks` c2 ON p2.`page_id` = c2.`cl_from`
    WHERE
        p2.`page_namespace` = 0 AND
        p2.`page_title` = p1.`page_title` AND
        c2.`cl_to` = "All_articles_lacking_sources"
    HAVING COUNT(p2.`page_id`))
ORDER BY `Importance` DESC
SQL

Checking query status...
