Exists a page "A (B)" but do not exists a page "A"

Fork of Exists a page "A (B)" but do not exists a page "A" by Pelmeen10

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

SQL

USE elwiki_p;
SELECT CONCAT ('# [[',REPLACE(MID(Target.page_title,1,LOCATE('(',Target.page_title)-2),'_',' '),']]	[[',REPLACE(Target.page_title,'_',' '),']]')
FROM page AS Target
WHERE Target.page_namespace = 0
AND Target.page_is_redirect = 0
AND Target.page_title LIKE "%(%"
AND Target.page_title NOT LIKE "(%"
#AND Target.page_title NOT LIKE "Episodi%"
AND Target.page_id NOT IN (
  SELECT pp_page
  FROM page_props
  WHERE pp_propname = 'αποσαφήνιση'
  )
AND MID(Target.page_title,1,LOCATE('(',Target.page_title)-2) NOT IN (
  SELECT Source.page_title
  FROM page AS Source
  WHERE Source.page_namespace = 0
  )
ORDER BY Target.page_title
LIMIT 2999;

SQL

Checking query status...