1 - Quarry

SQL

select fap.page_title, fall.ll_title
from arwiki_p.page as fap 
right join arwiki_p.page_props as fapp on fap.page_id = fapp.pp_page 
right join arwiki_p.langlinks as fall on fap.page_id = fall.ll_from
where fap.page_namespace = 0 
and fap.page_is_redirect = 0 
and fapp.pp_propname = 'disambiguation'
and fall.ll_lang = "en"
and replace(fall.ll_title, ' ', '_') not in ( # enwiki disambig titles
    select enp.page_title
    from enwiki_p.page as enp right join enwiki_p.page_props as enpp on enp.page_id = enpp.pp_page
    where enp.page_namespace = 0 
    and enp.page_is_redirect = 0
    and enpp.pp_propname = 'disambiguation'
);
SQL

Checking query status...
