Stub-class critically endangered species articles

A list of critically endangered species with stub articles. You can use this query as a template for building your own niche-specific + class-specific searches.

SQL

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

SELECT
    *,
    (SELECT `page_id` FROM `page` subjectPage WHERE subjectPage.`page_namespace` = 0 AND subjectPage.`page_title` = talkPage.`page_title`) AS `subj_page_id`
FROM `categorylinks` projectCat
JOIN `page` talkPage p1 ON projectCat.`cl_from` = talkPage.`page_id`
LEFT JOIN `page` subjectPage ON `subj_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")

SQL

Checking query status...