SELECT DISTINCT

    page_title,

    page_len,

    # GROUP_CONCAT(pl_title SEPARATOR ', ') as interwiki

    pl_title

FROM

    page, langlinks, pagelinks

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 page_id NOT IN (                        # 2. namun tidak ada interwiki ke Bahasa Indonesia

#        SELECT ll_from

#        FROM langlinks

#        WHERE ll_lang = 'id'

#    )

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

​

ORDER BY

    page_len desc

LIMIT 10

;