Bioinformatics - EN articles vs PL articles

SQL

WITH RECURSIVE category_tree AS (
    -- Start with the main category "Bioinformatics"
    SELECT cl_from AS page_id
    FROM categorylinks
    WHERE cl_to = 'Bioinformatics'
    
    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)
)

-- Znajdź polskie odpowiedniki artykułów
SELECT
    en_page.page_title AS en_title,
    pl_page.page_title AS pl_title
FROM category_tree
JOIN page AS en_page ON en_page.page_id = category_tree.page_id
LEFT JOIN langlinks ON langlinks.ll_from = en_page.page_id
LEFT JOIN plwiki_p.page AS pl_page ON pl_page.page_title = langlinks.ll_title
WHERE langlinks.ll_lang = 'pl'  -- Tylko artykuły, które mają polskie odpowiedniki
AND en_page.page_namespace = 0;  -- Pobieramy tylko artykuły (namespace = 0)
SQL

Checking query status...
