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

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 ((select p2.page_id from page p2 where p2.page_namespace = 0 and p2.page_title = replace (page_title, "People_from_", "") limit 1)
in (select ll_from
	from langlinks
	where ll_lang = "ar"
   ))
limit 1;

SQL

Checking query status...