use arwiki_p;

select p1.page_title,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 "%/%"

limit 10;