تعريب - Quarry

SQL

use arwiki_p;
select p.page_title
from page p
inner join pagelinks pl
on pl.pl_from = p.page_id
inner join page p2
on p2.page_title = pl.pl_title
inner join enwiki_p.langlinks ell
on ell.ll_from = p2.page_id
inner join enwiki_p.page ep
on ep.page_title = replace(ell.ll_title, " ","_")
inner join enwiki_p.langlinks arll
on arll.ll_from = ep.page_id
where p.page_is_redirect = 0
and p.page_namespace = 0
and ell.ll_lang like "en"
and arll.ll_lang like "ar"
and ep.page_namespace = 0
and ep.page_is_redirect = 0
and p2.page_namespace = 0
and p2.page_is_redirect = 0
/*and pl.pl_title not in (select page_title from page where page_title = pl.pl_title and
                                       page_namespace = 0)*/
limit 1;
SQL

Checking query status...
