SQL on idwiki side #1

SQL

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
    # COUNT(DISTINT pl.pl_target_id) AS total_outlink  		#! time/memory-limit exceeded
    COUNT(pl.lt_title) 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'
LEFT JOIN pagelinks AS pl ON pl.pl_from = main.page_id
LEFT JOIN linktarget AS lt ON lt.lt_id = pl.pl_target_id AND lt.lt_namespace = 0

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;
SQL

Checking query status...
