SQL
AخA
SELECT DISTINCT
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 = "Top-priority_mathematics_articles"
) # Judul halaman ada di Kategori
AND page_namespace = 0 # dan halaman itu ada di ruang nama Utama
AND ( # dan salah satu dari dua kemungkinan ini:
(page_id = ll_from AND ll_lang = 'id') # 1. ada interwiki ke Bahasa Indonesia
OR page_id NOT IN ( # 2. tidak ada interwiki ke Bahasa Indonesia
SELECT ll_from
FROM langlinks
WHERE ll_lang = 'id'
)
)
;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.