List of top priority math articles missing on idwiki

Fork of List of top priority math articles missing on idwiki by Kekavigi

This query is marked as a draft This query has been published by Akbarali.

SQL

SELECT DISTINCT
  	page_title,
    page_len
    #ll_title
FROM
	page, langlinks
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 ll_lang = 'id'							# 1. dan ada interwiki ke Bahasa Indonesia
    
	AND page_id NOT IN (						# 2. namun tidak ada interwiki ke Bahasa Indonesia
        SELECT ll_from
        FROM langlinks
        WHERE ll_lang = 'id'
    )
ORDER BY
	page_len desc
;

SQL

Checking query status...