Untitled query #46026

SQL

use enwiki_p;
select DISTINCT CONCAT('Category:' , p1.page_title), replace (p1.page_title, "People_from_", "") , lle.ll_title
from page p1 , langlinks lle
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 in ( "Disambiguation_categories" , "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")
#group by p1.page_title

 limit 10
SQL

Checking query status...
