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

SQL

AخA
 
USE nlwiki_p;
SELECT page_title, rev_timestamp
FROM page, revision
WHERE 
    page_namespace=0 AND 
    page_is_redirect=0 AND
    NOT EXISTS (
        SELECT * 
        FROM page_props 
        WHERE page_id=pp_page AND pp_propname='disambiguation'
    ) AND
    NOT EXISTS (
        SELECT * 
        FROM categorylinks 
        WHERE page_id=cl_from AND cl_to REGEXP '^Wikipedia:(Verwijderbaar/[0-9]{2}|Nog_niet_gereed|Nuweg)$'
    ) AND
    page_id=rev_page AND 
    rev_parent_id=0 AND 
    UNIX_TIMESTAMP()-UNIX_TIMESTAMP(STR_TO_DATE(rev_timestamp,'%Y%m%d%H%i%s'))>86400 AND
    NOT EXISTS (SELECT * FROM (
        # niet-beheer categorylinks
        SELECT cl_from, cl_to FROM categorylinks WHERE 
            cl_to NOT REGEXP '^(Diersoort_beschreven_in_|Actuele_(sport)?gebeurtenis$)' AND
            NOT EXISTS (SELECT * FROM (
                # beheercategorieën
                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)
ORDER BY rev_timestamp
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...