SELECT DISTINCT

    main.page_title AS title_en,

    ll.ll_title AS title_id,

    cl.cl_to AS priority,

    main.page_len AS article_length,

    main.page_is_redirect AS is_redirect

​

FROM page AS p

LEFT JOIN categorylinks AS cl ON cl.cl_from = p.page_id

LEFT JOIN page AS main ON main.page_namespace = 0 AND main.page_title = p.page_title

LEFT JOIN langlinks AS ll ON main.page_id = ll.ll_from AND ll.ll_lang = 'id'

​

WHERE cl.cl_to IN ('Top-priority_mathematics_articles',

                   'High-priority_mathematics_articles',

                   'Mid-priority_mathematics_articles',

                   'Low-priority_mathematics_articles')