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'

)

ORDER BY fap.page_title;;