قوالب بذور بحاجة لربط مع المقابل الإنجليزي

SQL

use arwiki_p;
select page_title, ll_title
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 concat (replace(ll_title," ","_"), "-stub") in  (select 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.from = p1.page_id
                                                                           and ll1.ll_lang = "ar")
                                                    
                                                    )
/*and (select page_id from page where page_title = concat("بذرة_",page_title) and page_namespace = 10 and page_is_redirect = 0)
	not in
    (select ll_from from langlinks)*/
limit 10;
SQL

Checking query status...
