Bioinformatics - EN category and subcategories content

SQL

WITH RECURSIVE category_tree AS (
    -- Start with the main category "Bioinformatyka"
    SELECT cl_from AS page_id
    FROM categorylinks
    WHERE cl_to = 'Bioinformatyka'
    
    UNION ALL
    
    -- Rekurencyjnie znajdź wszystkie podkategorie i ich artykuły
    SELECT cl.cl_from AS page_id
    FROM categorylinks cl
    JOIN category_tree ct ON cl.cl_to = (SELECT page_title FROM page WHERE page_id = ct.page_id AND page_namespace = 14)
)
SELECT page.page_title
FROM category_tree
JOIN page ON page.page_id = category_tree.page_id
WHERE page_namespace = 0;  -- Pobieramy tylko artykuły (namespace = 0)

SQL

Checking query status...