nlwiki Unused categories without nomination

SQL

/*SELECT 
	CONCAT('Categorie:', CONVERT(REPLACE(cat_title,'_',' ') USING utf8mb4)) AS categorie, 
    page_is_redirect AS rd, 
    rev_timestamp AS created
FROM category, page, revision
WHERE 
	cat_pages=0 AND cat_subcats=0 AND cat_files=0 AND
	cat_title NOT REGEXP '^Wikipedia:Gebruikers/' AND
	page_namespace=14 AND cat_title=page_title AND
	NOT EXISTS (SELECT * FROM page_props WHERE pp_page=page_id AND pp_propname='expectunusedcategory') AND
	NOT EXISTS (SELECT * FROM categorylinks WHERE cl_from=page_id AND cl_to='Wikipedia:Categorie_weg') AND
    rev_parent_id=0 AND rev_page=page_id
ORDER BY cat_title
*/
SELECT * FROM revision WHERE rev_timestamp='20201122121504'
SQL

Checking query status...
