USE fawiki_p;

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

FROM fawiki_p.page

where page_id IN (

        SELECT cl_from

        FROM langlinks INNER join categorylinks

        WHERE cl_to = "همه_صفحه•های_ابهام•زدایی" and ll_lang = "en" and ll_from =  cl_from

        )

        and page_title in (SELECT ll_title

        FROM enwiki_p.langlinks

        WHERE ll_lang = "fa" and

        ll_from not in (

        SELECT cl_from

        from enwiki_p.categorylinks

        where  cl_to ="All_disambiguation_pages")) and page_namespace=0 and page_is_redirect =0;