Watch page titles consistency (cswiki)

SQL

USE cswiki_p;
/*
SELECT DISTINCT CONCAT('Kategorie:', cl_to)
FROM categorylinks
JOIN page ON page_id = cl_from
WHERE page_namespace = 0
AND SUBSTRING(cl_to, 1, 5) = SUBSTRING(IF(cl_sortkey_prefix <> '', cl_sortkey_prefix, page_title), 1, 5)
AND cl_to NOT LIKE 'Doprava%'
AND cl_to NOT RLIKE '^[0-9]'
ORDER BY cl_to;
*/
SELECT *
FROM categorylinks
JOIN page ON page_id = cl_from
WHERE page_namespace = 0
AND SUBSTRING(cl_to, 1, 5) = SUBSTRING(IF(cl_sortkey_prefix <> '', cl_sortkey_prefix, page_title), 1, 5)
AND cl_to = 'AC/DC';

SQL

Checking query status...