Category graph

SQL

WITH edges AS (
	SELECT cl_from AS ref_child_id, page_id AS ref_parent_id FROM
	categorylinks
	INNER JOIN page ON cl_to=page_title AND page_namespace=14
)

(
	SELECT ref_child_id, ref_parent_id FROM edges
  	WHERE ref_parent_id = 692318
)
UNION
(
	SELECT e1.ref_child_id AS ref_child_id, e2.ref_parent_id AS ref_parent_id
	FROM edges e1, edges e2
	WHERE e1.ref_parent_id = e2.ref_child_id
	AND e2.ref_parent_id = 692318
)
UNION
(
	SELECT e1.ref_child_id AS ref_child_id, e3.ref_parent_id AS ref_parent_id
	FROM edges e1, edges e2, edges e3
	WHERE e1.ref_parent_id = e2.ref_child_id AND e2.ref_parent_id = e3.ref_child_id
	AND e3.ref_parent_id = 692318
)
UNION
(
	SELECT e1.ref_child_id AS ref_child_id, e4.ref_parent_id AS ref_parent_id
	FROM edges e1, edges e2, edges e3, edges e4
	WHERE e1.ref_parent_id = e2.ref_child_id AND e2.ref_parent_id = e3.ref_child_id AND e3.ref_parent_id = e4.ref_child_id
	AND e4.ref_parent_id = 692318
)
SQL

Checking query status...
