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` = p.`page_id`
RIGHT JOIN `categorylinks` cl2 ON  p.`page_title`
WHERE cl_from = @MAIN_CAT ==

SQL

Checking query status...