Erroneous disambiguation templates on (dab)pages

SQL

select page_title from page
where page_title like '%\_(disambiguation)'
and page_id in (
  select cl_from from categorylinks
  where cl_to in ('Redirects_from_ambiguous_terms', 'Redirects_from_incomplete_disambiguation') and cl_type = 'page'
)

/*
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...