select p1.page_title, rd_title from page p1

join redirect on p1.page_id = rd_from and rd_namespace = 0

join page p2 on p2.page_title = rd_title and p2.page_namespace = 0

where p1.page_namespace = 0 and p1.page_is_redirect = 1

-- and length(replace(page_title, '(', '')) != length(replace(page_title, ')', '')) -- and page_title like '%\_%'

-- and page_title like '%\_(Disambiguation)'

-- and page_title like '%\_(upcoming%)'

-- and page_title rlike '(upcoming|untitled)' collate utf8_general_ci

and p1.page_title rlike '[^_-]\\(.*\\)$'

/*

and p2.page_id not in (

  select tl_from from templatelinks

  where tl_target_id in (

    select lt_id from linktarget 

    where lt_title in ('Chembox', 'Enzymes', 'Drugbox') and lt_namespace = 10

  )

)

*/

limit 1000