Recursion on categorylinks

SQL

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

select count(distinct page_namespace, page_title) from catpage;
SQL

Checking query status...
