set max_recursive_iterations=3;

​

with recursive subcats (path, cat_title) as (

  select cl_to, cl_to from categorylinks where cl_type = 'page' and cl_from in (

    select page_id from page where page_title = 'Sabine_Stuart_de_Chevalier' and page_namespace = 0

  )

  union all

  select concat(path, ',', cl_to), cl_to from subcats

  join page on page_title = cat_title and page_namespace = 14

  join categorylinks on cl_from = page_id and cl_type = 'subcat'

)

-- cycle cat_title restrict

-- select * from subcats where find_in_set('Lists', path);

select count(distinct path) from subcats;