SQL
AخA
USE fawiki_p;
SELECT concat('# [[',REPLACE(pl_title,'_',' '),']]')#, count(pl_title)
FROM pagelinks INNER JOIN page ON pl_from = page_id
WHERE pl_namespace = 0
AND page_namespace = 4
AND page_title = 'ویکی•پروژه_تقسیمات_کشوری_ایران/فاز_دوم/تقسیمات_کشوری_۱۳۹۴'
AND NOT EXISTS (
SELECT NULL
FROM page
WHERE page_namespace = 0
AND page_title = pl_title
)
#GROUP BY pl_title
#ORDER BY count(pl_title) DESC;
ORDER BY pl_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.