Fork of nlwiki Articles without content category by Bdijkstra
This query is marked as a draft This query has been published by Bdijkstra.

SQL

​x
 
use nds_nlwiki_p;
​
SELECT page_title
FROM page
WHERE 
    page_namespace IN (0,10,14) AND page_is_redirect=0 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)
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
All SQL code is licensed under CC0 License.

Checking query status...