Category finite transitive closure

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
),
edges_2 AS (
	SELECT ref_child_id, ref_parent_id FROM edges
  	WHERE ref_parent_id = 692318
),
edges_3 AS (
	SELECT edges.ref_child_id AS ref_child_id, edges_2.ref_parent_id AS ref_parent_id
  	FROM edges, edges_2
  	WHERE edges.ref_parent_id = edges_2.ref_child_id
),
edges_4 AS (
	SELECT edges.ref_child_id AS ref_child_id, edges_3.ref_parent_id AS ref_parent_id
  	FROM edges, edges_3
  	WHERE edges.ref_parent_id = edges_3.ref_child_id
)

SELECT ref_child_id, ref_parent_id FROM
edges_4
WHERE ref_parent_id=692318
SQL

Checking query status...
