SQL
x
USE fawiki_p;
SELECT pl_title
FROM pagelinks
WHERE pl_from = 4092254 # ویکی•پدیا:ویکی•پروژه تقسیمات کشوری ایران/فاز دوم/تقسیمات کشوری ۱۳۹۵
AND pl_title LIKE "شهرستان%"
#AND REPLACE(REPLACE(REPLACE(CONCAT('مناطق_مسکونی_در_',pl_title),'_',''),'•',''),'ی','ئ') NOT IN (
#AND REPLACE(REPLACE(REPLACE(CONCAT('روستاهای_',pl_title),'_',''),'•',''),'ی','ئ') NOT IN (
AND REPLACE(REPLACE(REPLACE(CONCAT('شهرهای_',pl_title),'_',''),'•',''),'ی','ئ') NOT IN (
SELECT REPLACE(REPLACE(REPLACE(page_title,'_',''),'•',''),'ی','ئ')
FROM page
WHERE page_namespace = 14
AND page_is_redirect = 0
)
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.