nds_nlwiki Categories without main page

This query is marked as a draft This query has been published by Bdijkstra.

SQL

SELECT page_title AS cat, (cat_pages-cat_subcats-cat_files) AS `#p`
FROM page cp, category cat0
WHERE
	cp.page_is_redirect=0 AND
	cp.page_namespace=14 AND
    cp.page_title NOT REGEXP '^Gebruker_|^Mal:|^Wikipedie:|_artikel$' AND
    cp.page_title=cat_title AND
	NOT EXISTS (SELECT * FROM categorylinks cl0 WHERE cl_to=page_title AND cl_sortkey_prefix REGEXP '^[ !\\*]')
HAVING `#p`>1

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...