Recursion on categorylinks

SQL

-- select * from categorylinks, page
-- where page_id = cl_from and cl_to = 'Set_index_articles_on_storms' and cl_type = 'subcat';

with catpage as (
  select page_id, page_namespace, page_title from categorylinks, page
  where page_id = cl_from and cl_to = 'Set_index_articles_on_storms'
  union all
  select page.page_id, page.page_title, page.page_namespace from catpage, categorylinks, page
  where page.page_id = categorylinks.cl_from and cl_to = catpage.page_title and catpage.page_namespace = 14
)

-- select * from catpage;
SQL

Checking query status...
