USE enwiki_p;

SELECT /*SLOW OK*/ CONCAT ( '# [[',page_title,']]')

FROM enwiki_p.page

where page_id IN (

        SELECT cl_from

        FROM langlinks INNER join categorylinks

        WHERE cl_to ="All_disambiguation_pages" and ll_lang = "fa" and ll_from =  cl_from

        )

        and page_title in (SELECT ll_title

        FROM fawiki_p.langlinks

        WHERE ll_lang = "en" and

        ll_from not in (

        SELECT cl_from

        from fawiki_p.categorylinks

        where  cl_to = "همه_صفحه•های_ابهام•زدایی" )) and page_namespace=0 and page_is_redirect =0;