SQL on idwiki side #1

SQL

SELECT DISTINCT
	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,

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 main.page_id = ll.ll_from 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')
                   
LIMIT 100;
SQL

Checking query status...
