tpmp2 Pages with title like "A (B)" redirecting to DAB page "A" or "A (disambiguation)" having {{R from move}} not having {{R from incomplete disambiguation}}

SQL

USE fawiki_p;
SELECT CONCAT ('# [[',REPLACE(MID(Source.page_title,1,LOCATE('(',Source.page_title)-2),'_',' '),']]	[[',REPLACE(Source.page_title,'_',' '),']]')
FROM page AS Source
WHERE Source.page_namespace = 0
AND Source.page_is_redirect = 1
AND Source.page_title LIKE "%(%"
AND MID(Source.page_title,1,LOCATE('(',Source.page_title)-2) IN (
  SELECT Target.page_title
  FROM page AS Target
  WHERE Target.page_namespace = 0
  AND Target.page_is_redirect = 0
  AND Source.page_id IN (
    SELECT rd_from
    FROM redirect
    WHERE rd_title=Target.page_title
    )
  AND Target.page_id IN (
  SELECT pp_page
  FROM page_props
  WHERE pp_propname = 'disambiguation'
  )
  )
/*AND page_id NOT IN (
  SELECT cl_from
  FROM categorylinks
  WHERE cl_to = 'تغییرمسیرهای_حاصل_از_ابهام‌زدایی_نالازم'
)*/

LIMIT 50
#ORDER BY Source.page_title;

SQL

Checking query status...