تعريب - Quarry

SQL

use arwiki_p;
select p.page_title, count(*)
from page p
inner join langlinks l1
on l1.ll_from = p.page_id
inner join enwiki_p.page
on enwiki_p.page.page_title = replace(l1.ll_title, " ", "_")
inner join enwiki_p.pagelinks
on enwiki_p.pagelinks.pl_from = enwiki_p.page.page_id
inner join enwiki_p.page p2
on p2.page_title = enwiki_p.pagelinks.pl_title
inner join enwiki_p.langlinks el
on p2.page_id  = el.ll_from
inner join page p3
on p3.page_title = replace(el.ll_title, " ", "_")
where p.page_is_redirect = 0
and p.page_namespace = 0
and enwiki_p.page.page_namespace = 0
and enwiki_p.page.page_is_redirect = 0
and p2.page_is_redirect = 0
and p2.page_namespace = 0
and p3.page_namespace = 0
and p3.page_is_redirect = 0
and l1.ll_lang like "en"
and el.ll_lang like "ar"
and enwiki_p.pagelinks.pl_title not in (select page_title from page where page_title = enwiki_p.pagelinks.pl_title and
                                       page_namespace = 0
                                       )
group by p.page_title
order by count(*) desc
limit 10;
SQL

Checking query status...
