Untitled query #23104

SQL

use enwiki_p;
select page_title
from page as p
where page_namespace = 0
and page_is_redirect = 0
and not exists (
      select null
      from page_props
      where pp_page = page_id and pp_propname = 'disambiguation'
)
and page_title like "_%\_(%"
and not exists (
    select null
    from page as p2 left join page_props as pp2 on pp2.pp_page = p2.page_id
    where pp2.pp_propname = 'disambiguation' and (
        p2.page_title = mid(p.page_title, 1, locate('_(', p.page_title) - 1)
        or p2.page_title = concat(
            mid(p.page_title, 1, locate('_(', p.page_title)),
            '(disambiguation)'
        )
    )
)
and exists (
    select null
    from page as p3
    where p3.page_title like concat(
        mid(p.page_title, 1, locate('_(', p.page_title)),
        '(%'
    )
    and p3.page_namespace = 0
    and p3.page_is_redirect = 0
    having count(*) = 1
)
order by page_title;
SQL

Checking query status...
