USE

    enwiki_p

SELECT

    page_title title_en,

    ll_title title_id,

    page_len size_en

FROM

    page, langlinks

WHERE

    page_title in (

        SELECT page_title AS member

        FROM categorylinks LEFT JOIN page ON (cl_from = page_id)

        WHERE cl_to = "Top-priority_mathematics_articles"

    )                                           # Judul halaman ada di Kategori

    AND page_namespace = 0                      # dan halaman itu ada di ruang nama Utama

    AND page_id = ll_from

    AND ll_lang = 'id'                          # dan ada interwiki ke Bahasa Indonesia

ORDER BY

    size_en desc

;