Stub-class critically endangered species articles

SQL

SELECT p1.`page_id` AS `s_page_id` FROM `page` p1
JOIN `categorylinks` c1 ON p1.`page_id` = c1.`cl_from`
JOIN `page` p1 ON c1.`cl_from` = p1.`page_id`
JOIN `revision` ON `page_latest` = `rev_id`
JOIN `actor` ON `rev_actor` = `actor_id`
WHERE
  	p1.`page_namespace` = 0 AND
   	p1.`page_title` = p1.`page_title` AND
   	c1.`cl_to` = "All_articles_lacking_sources" AND
    EXISTS (
      SELECT TRUE
      FROM `categorylinks` c2
      JOIN `page` p2 ON p2.`page_id` = c2.`cl_from`
      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"
      HAVING COUNT(p2.`page_id`)
    )

SELECT
	*
FROM `categorylinks` c1
WHERE
    ()
ORDER BY `Importance` DESC
SQL

Checking query status...
