USE fawiki_p;

(

  SELECT pl_title

  FROM pagelinks

  JOIN page ON pl_namespace=page_namespace AND pl_title=page_title

  JOIN redirect ON page_id=rd_from

  WHERE pl_from_namespace=0

  AND pl_namespace=0

  AND page_is_redirect=1

  AND pl_from IN (

    SELECT page_id

    FROM page

    WHERE REPLACE(page_title,'_',' ') LIKE "رآکتور شیمیایی")

  AND rd_title IN (

    SELECT page_title

    FROM page

    WHERE page_id IN (

      SELECT pp_page

      FROM page_props

      WHERE pp_propname = 'disambiguation'))

  AND page_title<>'محلول_درصدی_(ابهام•زدایی)'

)

UNION

(

  SELECT pl_title

  FROM pagelinks JOIN page ON pl_namespace=page_namespace AND pl_title=page_title

  WHERE pl_from_namespace=0

  AND pl_namespace=0

  AND page_is_redirect=0

  AND pl_from IN (

    SELECT page_id

    FROM page

    WHERE REPLACE(page_title,'_',' ') LIKE "رآکتور شیمیایی"

    AND pl_title<>concat(page_title,'_(ابهام•زدایی)'))

  AND page_id IN (

    SELECT pp_page

    FROM page_props

    WHERE pp_propname = 'disambiguation')

);