RDAB - Quarry

SQL

select p1.page_title, p2.page_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 p1.page_title like '%)(%'
and p2.page_title not rlike '[^_-]\\('
and p1.page_id not in (
  select tl_from from templatelinks
  where tl_target_id in (
    select lt_id from linktarget 
    where lt_title in ('R_from_abbreviation') and lt_namespace = 10
  )
)
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
  )
)

-- select page_title, page_is_redirect from page where page_namespace = 0 and page_title like '%\_(Literature)'
SQL

Checking query status...
