Untitled query #31922

SQL

use arwiki_p;
select p.page_title, count(l2.ll_title)
from page p
inner join pagelinks
on pl_from = p.page_id
inner join page p2
on p2.page_title = pl_title
inner join langlinks l1
on l1.ll_from = p2.page_id
inner join enwiki_p.page p3
on p3.page_title= replace(l1.ll_title," ", "_")
inner join enwiki_p.langlinks l2
on l2.ll_from = p3.page_id
where pl_from_namespace = 0
and pl_namespace = 0
and pl_title not in (select page_title from page where page_title = pl_title and page_is_redirect = 0 and page_namespace = 0)
and pl_title regexp "[A-Za-z0-9]"
and l1.ll_lang = "en"
and p2.page_namespace =0
and p2.page_is_redirect =0
and l2.ll_lang = "ar"
and p3.page_namespace = 0
and p3.page_is_redirect = 0
and p.page_is_redirect = 0
and p.page_namespace = 0
group by p.page_title
order by count(l2.ll_title) desc
limit 10;
SQL

Checking query status...
