Fork of
ملخصات تعديلاتي
by Mr. Ibrahem
This query is marked as a draft
This query has been published
by Mr. Ibrahem.
SQL
AخA
/*USE enwiki_p;
SELECT page_title , p2.page_title
FROM page
WHERE page_namespace = 14
and page_title like '%the_Republic_of_Ireland';*/
USE enwiki_p;
SELECT
page_title , ll_title
FROM
page, langlinks
WHERE
ll_from = page_id
and page_namespace = 14
and page_title like '%the_Republic_of_Ireland'
and ll_lang = 'ar'
#and page_id in (select ll_from from langlinks where ll_lang = 'ar')
LIMIT 50;
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.