select

  page_title

from

  page

where

  page_namespace = 0

  and page_is_redirect = 0

  and (

    page_title regexp ".*_\\(.*\\)$"

    and not exists (

      select

        1

      from

        page pp

      where

        pp.page_namespace=0 and 

        pp.page_title = regexp_replace("\\(.*\\)", page.page_title, "")

    )

  )

  and not exists (

    select

      1

    from

      templatelinks

      join linktarget on lt_id = tl_target_id

    where

      tl_from = page_id

      and lt_namespace = 10

      and (

        lt_title = "Title_notice"

        or lt_title = "Proposed_deletion/dated"

      )

  )

order by

  page_title

limit

  10000;