Untitled query #58333

SQL

use arwiki_p;
select concat("قالب:بذرة_",page_title), concat("template:",ll_title, "-stub")
from page
inner join langlinks
on ll_from = page_id
where page_namespace = 0
and page_is_redirect = 0
and ll_lang = "en"
and concat("بذرة_",page_title) in (select page_title from page where page_namespace = 10 and page_is_redirect = 0 and page_title like "بذرة_%")
and LOWER(concat (replace(ll_title," ","_"), "-stub")) in  (select LOWER(p1.page_title) from enwiki_p.page p1
                                                     
                                                     where p1.page_namespace = 10 and p1.page_is_redirect = 0
                                                     and p1.page_title like "%-stub"
                                                     and p1.page_id not in (select ll1.ll_from from enwiki_p.langlinks ll1
                                                                           where ll1.ll_from = p1.page_id
                                                                           and ll1.ll_lang = "ar")
                                                    );
SQL

Checking query status...
