SELECT CONCAT ('# [[:en:',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'

)

ORDER BY enp.page_title;