SQL
x
USE fawiki_p;
SELECT DISTINCT concat('# [[',REPLACE(page_title,'_',' '),']]'), MID(frst.cl_to,LOCATE('بخش',frst.cl_to)+5,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 '%بخشی%'
)
)
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));
LIMIT 100
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.