Unsourced Tambayan Philippines pages

SQL

SELECT
	REPLACE(`page_title`, "_", " ") AS `Page`,
    REPLACE(`cl_to`, "-importance_Philippine-related_articles", "") AS `Importance`
FROM `categorylinks` c1
JOIN `page` p1 ON `cl_from` = `page_id`
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") AND
	(SELECT TRUE FROM `page` p2
    JOIN `categorylinks` c2 ON p2.`page_id` = c2.`cl_from`
    WHERE
    	p2.`page_namespace` = 0 AND
    	p2.`page_title` = p1.`page_title` AND
    	c2.`cl_to` = "All_articles_lacking_sources"
    HAVING COUNT(p2.`page_id`))
ORDER BY (CASE `Importance`
    WHEN "Unknown" THEN 0
    WHEN "Low" THEN 1
    WHEN "Mid" THEN 2
    WHEN "High" THEN 3
    WHEN "Top" THEN 4
END) DESC
SQL

Checking query status...
