Reverse recursion on categorylinks

SQL

set max_recursive_iterations=0;

with recursive subcats (path, cat_title) as (
  -- select page_title, page_title from page where page_title = 'Extraterrestrial_lakes' and page_namespace = 14
  select cl_to, cl_to from categorylinks where cl_type = 'page' and cl_from in (
    select page_id from page where page_title = 'Harold_Hunter_Armstrong' 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);
SQL

Checking query status...
