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 * FROM `page` 
JOIN `categorylinks` catAALS ON `page_id` = `cl_from`
INNER JOIN (SELECT * FROM `page` talkPage
    JOIN `categorylinks` catProject ON talkPage.`page_id` = catProject.`cl_from`
    WHERE
      catProject.`cl_to` = "Top-importance_Philippine-related_articles" OR
      catProject.`cl_to` = "High-importance_Philippine-related_articles" OR
      catProject.`cl_to` = "Mid-importance_Philippine-related_articles" OR
      catProject.`cl_to` = "Low-importance_Philippine-related_articles" OR
      catProject.`cl_to` = "Unknown-importance_Philippine-related_articles"
) AS talkPage ON talkPage.`page_title` = `page_title`
WHERE
  catAALS.`cl_to` = "All_articles_lacking_sources"

SQL

Checking query status...