Category transitive closure

SQL

WITH
cat_pages AS (
	SELECT * FROM page
  	WHERE page_namespace=14
),
page_hierarchy_1(child_page_id_1, parent_page_id_1) AS (
	SELECT cl_from, page_id
    FROM categorylinks
    INNER JOIN cat_pages ON cl_to=page_title
),
page_hierarchy(child_page_id, parent_page_id) AS (
  	page_hierarchy_1
  	UNION ALL
	SELECT child_page_id_1, parent_page_id_1
    FROM page_hierarchy JOIN page_hierarchy ON child_page_id=parent_page_id
)

# WITH page_hierarchy(child_page_id, parent_page_id) AS (
#	SELECT ..
#  	FROM page_hierarchy JOIN page_hierarchy_1 ON page_hierarchy_1.child_page_id=
#)

SELECT *
FROM page_hierarchy_1
LIMIT 30;
SQL

Checking query status...
