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

SELECT
	*
FROM `categorylinks` catProject
JOIN `page` pageTalk ON catProject.`cl_from` = pageTalk.`page_id`
JOIN (
    SELECT `page_title` FROM `categorylinks` catAALS
    JOIN `page` subjectPage ON subjectPage.`page_id` = catAALS.`cl_from`
    WHERE
    	`page_namespace` = 0 AND
        catAALS.`cl_to` = "All_articles_lacking_sources"
) AS pageSubject ON pageSubject.`page_title` = pageTalk.`page_title`
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...