Making a category tree

SQL

WITH RECURSIVE cats( cl_to, cat_tree, cl_from, cl_type )
 AS (SELECT cl_to, cl_to, cl_from, cl_type from categorylinks
       where cl_to= 'Mountains_of_Sabah'
     UNION ALL select page_title, concat( cat_tree, "→", page_title ), categorylinks.cl_from, categorylinks.cl_type
       from cats  inner join page on cats.cl_from = page_id
       inner join categorylinks on page_title = categorylinks.cl_to
    )
select replace( cat_tree, '_', ' ' ) 'category tree', replace( page_title, '_', ' ' ) 'File name' from cats inner join page on page_id = cl_from;
SQL

Checking query status...
