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 AS 'rd',
    page_len
FROM page LEFT JOIN categorylinks ON (cl_from=page_id AND cl_to NOT REGEXP '^Wikipedia:')
WHERE
	page_namespace=14 AND
	page_title NOT REGEXP '^Alles$|^(Gebruiker|Wikipedia):' AND
	NOT EXISTS (
		SELECT *
      	FROM templatelinks, linktarget
      	WHERE tl_target_id=lt_id AND tl_from=page_id AND lt_namespace=10 AND tl_from_namespace=14 AND lt_title='Broodkruimel'
	)
GROUP BY page_id
ORDER BY page_id

SQL

Checking query status...