SELECT

    main.page_title AS title_en,

    ll.ll_title AS title_id,

    cl.cl_to AS priority,

    main.page_is_redirect AS is_redirect,

    main.page_len AS article_length,

    talk.page_len AS talk_length, 

    COUNT(DISTINCT t_ll.ll_lang) AS total_lang,

    COUNT(DISTINCT inlink.pl_from) AS total_inlink,

    COUNT(DISTINCT outlink.pl_target_id) AS total_outlink

FROM page AS talk

INNER JOIN categorylinks AS cl ON cl.cl_from = talk.page_id AND cl.cl_to IN (

    'Top-priority_mathematics_articles',

    'High-priority_mathematics_articles',

    'Mid-priority_mathematics_articles',

    'Low-priority_mathematics_articles',

    'NA-priority_mathematics_articles',

    'Unknown-priority_mathematics_articles')

INNER JOIN page AS main ON main.page_namespace = 0 AND main.page_title = talk.page_title

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

LEFT JOIN langlinks AS t_ll ON t_ll.ll_from = main.page_id

LEFT JOIN pagelinks AS inlink

    ON inlink.pl_target_id = main.page_id

    AND inlink.pl_namespace = 0

    AND inlink.pl_from_namespace = 0

LEFT JOIN pagelinks AS outlink

    ON outlink.pl_from = main.page_id

    AND outlink.pl_namespace = 0

    AND outlink.pl_from_namespace = 0

LEFT JOIN linktarget AS t_lt_inlink

    ON t_lt_inlink.lt_id = inlink.pl_target_id

    AND t_lt_inlink.lt_namespace = 0

LEFT JOIN linktarget AS t_lt_outlink

    ON t_lt_outlink.lt_id = outlink.pl_target_id

    AND t_lt_outlink.lt_namespace = 0

GROUP BY main.page_title, ll.ll_title, cl.cl_to, main.page_is_redirect, main.page_len, talk.page_len

LIMIT 10;

​