This query is marked as a draft This query has been published by Saeidpourbabak.

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.

Checking query status...