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

# Category of the mainspace article
SET @MAIN_CAT = "IUCN Red List critically endangered species";
# Class category
SET @CLASS_CAT = "Stub-Class articles";

# Get the category ID of the mainspace category
SET @MAIN_CATID = (SELECT cat_id FROM category WHERE cat_title = REPLACE(@MAIN_CAT, " ", "_"));
# Get the category ID of the class root category
SET @CLASS_CATID = (SELECT cat_id FROM category WHERE cat_title = REPLACE(@CLASS_CAT, " ", "_"));

# GO
SELECT *
FROM `categorylinks` cl1
LEFT JOIN `page` p1 ON cl1.`cl_from` = p1.`page_id`
RIGHT JOIN `page` p2 ON p2.`page_title` = p1.`page_title` AND p2.`page_namespace` = (p1.`page_namespace` + 1)
RIGHT JOIN `categorylinks` cl2 ON cl2.`cl_from` = p2.`page_id` AND cl2.`cl_to` = @CLASS_CAT
WHERE cl1.`cl_from` = @MAIN_CAT

SQL

Checking query status...