SELECT

    main.page_title AS title_id,

    ll.ll_title AS title_en,

    main.page_len AS article_length

​

FROM page AS talk

​

# 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_namespace = 0

    AND main.page_title = talk.page_title

​

LEFT JOIN langlinks AS ll ON

     ll.ll_from = main.page_id

    AND ll.ll_lang = 'en'

WHERE main.page_is_redirect =0

​