This query is marked as a draft This query has been published by Kekavigi.

SQL

x
 
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
        LEFT 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
        LEFT 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
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'
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...