Untitled query #68679

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
GROUP BY cat_title # duplicates due to history merge
ORDER BY cat_title
SQL

Checking query status...
