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

SQL

use enwiki_p;
select p1.page_title, replace (p1.page_title, "People_from_", "")
from page p1
where p1.page_namespace = 14
and p1.page_is_redirect = 0
and p1.page_title like "People_from_%"
and p1.page_id not in (select cl_from
                    from  categorylinks
                    where cl_to = "Disambiguation_categories")
and p1.page_id not in (select cl_from
                    from  categorylinks
                    where cl_to = "Wikipedia_soft_redirected_categories")
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, "People_from_", ""))  in (select ll_from from langlinks where ll_lang = "ar"));

SQL

Checking query status...