WITH RECURSIVE Cat AS (

   SELECT page_title, page_id, 0 AS level#, CAST(page_title AS VARCHAR(25000)) AS path

     FROM page

    WHERE page_title = 'German_people'

      AND page_namespace = 14

    UNION

   SELECT SubCat.page_title, SubCat.page_id, Cat.level + 1#, CONCAT(Cat.path, ' -> ', SubCat.page_title) AS path

     FROM page AS SubCat, categorylinks, Cat

    WHERE SubCat.page_namespace = 14

      AND cl_from = SubCat.page_id

      AND cl_to = Cat.page_title

      AND cl_type = 'subcat'

      AND Cat.level < 9

      AND SubCat.page_title NOT IN('Cultural_depictions_of_German_people',

                                   'Fictional_German_people',

                                   'German_families',

                                   'German_diaspora',

                                   'Images_of_German_people',

                                   'Lists_of_German_people')

      AND SubCat.page_title NOT LIKE 'Wikipedia_categories_named_%'

      AND SubCat.page_title NOT LIKE 'American_people_%'

      AND SubCat.page_title NOT LIKE 'English_people_%'

      AND SubCat.page_title NOT LIKE 'Works_by_%'

      AND SubCat.page_title LIKE '%erman%'

      )

SELECT DISTINCT page.page_title#, path

  FROM categorylinks AS c, Cat, page LEFT JOIN langlinks

                                       ON ll_from = page.page_id

                                      AND ll_lang = 'de'

                                     LEFT JOIN categorylinks AS borndied

                                       ON borndied.cl_from = page.page_id

                                      AND (borndied.cl_to LIKE '%_deaths'

                                           OR borndied.cl_to LIKE '%_births')

 WHERE page.page_namespace = 0

   AND page.page_title NOT LIKE 'List_of_%'

   AND c.cl_from = page.page_id

   AND c.cl_to = Cat.page_title

   AND ll_from IS NULL

   AND borndied.cl_from IS NOT NULL

 #GROUP BY page.page_title