Untitled query #84045

SQL

SELECT
    main.page_title AS title_en,
    COUNT(DISTINCT inlinks.pl_from) AS total_inlink,
    COUNT(DISTINCT outlinks.pl_target_id) AS total_outlink
FROM page AS talk
-- inner join to cut table size
INNER JOIN categorylinks AS cl_prio ON
    cl_prio.cl_from = talk.page_id
    AND cl_prio.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')
-- focus to all possible quality for an article in main namespace
INNER JOIN categorylinks AS cl_qual ON
    cl_qual.cl_from = talk.page_id
    AND cl_qual.cl_to IN (
        'FA-Class_mathematics_articles',
        'FL-Class_mathematics_articles',
        'FM-Class_mathematics_articles',
        'GA-Class_mathematics_articles',
        'B-Class_mathematics_articles',
        'C-Class_mathematics_articles',
        'Start-Class_mathematics_articles',
        'Stub-Class_mathematics_articles',
        'List-Class_mathematics_articles',
        'Disambig-Class_mathematics_articles',
        'Redirect-Class_mathematics_articles',
        'Unassessed_mathematics_articles')
-- join to get the main article's ID
INNER JOIN page AS main ON
    main.page_namespace = 0
    AND main.page_title = talk.page_title
-- join to count inlinks
LEFT JOIN pagelinks AS inlinks ON
    inlinks.pl_target_id = main.page_id
    AND inlinks.pl_from_namespace = 0
-- join to count outlinks
LEFT JOIN pagelinks AS outlinks ON
    outlinks.pl_from = main.page_id
    AND outlinks.pl_namespace = 0
GROUP BY main.page_title

LIMIT 10;
SQL

Checking query status...
