nds_nlwiki Categories without main page

SQL

SELECT cp.page_title AS cat, (cat_pages-cat_subcats-cat_files) AS `#p`, GROUP_CONCAT(p1.page_title SEPARATOR '|') AS `pages`
FROM page cp, category cat0, categorylinks cl1, page p1
WHERE
	cp.page_is_redirect=0 AND
	cp.page_namespace=14 AND
    cp.page_title NOT REGEXP '^Artikel_in_de_|^Gebruker_|^Mallen_|^Mal:|^Pl(ak|[ao][ao]tse?)_in_|^Wikipedie:|_artikel$|_mallen$' AND
    cp.page_title=cat_title AND
	NOT EXISTS (SELECT * FROM categorylinks cl0 WHERE cl_to=cp.page_title AND cl_sortkey_prefix REGEXP '^[ !\\*]') AND
    cl1.cl_to=cat_title AND
    cl1.cl_from=p1.page_id
GROUP BY `cat`, `#p`
ORDER BY `cat`, p1.page_title
HAVING `#p`>1
SQL

Checking query status...
