SQL
x
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 min(depth), max(depth), cat_title, count(*) from subcats group by cat_title order by count(depth) desc limit 10;
-- select count(distinct cl_from) from subcats
-- join categorylinks on cl_to = cat_title and cl_type != 'subcat'
-- where cat_title not in (select cat_title from category where cat_pages = 0)
-- join page on cl_from = page_id
-- order by page_namespace;
/*
select 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
)
*/
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.