Categories assinged to a specific page (ltwiki)

SQL

WITH RECURSIVE cte (cl_from, cl_type) AS
(
    SELECT cl_from, cl_type
      FROM categorylinks
      WHERE cl_to = 'Kategorijos' -- starting category
    UNION
    SELECT categorylinks.cl_from, categorylinks.cl_type
      FROM cte
      JOIN page
        ON cl_from = page_id
      JOIN categorylinks
        ON page_title = cl_to
      WHERE cte.cl_type = 'subcat' -- subcat addition on each iteration
)
SELECT page_title, cl_from, cl_type, cl_to
FROM cte
JOIN page
  ON cl_from = page_id
WHERE page_namespace = 0
AND page_title = 'Špokaitė'
ORDER BY page_title; -- printing only articles in the end, ordered by title

SQL

Checking query status...