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,  #! excluding subpage(s)

    # main.page_touched AS last_touched  #! not informative... i think

    (SELECT

        # count unique(?) language of this article

        COUNT(t_ll.ll_lang)

        FROM langlinks AS t_ll

        WHERE t_ll.ll_from = main.page_id

    ) AS total_lang,

    (SELECT 

        # count unique(?) articles in main namespace, that linked to this article 

        COUNT(t_pl.pl_from)

        FROM pagelinks AS t_pl

        INNER JOIN linktarget AS t_lt ON t_lt.lt_id = t_pl.pl_target_id AND t_lt.lt_namespace = 0

        WHERE t_lt.lt_title = main.page_title

    ) AS total_inlink,

    (SELECT

        # count unique(?) article in main namespace, that linked from this article

        COUNT(t_pl.pl_target_id)

        FROM pagelinks AS t_pl

        INNER JOIN linktarget AS t_lt ON t_lt.lt_id = t_pl.pl_target_id AND t_lt.lt_namespace = 0

        WHERE t_pl.pl_from = main.page_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

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

​

​

    # AND main.page_title IS NOT NULL

​

#! todo: is it possible to combine this with its article quality?

LIMIT 10;