SQL on idwiki side #1

SQL

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;
SQL

Checking query status...
