SQL
AخA
USE fawiki_p;
SELECT DISTINCT concat('# [[',REPLACE(page_title,'_',' '),']]'), MID(frst.cl_to,LOCATE('استان',frst.cl_to)+7,LENGTH(frst.cl_to))
FROM categorylinks AS frst INNER JOIN page ON frst.cl_from=page_id
WHERE page_namespace = 0
AND page_is_redirect = 0
AND frst.cl_to LIKE '%استان%'
AND frst.cl_to NOT LIKE '%استان•ها%'
AND frst.cl_from NOT IN (
SELECT cl_from
FROM categorylinks AS scnd
WHERE (
scnd.cl_to LIKE '%باستانی%'
OR scnd.cl_to LIKE '%داستان%'
OR scnd.cl_to LIKE '%استاندارد%'
OR scnd.cl_to LIKE '%مصر%'
OR scnd.cl_to LIKE '%اسپانیا%'
OR scnd.cl_to LIKE '%رودخانه%'
)
)
AND frst.cl_from IN (
SELECT cl_from
FROM categorylinks AS scnd
WHERE scnd.cl_to LIKE '%استان%'
AND scnd.cl_to NOT LIKE '%استان•ها%'
AND MID(frst.cl_to,LOCATE('استان',frst.cl_to)+8,LENGTH(frst.cl_to)) <> MID(scnd.cl_to,LOCATE('استان',scnd.cl_to)+8,LENGTH(scnd.cl_to))
)
ORDER BY MID(frst.cl_to,LOCATE('دهستان',frst.cl_to)+13,LENGTH(frst.cl_to));
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.