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

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.

Checking query status...