USE fawiki_p;

SELECT CONCAT ( '# [[',page_title,']]')

FROM fawiki_p.page

WHERE page_id IN (

  SELECT pp_page

  FROM langlinks INNER JOIN page_props

  WHERE pp_propname = 'disambiguation'

  AND ll_lang = "en"

  AND ll_from =  pp_page)

  AND page_title IN (

    SELECT ll_title

    FROM enwiki_p.langlinks

    WHERE ll_lang = "fa"

    AND ll_from NOT IN (

      SELECT pp_page FROM

      enwiki_p.page_props

      WHERE pp_propname = 'disambiguation')

    AND page_namespace=0

    AND page_is_redirect =0

  );