تصنيفات "أشخاص من" بحاجة لإنشاء من المقابل الإنجليزي

SQL

use enwiki_p;
select page_title, replace (page_title, "People_from_", "")
from page
where page_namespace = 14
and page_is_redirect = 0
and page_title like "People_from_%"
and page_id not in (select cl_from
                    from  categorylinks
                    where cl_to = "Disambiguation_categories")
and page_id not in (select cl_from
                    from  categorylinks
                    where cl_to = "Wikipedia_soft_redirected_categories")
and page_id not in (select ll_from from langlinks where ll_from = page_id and ll_lang = "ar")
and replace (page_title, "People_from_", "")  in (select replace(" ","_",arwiki_p.langlinks.ll_title) 
                                                  from arwiki_p.langlinks
                                                  where arwiki_p.langlinks.ll_lang = "en"
                                                  and replace(" ","_",arwiki_p.langlinks.ll_title)
                                                  = replace (page_title, "People_from_", "") 
                                                 )
limit 1;

SQL

Checking query status...