WITH RECURSIVE Cat AS (

   SELECT page_title, page_id, 0 AS level

     FROM page

    WHERE page_title = 'German_people'

      AND page_namespace = 14

    UNION

   SELECT SubCat.page_title, SubCat.page_id, Cat.level + 1

     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 < 10

      AND SubCat.page_title NOT IN('Cultural_depictions_of_German_people',

                                   'Fictional_German_people',

                                   'Wikipedia_categories_named_after_German_people',

                                   'German_families')

      )

SELECT DISTINCT page.page_title

  FROM categorylinks, Cat, page LEFT JOIN langlinks

                                  ON ll_from = page.page_id

                                 AND ll_lang = 'de'

 WHERE page.page_namespace = 0

   AND page.page_title NOT LIKE 'List_of_%'

   AND cl_from = page.page_id

   AND cl_to = Cat.page_title

   AND ll_from IS NULL