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

​