nlwiki Categories without breadcrum (broodkruimel)

SQL

SELECT
	page_id,
    CONCAT('Categorie:',CONVERT(REPLACE(page_title,'_',' ') USING utf8mb4)) AS 'category',
    COUNT(cl_to) AS 'subcats',
    page_is_redirect,
    page_len
FROM page, categorylinks
WHERE
	page_namespace=14 AND
	page_title NOT REGEXP '^Alles$|^(Gebruiker|Wikipedia):' AND
	NOT EXISTS (
		SELECT *
		FROM templatelinks
		WHERE tl_from=page_id AND tl_namespace=10 AND tl_from_namespace=14 AND tl_title='Broodkruimel'
	) AND
    cl_from=page_id AND
    cl_to NOT REGEXP '^Wikipedia:'
GROUP BY page_id
ORDER BY page_id

SQL

Checking query status...