SQL on idwiki side #1

SQL

SELECT DISTINCT
  	page_title,
    page_len,
    GROUP_CONCAT(pl_title SEPARATOR ', ') as interwiki
FROM
	page, langlinks, pagelinks
WHERE
	page_title in (
      	SELECT page_title AS member
      	FROM categorylinks LEFT JOIN page ON (cl_from = page_id)
      	WHERE cl_to = "Top-priority_mathematics_articles"
    )	 										# Judul halaman ada di Kategori
    AND page_namespace = 0						# dan halaman itu ada di ruang nama Utama
    AND page_id = ll_from
    
#	AND page_id NOT IN (						# 2. namun tidak ada interwiki ke Bahasa Indonesia
#        SELECT ll_from
#        FROM langlinks
#        WHERE ll_lang = 'id'
#    )
#    AND ll_lang = 'id'							# 1. dan ada interwiki ke Bahasa Indonesia

ORDER BY
	page_len desc
LIMIT 10
;
SQL

Checking query status...
