SELECT

    source.page_id as source,

    target.page_id as target

    #source.page_title AS title_source,

    #cl.cl_to AS priority,

    #target.page_title AS title_target,

​

    #SUM(CASE WHEN cl2.cl_to = 'Top-priority_mathematics_articles' THEN 1 ELSE 0 END) AS to_top,

    #SUM(CASE WHEN cl2.cl_to = 'High-priority_mathematics_articles' THEN 1 ELSE 0 END) AS to_high,

    #SUM(CASE WHEN cl2.cl_to = 'Mid-priority_mathematics_articles' THEN 1 ELSE 0 END) AS to_mid,

    #SUM(CASE WHEN cl2.cl_to = 'Low-priority_mathematics_articles' THEN 1 ELSE 0 END) AS to_low,

    #SUM(CASE WHEN cl2.cl_to = 'NA-priority_mathematics_articles'

    #          OR cl2.cl_to = 'Unknown-priority_mathematics_articles' THEN 1 ELSE 0 END) AS to_na

​

FROM

    # hubungan antar artikel

    page AS source

    INNER JOIN pagelinks AS pl ON source.page_id = pl.pl_from

    INNER JOIN linktarget AS lt ON pl.pl_target_id = lt.lt_id

    INNER JOIN page AS target ON lt.lt_title = target.page_title

​

    # hubungan source dengan halaman diskusinya dan kategori di halaman itu

    INNER JOIN page AS talk ON source.page_title = talk.page_title

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

​

    # hubungan target dengan halaman diskusinya dan kategori di halaman itu

    INNER JOIN page AS talk2 ON target.page_title = talk2.page_title

    INNER JOIN categorylinks AS cl2 ON talk2.page_id = cl2.cl_from

​

WHERE

    # source ada di main dan bukan redirect

    source.page_namespace = 0

    AND source.page_is_redirect = 0

    # target ada di main dan bukan redirect

    #AND pl.pl_namespace = 0

    AND lt.lt_namespace = 0

    AND target.page_namespace = 0

    AND target.page_is_redirect = 0

    # talk ada di talk :D

    AND talk.page_namespace = 1

    AND talk2.page_namespace = 1

    # source dan target harus bertopik matematika

    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') >= 1_010_920 rows

    AND cl2.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')

   #GROUP BY title_source