Categories under only one hidden category (zhwiki_p)

This query is marked as a draft This query has been published by Tjmj.

SQL

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

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

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...