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.