Erroneous disambiguation templates on (dab)pages

SQL

select page_title from page
where page_title like '%\_(disambiguation)' and page_namespace = 0
and page_id in (
  select cl_from from categorylinks
  where cl_type = 'page' and cl_to in (
    'Redirects_from_ambiguous_terms', 'Redirects_from_incomplete_disambiguation', 'Redirects_from_unnecessary_disambiguation'
  )
)
/*
select page_title -- , page_is_redirect
from page where page_namespace = 0
-- and page_title like '%(Disambiguation)%'
-- and page_title rlike '[^\_]\\(' and page_title rlike '\\)$'
-- and page_title like '%)(%'
-- and page_title like '%()%'
and page_title rlike '\\(disambiguation\\)' and page_title not rlike '\\(disambiguation\\)$' 
and page_is_redirect = 0
*/

SQL

Checking query status...