Redirs ending in '(disambiguation)' not to pages in [[Category:All disambiguation pages]]

SQL

SELECT
  CONCAT('[[',
    (CASE src.page_namespace
      WHEN 0 THEN ''            WHEN 1 THEN 'Talk:'
      WHEN 2 THEN 'User:'       WHEN 3 THEN 'User talk:'
      WHEN 4 THEN 'Wikipedia:'  WHEN 5 THEN 'Wikipedia talk:'
      WHEN 6 THEN ':File:'      WHEN 7 THEN 'File talk:'
      WHEN 8 THEN 'MediaWiki:'  WHEN 9 THEN 'MediaWiki talk:'
      WHEN 10 THEN 'Template:'  WHEN 11 THEN 'Template talk:'
      WHEN 12 THEN 'Help:'      WHEN 13 THEN 'Help talk:'
      WHEN 14 THEN ':Category:' WHEN 15 THEN 'Category talk:'
      WHEN 100 THEN 'Portal:'   WHEN 101 THEN 'Portal talk:'
      WHEN 108 THEN 'Book:'     WHEN 109 THEN 'Book talk:'
      WHEN 118 THEN 'Draft:'    WHEN 119 THEN 'Draft talk:'
      ELSE CONCAT('{{ns:', src.page_namespace, '}}:')
    END), src.page_title, ']]') AS redir_from,
  CONCAT(
    '[[',
    (CASE tgt.page_namespace
      WHEN 0 THEN ''            WHEN 1 THEN 'Talk:'
      WHEN 2 THEN 'User:'       WHEN 3 THEN 'User talk:'
      WHEN 4 THEN 'Wikipedia:'  WHEN 5 THEN 'Wikipedia talk:'
      WHEN 6 THEN ':File:'      WHEN 7 THEN 'File talk:'
      WHEN 8 THEN 'MediaWiki:'  WHEN 9 THEN 'MediaWiki talk:'
      WHEN 10 THEN 'Template:'  WHEN 11 THEN 'Template talk:'
      WHEN 12 THEN 'Help:'      WHEN 13 THEN 'Help talk:'
      WHEN 14 THEN ':Category:' WHEN 15 THEN 'Category talk:'
      WHEN 100 THEN 'Portal:'   WHEN 101 THEN 'Portal talk:'
      WHEN 108 THEN 'Book:'     WHEN 109 THEN 'Book talk:'
      WHEN 118 THEN 'Draft:'    WHEN 119 THEN 'Draft talk:'
      ELSE CONCAT('{{ns:', tgt.page_namespace, '}}:')
    END),
    tgt.page_title, ']]') AS redir_to
FROM redirect
  JOIN page src ON rd_from = src.page_id
  JOIN page tgt ON rd_namespace = tgt.page_namespace AND rd_title = tgt.page_title
WHERE
  src.page_title LIKE '%(disambiguation)'
  AND NOT EXISTS
  (
    SELECT 1
    FROM categorylinks
    WHERE
      cl_from = tgt.page_id
      AND cl_to = 'All_disambiguation_pages'
  );
SQL

Checking query status...
