SELECT

    main.page_title AS title_id,

    REPLACE(ll.ll_title,' ','_') AS title_en,

    main.page_len AS article_length

​

FROM page AS talk

​

INNER JOIN categorylinks AS cl_prio

ON cl_prio.cl_from = talk.page_id

​

# unused because redundant right now

#INNER JOIN categorylinks AS cl_qual

#ON cl_qual.cl_from = talk.page_id

​

# join to get the main article's ID

INNER JOIN page AS main

ON main.page_title = talk.page_title

​

LEFT JOIN langlinks AS ll

ON ll.ll_from = main.page_id

WHERE main.page_is_redirect = 0

    AND main.page_namespace = 0

    AND ll.ll_lang = 'en'

    AND cl_prio.cl_to IN (

        'Artikel_matematika_sangat_penting',

        'Artikel_matematika_penting',

        'Artikel_matematika_cukup_penting',

        'Artikel_matematika_kurang_penting',

        'Artikel_matematika_NA')

#    AND cl_qual.cl_to IN (

#        'Artikel_matematika_kelas_AP',

#        'Artikel_matematika_kelas_MP',

#        'Artikel_matematika_kelas_AB',

#        'Artikel_matematika_kelas_B',

#        'Artikel_matematika_kelas_C',

#        'Artikel_matematika_kelas_awal',

#        'Artikel_matematika_kelas_rintisan',

#        'Artikel_matematika_kelas_daftar',

#        'Artikel_matematika_kelas_disambig',

#       'Artikel_matematika_kelas_pengalihan',

#       'Artikel_matematika_belum_dinilai')

​