math articles that exist in enwiki and idwiki

SQL

SELECT
  	page_title,
    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 IN ("Top-priority_mathematics_articles",
                        "High-priority_mathematics_articles",
                        "Mid-priority_mathematics_articles",
                        "Low-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'							# dan ada interwiki ke Bahasa Indonesia
ORDER BY
	size_en desc
;

SQL

Checking query status...