Unsourced Tambayan Philippines pages

If you happened to click on the "Importance" column, this will sort things improperly. Refresh the page to restore the original (and correct) sort order.

SQL

SELECT
	`page_namespace`,
	`page_title`,
    (
        SELECT
      		p2.`page_id`
        FROM `page` p2
        JOIN `categorylinks` c2 ON p2.`page_id` = c2.`cl_from`
        WHERE
            p2.`page_namespace1 = 0
            p2.`page_title` = p1.`page_title` AND
            c2.`cl_to` = "All_articles_lacking_sources"
      	HAVING COUNT(p2.`page_id`) = 1
    ) AS `Lacking sources`
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"

SQL

Checking query status...