SQL
AخA
USE fawiki_p;
SELECT concat('# [[',REPLACE(pl_title,'_',' '),']]'), concat('|',count(pl_title))
FROM pagelinks
WHERE pl_from = 3866510 # ویکی•پدیا:ویکی•پروژه تقسیمات کشوری ایران/فاز دوم/تقسیمات کشوری ۱۳۹۴/موقت
AND (pl_title NOT LIKE 'شهرستان%'
AND pl_title NOT LIKE 'شهرستان%'
AND pl_title NOT LIKE 'بخش%'
AND pl_title NOT LIKE 'دهستان%')
GROUP BY pl_title
ORDER BY count(pl_title) DESC
LIMIT 500;
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.