~testing de sister projects broken

SQL

USE dewiki_p;
SELECT now() AS timestamp;
#malformed
(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
WHERE wp.page_namespace = 0
AND iwl_prefix ='commons'
AND ((iwl_title = 'Category:') OR (iwl_title LIKE 'Category:%?'))
)
UNION
#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
INNER JOIN commonswiki_p.page cp ON cp.page_title = SUBSTRING(iwl_title, 10)
INNER JOIN commonswiki_p.categorylinks ccl ON ccl.cl_from = cp.page_id
WHERE cp.page_namespace = 14
AND wp.page_namespace = 0
AND iwl_prefix ='commons'
AND iwl_title LIKE 'Category:%'
AND (ccl.cl_to = 'Disambiguation'
  OR NOT EXISTS (SELECT 1 FROM cp WHERE cp.page_title = SUBSTRING(iwl_title, 10)))
)
ORDER BY wpage
LIMIT 1000;
SQL

Checking query status...
