SQL
AخA
USE fawiki_p;
SELECT concat('* [[:رده:',REPLACE(frst.page_title,'_',' '),']] > [[:رده:',REPLACE(REPLACE(frst.page_title,'_',' '),'شهرک•ها و روستاها','حوادث و سوانح'),']]')
FROM page AS frst
WHERE frst.page_is_redirect=0
AND frst.page_namespace=14
AND frst.page_title LIKE "شهرک•ها_و_روستاها_در_شهرستان%"
/*AND NOT EXISTS (
SELECT null
FROM page AS scnd
WHERE scnd.page_namespace=14
AND REPLACE(frst.page_title,'طرقبه_شاندیز','بینالود')=scnd.page_title
)*/
AND frst.page_id NOT IN (
SELECT cl_from
FROM categorylinks
WHERE cl_to = 'رده•های_منتقل•شده'
)
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.