950401 mp1 # of redirected links to DAB pages (articles)

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'
)
ORDER BY fap.page_title;

SQL

Checking query status...