USE nlwiki_p;

    SELECT DISTINCT page_id, page_title, rev_timestamp

    FROM recentchanges, page, revision

    WHERE 

        rc_type IN (0,1) /*new,edit*/ AND rc_cur_id!=0 /*log item*/ AND

        page_id=rc_cur_id AND

        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