SQL
AخA
USE fawiki_p;
SELECT DISTINCT REPLACE(concat(frst.page_title,'_(ابهام•زدایی)'),'_',' '),REPLACE(frst.page_title,'_',' ')
FROM page AS frst
WHERE frst.page_is_redirect=0
AND frst.page_namespace=0
AND frst.page_title NOT LIKE "%(ابهام•زدایی)%"
AND frst.page_id IN (
SELECT pp_page
FROM page_props
WHERE pp_propname = 'disambiguation'
)
AND NOT EXISTS (
SELECT null
FROM page AS scnd
WHERE concat(frst.page_title,'_(ابهام•زدایی)')=scnd.page_title
)
ORDER BY 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.