WITH RECURSIVE Cat AS (SELECT page_title

                         FROM page

                        WHERE page_title = 'Sportas'

                          AND page_namespace = 1

                        UNION

                       SELECT SubCat.page_title

                         FROM page AS SubCat, categorylinks, Cat

                        WHERE SubCat.page_namespace = 14

                          AND cl_from = SubCat.page_id

                          AND cl_to = Cat.page_title

                          AND cl_type = "subcat"

                      )

SELECT *

  FROM page AS P, categorylinks, Cat

 WHERE page_namespace = 1

   AND cl_from = page_id

   AND cl_to = Cat.page_title