USE fawiki_p;

SELECT DISTINCT CONCAT('# [[',page_title,']]'),CONCAT('، [[',page_title,' (ابهام•زدایی)]]')

FROM page

WHERE page_namespace=0

AND page_is_redirect=0

AND page_title NOT LIKE "%(%"

AND page_id NOT IN (

  SELECT pp_page

  FROM page_props

  WHERE pp_propname = 'disambiguation')

AND CONCAT(page_title,'_(ابهام•زدایی)') IN (

  SELECT page_title

  FROM page

  WHERE page_id IN (

    SELECT pp_page

    FROM page_props

    WHERE pp_propname = 'disambiguation')

  )

AND CONCAT(page_title,'_(ابهام•زدایی)') NOT IN (

  SELECT pl_title

  FROM pagelinks 

  WHERE pl_from=page_id)

AND "دیگر_کاربردها" NOT IN (

  SELECT tl_title

  FROM templatelinks

  WHERE page_id=tl_from)

AND "درباره" NOT IN (

  SELECT tl_title

  FROM templatelinks

  WHERE page_id=tl_from)

AND "برای" NOT IN (

  SELECT tl_title

  FROM templatelinks

  WHERE page_id=tl_from)

ORDER BY page_title;