Categories under only one hidden category (zhwiki_p)

SQL

WITH hc AS (
    SELECT p.page_id, p.page_title
	FROM categorylinks c
	LEFT JOIN page p ON (c.cl_from = p.page_id)
  	WHERE c.cl_to = "隐藏分类"
)
SELECT hc.page_id, hc.page_title, COUNT(*) AS cat_count
FROM hc
LEFT JOIN categorylinks c2 ON (hc.page_id = c2.cl_from)
GROUP BY 1, 2
HAVING COUNT(*) = 1
LIMIT 10

/* 
SELECT p.page_id, p.page_title, c.cl_to
FROM categorylinks c
LEFT JOIN page p ON (c.cl_from = p.page_id)
WHERE c.cl_to = "隐藏分类"
LIMIT 100 

SELECT p.page_id, p.page_title, c.cl_to
FROM page p
LEFT JOIN categorylinks c ON (c.cl_from = p.page_id)
WHERE p.page_id = 643321
*/*/

SQL

Checking query status...