Fork of nds_nlwiki Pages without category by Bdijkstra
This query is marked as a draft This query has been published by Zygimantus.

SQL

AخA
 
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)
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...