Bioinformatics - EN category and subcategories content

SQL

USE plwiki_p;

WITH t AS
(
SELECT
    ll_lang, article.page_title AS en_title, ll_title AS pl_title
FROM page AS talk
    INNER JOIN page AS article ON talk.page_title = article.page_title
    INNER JOIN categorylinks ON cl_from = talk.page_id
    LEFT JOIN langlinks ON ll_from = article.page_id
WHERE
    ll_lang = 'pl' AND
    talk.page_namespace = 1 AND
    article.page_namespace = 0 AND
    cl_to IN (
        'Bioinformatyka',
        'Top-importance_Bioinformatics_articles',
        'High-importance_Bioinformatics_articles',
        'Mid-importance_Bioinformatics_articles',
        'Low-importance_Bioinformatics_articles',
        'NA-importance_Bioinformatics_articles',
        'Unknown-importance_Bioinformatics_articles'
    )
)
SELECT
    ll_lang AS lang, en_title, pl_title
FROM t;
SQL

Checking query status...
