Untitled query #32031

SQL

use arwiki_p;
select p.page_title, replace(frtemp.tl_title, "Portail_","") as dd
from page p
inner join langlinks l1
on l1.ll_from = p.page_id
inner join frwiki_p.page frpage
on frpage.page_title = replace(l1.ll_title," ", "_")
inner join frwiki_p.templatelinks frtemp
on frtemp.tl_from = frpage.page_id
inner join frwiki_p.page p2
on p2.page_title = replace(frtemp.tl_title, "Portail_","")
where p.page_is_redirect = 0
and p.page_namespace =0
and frpage.page_namespace = 0
and frpage.page_is_redirect = 0
/*and p.page_id not in (select tl_from from templatelinks where tl_title = p3.page_title)*/
and frtemp.tl_from_namespace = 0
and p2.page_title like "Portail%"
and p2.page_is_redirect = 0
and frtemp.tl_namespace = 10
and l1.ll_lang like "fr"
and p.page_title like "ويرد_أل_يانكوفيك";
SQL

Checking query status...
