SELECT

    main.page_title AS title_id,

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

    main.page_len AS article_length

​

FROM page AS main

​

# inner join to cut table size

# focus to all possible priority

#INNER JOIN categorylinks AS cl_prio ON

#   cl_prio.cl_from = talk.page_id

#    AND cl_prio.cl_to IN (

#        'Artikel_matematika_sangat_penting',

#        'Artikel_matematika_penting',

#        'Artikel_matematika_cukup_penting',

#        'Artikel_matematika_kurang_penting',

#       'Artikel_matematika_NA')

​

# focus to all possible quality for an article in main namespace

#INNER JOIN categorylinks AS cl_qual ON

#   cl_qual.cl_from = talk.page_id

#    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')

​

# 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'