mp12 fa DAB pages with en non-DAB pages interwiki

SQL

select CONCAT ('# [[',fap.page_title,']]	[[:en:',fall.ll_title,']]')
from fawiki_p.page as fap 
right join fawiki_p.page_props as fapp on fap.page_id = fapp.pp_page 
right join fawiki_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...