تصانيف جاهزة بحاجة لإنشاء من المقابل الإنجليزي حسب عنوان المقالة

SQL

use arwiki_p;
select page_title as "عنوان المقالة", replace(ll_title," ","_") as "التصنيف الإنجليزي", concat("تصنيف:",page_title) as "اسم التصنيف الذي بحاجة لإنشاء"
from page
inner join langlinks
on ll_from = page_id
where page_namespace = 0
and page_is_redirect = 0
and page_title not in (select page_title from page where page_namespace = 14 and page_title = page_title)
and ll_lang= "en"
and replace(ll_title," ","_") in (select enwiki_p.page.page_title from enwiki_p.page where enwiki_p.page.page_namespace = 14 
                 and enwiki_p.page.page_title = replace(ll_title," ","_")
                 and enwiki_p.page.page_is_redirect = 0)
/*and (select enwiki_p.page.page_id from enwiki_p.page 
                              where enwiki_p.page.page_title = replace(ll_title," ","_")
                              and enwiki_p.page.page_namespace = 14) not in 
                              (select enwiki_p.langlinks.ll_from from enwiki_p.langlinks where enwiki_p.langlinks.ll_lang = "ar")*/
and page_id not in (select cl_from from categorylinks where cl_to = "صفحات_توضيح" and cl_from = page_id)
and (select enwiki_p.page.page_id from enwiki_p.page 
     where enwiki_p.page.page_title = replace(ll_title," ","_")
     and enwiki_p.page.page_namespace = 14) not in ((select enwiki_p.categorylinks.cl_from
                                                   from  enwiki_p.categorylinks
                                                   where  enwiki_p.categorylinks.cl_to = "Disambiguation_categories"))
and (select enwiki_p.page.page_id from enwiki_p.page 
     where enwiki_p.page.page_title = replace(ll_title," ","_")
     and enwiki_p.page.page_namespace = 14) not in ((select enwiki_p.categorylinks.cl_from
                                                   from  enwiki_p.categorylinks
                                                   where  enwiki_p.categorylinks.cl_to = "Wikipedia_soft_redirected_categories"))
and (select enwiki_p.page.page_id from enwiki_p.page 
     where enwiki_p.page.page_title = replace(ll_title," ","_")
     and enwiki_p.page.page_namespace = 14) not in (select enwiki_p.langlinks.ll_from from enwiki_p.langlinks where 
                                                    enwiki_p.langlinks.ll_lang = "ar");
SQL

Checking query status...
