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

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.

Checking query status...