Personenkategorien

SQL

/*SELECT * FROM page WHERE page_namespace = 14 AND page_title = 'Person'*/
WITH recursive personenkategorien as (
SELECT CONCAT(p.page_title,'                                                                                                                                                                    ') page_title, 'main                                                                                                                                             ' parent FROM categorylinks cl
JOIN page p ON p.page_id = cl.cl_from
WHERE cl_type = 'subcat' and cl_to = 'Person'
UNION 
SELECT p.page_title, pk.page_title parent FROM categorylinks cl
  JOIN personenkategorien as pk ON TRIM(pk.page_title) = cl.cl_to
JOIN page p ON p.page_id = cl.cl_from
WHERE cl_type = 'subcat'
)
SELECT TRIM(page_title) page_title, TRIM(parent) parent FROM personenkategorien
SQL

Checking query status...
