بوابات معادلة من الإنجليزية-صفحة المقالة نفسها

SQL

use arwiki_p;
select p1.page_title, group_concat(ll2.ll_title)
from page p1
inner join langlinks ll1
on ll1.ll_from = p1.page_id
inner join enwiki_p.page p2
on p2.page_title = replace(ll1.ll_title," ","_")
inner join enwiki_p.page p3
on p3.page_title = p2.page_title
inner join enwiki_p.pagelinks pl1
on pl1.pl_from = p3.page_id
inner join enwiki_p.page p4
on p4.page_title = pl1.pl_title
inner join enwiki_p.langlinks ll2
on ll2.ll_from = p4.page_id
where p1.page_namespace = 0
and p1.page_is_redirect = 0
and ll1.ll_lang = "en"
and p2.page_namespace = 0
and p2.page_is_redirect = 0
and p3.page_is_redirect = 0
and p3.page_namespace = 0
and pl1.pl_namespace = 100
and p4.page_is_redirect = 0
and p4.page_namespace = 100
and ll2.ll_lang = "ar"
and pl1.pl_title not in (select enwiki_p.pagelinks.pl_title from enwiki_p.pagelinks 
                     where
                     enwiki_p.pagelinks.pl_from_namespace = 10
                     and enwiki_p.pagelinks.pl_namespace = 100
                     and pl1.pl_title = enwiki_p.pagelinks.pl_title
                    )
and p1.page_id not in (select cl_from from categorylinks where cl_to = "صفحات_توضيح")
and p1.page_id not in (select cl_from from categorylinks where cl_to = concat("بوابة_",replace(replace(ll2.ll_title,"بوابة:","")," ","_"),"/مقالات_متعلقة"))
and ll2.ll_title not like "%/%"
group by p1.page_title
limit 10;
SQL

Checking query status...
