Untitled query #68281

SQL

# SELECT * FROM
# page AS first_page
# LEFT OUTER JOIN categorylinks ON first_page.page_id=cl_from
# LEFT OUTER JOIN page ON cl_to=page.page_title AND page.page_namespace=14
# LIMIT 100;

# SELECT cl_from, page_id FROM
# categorylinks
# LEFT OUTER JOIN page ON cl_to=page_title AND page_namespace=14
# LIMIT 100;

WITH RECURSIVE
edges AS (
	SELECT cl_from AS ref_child_id, page_id AS ref_parent_id FROM
	categorylinks
	# LEFT OUTER JOIN page ON cl_to=page_title AND page_namespace=14
	INNER JOIN page ON cl_to=page_title AND page_namespace=14
),
closure_edges AS (
	SELECT * FROM edges WHERE ref_parent_id=692318
  	UNION ALL
  	SELECT m.* FROM edges m
  	INNER JOIN closure_edges on m.ref_parent_id=closure_edges.ref_child_id
  	
)

SELECT * FROM closure_edges LIMIT 10;
SQL

Checking query status...
