Recursion on categorylinks

SQL

with recursive subcats as (
  select page_title from categorylinks, page
  where cl_type = 'subcat' and cl_from = page_id and cl_to = 'Lists_of_lists'
  union all
  select page.page_title from subcats, categorylinks, page
  where cl_type = 'subcat' and cl_from = page_id and cl_to = subcats.page_title
)

-- select count(distinct page_title) from subcats;

select count(distinct page.page_title) from subcats
join categorylinks on cl_to = subcats.page_title and cl_type = 'page'
join page on cl_from = page_id;

/*
select count(distinct page_title) from categorylinks, page
where cl_type = 'page' and cl_from = page_id and (cl_to = 'Lists_of_events' or cl_to in (select page_title from subcats));
*/
SQL

Checking query status...
