SQL
AخA
use arwiki_p;
select page_title, ll_title, (select enwiki_p.page.page_id from enwiki_p.page where enwiki_p.page.page_title = ll_title)
from page
inner join langlinks
on ll_from = page_id
where page_namespace = 0
and page_is_redirect = 0
and page_title not in (select page_title from page where page_namespace = 14 and page_title = page_title)
and ll_lang= "en"
and ll_title in (select enwiki_p.page.page_title from enwiki_p.page where enwiki_p.page.page_namespace = 14
and enwiki_p.page.page_title = ll_title
and enwiki_p.page.page_is_redirect = 0)
limit 100;
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.