RDAB - Quarry

SQL

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
SQL

Checking query status...
