This query is marked as a draft This query has been published by EqJjgOa8rVvsRmZL.

SQL

x
 
set max_recursive_iterations=3;
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 = '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);
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...