Untitled query #84036

SQL

WITH TopPriorityMathArticles AS (
    SELECT DISTINCT p.page_id, p.page_title
    FROM page AS p
    LEFT JOIN categorylinks AS cl ON cl.cl_from = p.page_id
    WHERE cl.cl_to = 'Top-priority_mathematics_articles'
),
IndonesianArticles AS (
    SELECT DISTINCT p.page_id, p.page_title, ll.ll_title
    FROM page AS p
    LEFT JOIN langlinks AS ll ON ll.ll_from = p.page_id
    WHERE p.page_namespace = 0 AND ll.ll_lang = 'id'
)
SELECT tpma.page_title AS english_title, ia.ll_title AS indonesian_title
FROM TopPriorityMathArticles AS tpma
JOIN IndonesianArticles AS ia ON tpma.page_id = ia.page_id;
SQL

Checking query status...
