This query is marked as a draft This query has been published by Saeidpourbabak.

SQL

x
 
USE fawiki_p;
#SELECT CONCAT ('# [[',REPLACE(MID(Source.page_title,1,LOCATE('(',Source.page_title)-2),'_',' '),']]    [[',REPLACE(Source.page_title,'_',' '),']]')
SELECT CONCAT ('# [[',REPLACE(Source.page_title,'_',' '),']]    [[',REPLACE(concat(MID(Source.page_title,1,LOCATE('(',Source.page_title)-2),'_(ابهامزدایی)'),'_',' '),']]')
FROM page AS Source
WHERE Source.page_namespace = 0
AND Source.page_is_redirect = 1
AND Source.page_title LIKE "%(%"
AND Source.page_title NOT 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 concat(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 Source.page_id NOT IN (
  SELECT tl_from
  FROM templatelinks
  WHERE tl_from_namespace = 1
  AND tl_title LIKE 'R_from_incomplete_disambiguation'
)
  
/*AND page_id NOT IN (
  SELECT cl_from
  FROM categorylinks
  WHERE cl_to = 'تغییرمسیرهای_حاصل_از_ابهامزدایی_نالازم'
)*/
ORDER BY Source.page_title;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...