Untitled query #88038

SQL

SELECT DISTINCT
	REPLACE(B.title, '_', ' ') AS title
FROM
(
SELECT
	SUBSTRING(p.page_title, 1, LOCATE('(', p.page_title) - 2) AS title
FROM
	page p
WHERE
	p.page_namespace = 0
    AND p.page_title LIKE '%_(%'
	AND p.page_is_redirect = 0

) B

INNER JOIN page p2
ON B.title = p2.page_title
AND p2.page_namespace = 0
AND p2.page_is_redirect = 0

AND NOT EXISTS
	(SELECT lt.lt_title FROM templatelinks tl
    INNER JOIN linktarget lt
    ON tl.tl_target_id = lt.lt_id
    AND lt.lt_namespace = 10
	WHERE tl.tl_from = p2.page_id AND tl.tl_from_namespace = 0
	AND (lt.lt_title = 'Diğer_anlamı' OR
		 lt.lt_title = 'Diğer_anlamı2' OR
		 lt.lt_title = 'Hakkında' OR
		 lt.lt_title = 'Dablink' OR
         lt.lt_title = 'İlknot' OR
		 lt.lt_title = 'İçin'
		)
	)

AND NOT EXISTS
	(SELECT pp.pp_page FROM page_props pp
	WHERE p2.page_id = pp.pp_page
	AND pp.pp_propname = 'disambiguation')

ORDER BY
	B.title

LIMIT 10000
SQL

Checking query status...
