~testing de sister projects broken

SQL

USE dewiki_p;
SELECT now() AS timestamp;
#missing page name
(SELECT CONCAT ('# [[', REPLACE (wp.page_title, '_', ' '), ']]') AS wpage, CONCAT('→ [[:c:', REPLACE (iwl_title, '_', ' '), ']]') AS commonscat
FROM iwlinks
INNER JOIN page wp
ON wp.page_id = iwl_from
AND wp.page_namespace = 0
WHERE iwl_prefix ='commons'
AND iwl_title = 'Category:'
)
UNION
#interwikilinks pointing to disambiguations
(SELECT CONCAT ('# [[', REPLACE (wp.page_title, '_', ' '), ']]') AS wpage, CONCAT('→ [[:c:', REPLACE (iwl_title, '_', ' '), ']]') AS commonscat
FROM iwlinks
INNER JOIN page wp
ON wp.page_id = iwl_from
AND wp.page_namespace = 0
AND wp.page_title NOt IN ('Begriffsklärung',
                          'Liste_von_Schiffen_mit_dem_Namen_Rainbow_Warrior',
                          'Schiffsname_der_United_States_Navy',
                          'Stena_Germanica_und_Stena_Scandinavica')
INNER JOIN commonswiki_p.page cp
ON cp.page_title = SUBSTRING(iwl_title, 10)
AND cp.page_namespace = 14
INNER JOIN commonswiki_p.categorylinks ccl
ON ccl.cl_from = cp.page_id
AND ccl.cl_to = 'Disambiguation'
WHERE iwl_prefix ='commons'
AND iwl_title LIKE 'Category:%'
#AND NOT EXISTS (SELECT 1 FROM categorylinks wcl
#    WHERE wcl.cl_from = wp.page_id
#    AND wcl.cl_to IN )
)
UNION
#external links pointing to disambiguations
(SELECT CONCAT('# [[', REPLACE (wp.page_title, '_', ' '), ']]') AS wpage, CONCAT('→ [[:c:Category:', REPLACE (cp.page_title, '_', ' '), ']]') AS commonscat
FROM externallinks
INNER JOIN page wp
ON wp.page_id = el_from
AND wp.page_namespace = 0
AND wp.page_title NOt IN ('Begriffsklärung',
                          'Liste_von_Schiffen_mit_dem_Namen_Rainbow_Warrior',
                          'Schiffsname_der_United_States_Navy',
                          'Stena_Germanica_und_Stena_Scandinavica')
INNER JOIN commonswiki_p.page cp
ON cp.page_title = SUBSTRING(REPLACE (el_to, '?uselang=de', ''), 45)
AND cp.page_namespace = 14
INNER JOIN commonswiki_p.categorylinks ccl
ON ccl.cl_from = cp.page_id
AND ccl.cl_to = 'Disambiguation'
WHERE el_to LIKE 'https://commons.wikimedia.org/wiki/Category:%'
#AND NOT EXISTS (SELECT 1 FROM categorylinks wcl
#    WHERE wcl.cl_from = wp.page_id
#    AND wcl.cl_to IN ('Begriffsklärung',
#                      'Liste_von_Schiffen_mit_dem_Namen_Rainbow_Warrior',
#                      'Schiffsname_der_United_States_Navy'
#                      'Stena_Germanica_und_Stena_Scandinavica'))
)
ORDER BY wpage
LIMIT 1000;
SQL

Checking query status...
