Bioinformatics - EN category and subcategories content

This query is marked as a draft This query has been published by Adam02020.

SQL

WITH pl_articles AS (
    SELECT
        page.page_title AS pl_title,
        page.page_id AS pl_id
    FROM categorylinks
    JOIN page ON page_id = cl_from
    WHERE cl_to = 'Bioinformatyka' AND page_namespace = 0
)

SELECT
    langlinks.ll_lang AS lang,
    pl_articles.pl_title AS pl_title,
    en_page.page_title AS en_title
FROM pl_articles
LEFT JOIN langlinks ON langlinks.ll_from = pl_articles.pl_id
LEFT JOIN enwiki_p.page AS en_page ON en_page.page_title = langlinks.ll_title
WHERE langlinks.ll_lang = 'en';

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...