Untitled query #46026

SQL

use enwiki_p;
select 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 ((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_", "")
    )  = lle.ll_from )


 limit 30
SQL

Checking query status...
