Untitled query #42829

SQL

use enwiki_p;
select DISTINCT p1.page_title , ll.ll_title
from categorylinks , page p1 , page p2 , langlinks ll
where cl_to = "Biography_articles_of_living_people"
and cl_from = p1.page_id
and p2.page_is_redirect = 0 and p1.page_is_redirect = 0
and p1.page_namespace = 1
and p2.page_namespace = 0
and p2.page_title = p1.page_title
and p2.page_id = ll.ll_from
and ll.ll_lang = 'ar'

and replace(ll.ll_title," " , "_") in (select pp.page_title from arwiki_p.categorylinks cc , arwiki_p.page pp 
                                       where cc.cl_to = "مقالات_أعلام_بدون_وسيط_حي"
                                       and cc.cl_from = pp.page_id 
                                       )
limit 20
SQL

Checking query status...
