SELECT

    main.page_title AS title_en,

    ll.ll_title AS title_id,

    cl.cl_to AS priority,

    (SELECT COUNT(t_ll.ll_lang) FROM langlinks AS t_ll WHERE t_ll.ll_from = main.page_id)

    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

    # COUNT(DISTINT pl.pl_target_id) AS total_outlink       #! time/memory-limit exceeded

​

FROM page AS talk

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

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

# LEFT JOIN pagelinks AS pl ON pl.pl_from = main.page_id # AND pl.pl_namespace = 0

​

WHERE

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

    # AND main.page_title IS NOT NULL

​

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

LIMIT 10;