SQL
x
USE fawiki_p;
SELECT DISTINCT concat('# [[',REPLACE(page_title,'_',' '),']]')
FROM page JOIN categorylinks ON cl_from = page_id
WHERE page_namespace=0
AND cl_to LIKE 'روستاهای_شهرستان%'
AND page_id NOT IN (
SELECT cl_from
FROM categorylinks
WHERE cl_to LIKE '%لهستان%'
OR cl_to LIKE '%آمریکا%'
)
AND page_id NOT IN (
SELECT tl_from
FROM templatelinks
WHERE tl_title LIKE 'جعبه_اطلاعات_روستای_ایران%'
OR tl_title LIKE 'Infobox_settlement%'
)
#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.