Fork of mp7.2 Pages with title like "A (B)" where page "A" does not exist by Saeidpourbabak
This query is marked as a draft This query has been published by Mr. Ibrahem.

SQL

AخA
 
USE arwiki_p;
SELECT REPLACE(concat('# [[',page_title,']]'),'_',' '),REPLACE(concat(', [[',MID(page_title,1,LOCATE('(',page_title)-2),']]'),'_',' ')
FROM page
WHERE page_namespace=0
AND page_is_redirect=0
AND page_title LIKE "%(%"
AND page_title NOT LIKE "(%"
AND page_title LIKE "%)"
#AND page_title NOT LIKE "%(ابهام•زدایی)"
#AND page_title NOT LIKE "%I%"
#AND page_title NOT LIKE "%V%"
#AND page_title NOT LIKE "زمین•لرزه%"
#AND page_title NOT LIKE "انتخابات%"
AND MID(page_title,1,LOCATE('(',page_title)-2) NOT IN (
  SELECT page_title
  FROM page
  WHERE page_namespace = 0
  AND page_title NOT LIKE "%(%"
#  AND page_is_redirect = 0
  )
#AND NOT EXISTS (
  #SELECT null
  #FROM categorylinks
  #WHERE cl_from=page_id
  #AND cl_to LIKE "مقاله•های_خرد_کشتی_یا_قایق"
  #)
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.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...