Categories of decomposed infoboxes in cswiki

SQL

USE cswiki_p;
SELECT SUBSTRING_INDEX( cat.cl_to, '_', 2 ) AS begins_with, COUNT(DISTINCT cat.cl_to) AS categories, COUNT(DISTINCT subst.cl_from) AS members,
	FIRST(cat.cl_to) AS sample_cat
FROM (SELECT * FROM categorylinks WHERE cl_to = "Údržba:Články_se_substovanými_infoboxy") AS subst
JOIN categorylinks AS cat ON cat.cl_from = subst.cl_from
WHERE cat.cl_to <> subst.cl_to
AND cat.cl_to NOT LIKE "Údržba:%"
AND cat.cl_to NOT LIKE "Monitoring:%"
GROUP BY SUBSTRING_INDEX( cat.cl_to, '_', 2 )
ORDER BY categories DESC, members DESC, begins_with;

SQL

Checking query status...