Untitled query #32031

SQL

use arwiki_p;
select p.page_title
from page p
inner join langlinks l1
on l1.ll_from = p.page_id
inner join frwiki_p.page
on frwiki_p.page.page_title = replace(l1.ll_title," ", "_")
inner join frwiki_p.templatelinks
on frwiki_p.templatelinks.tl_from = frwiki_p.page.page_id
inner join frwiki_p.page p2
on p2.page_title = replace(frwiki_p.templatelinks.tl_title, "Portail_","")
inner join frwiki_p.langlinks el
on p2.page_id  = el.ll_from
inner join page p3
on p3.page_title = replace(replace(el.ll_title, "قالب:",""), " ", "_")
where p.page_is_redirect = 0
and p.page_namespace =0
and frwiki_p.page.page_namespace = 0
and frwiki_p.page.page_is_redirect = 0
and p2.page_title like "Portail:%"
and p.page_id not in (select tl_from from templatelinks where tl_title = p3.page_title)
and p.page_id not in (select cl_from from categorylinks  where cl_to = 'صفحات_لا_تقبل_شريط_بوابات')
and p2.page_is_redirect = 0
and p2.page_namespace = 100
and p3.page_namespace = 100
and p3.page_is_redirect = 0
and l1.ll_lang like "fr"
and el.ll_lang like "ar"
limit 5;
SQL

Checking query status...
