nds_nlwiki Pages without category

Fork of nlwiki Articles without content category by Bdijkstra

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

SQL

SELECT page_namespace, page_title
FROM page
WHERE 
	page_namespace IN (0,10,14) AND page_is_redirect=0 AND
    (page_namespace != 14 OR page_title NOT REGEXP '_artikel$') AND
	NOT EXISTS (SELECT * FROM (
		# niet-beheyr kategorylinks
		SELECT cl_from, cl_to FROM categorylinks WHERE 
      	cl_to NOT REGEXP '_artikel$|^Artikel_in_de_' AND
      	NOT EXISTS (SELECT * FROM (
			# beheyrkategoryen
			SELECT DISTINCT page_title
			FROM page, page_props
			WHERE page_namespace=14 AND page_id=pp_page AND (pp_propname='hiddencat' /*OR pp_propname='expectunusedcategory'*/)
		) hc WHERE cl_to=hc.page_title)
		GROUP BY cl_from
		ORDER BY cl_from
	) nhcl WHERE nhcl.cl_from=page_id)

SQL

Checking query status...