Untitled query #11990

SQL

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

Checking query status...
