Untitled query #46057

SQL

use enwiki_p;
select DISTINCT CONCAT('Template:' , p1.page_title), replace (p1.page_title, "_managers", "") , lle.ll_title
from page p1 , langlinks lle
where p1.page_namespace = 10
and p1.page_is_redirect = 0
and p1.page_title like "%_managers"
and p1.page_id not in (select ll_from from langlinks where ll_from = p1.page_id and ll_lang = "ar")
and ((select p2.page_id from page p2 
    where p2.page_namespace = 0 and p2.page_is_redirect = 0 and p2.page_title = replace (p1.page_title, "_managers", "")
    )  = lle.ll_from )
and lle.ll_lang = "ar"
group by p1.page_title
#limit 10
SQL

Checking query status...
