USE nlwiki_p;

SELECT * FROM recentchanges WHERE rc_cur_id<10;/*

    # recent bewerkte artikelen die niet genomineerd zijn en ouder dan 24 uur

    SELECT DISTINCT 

        page_id, 

        page_title, 

        rev_timestamp, 

        UNIX_TIMESTAMP()-UNIX_TIMESTAMP(STR_TO_DATE(rev_timestamp,'%Y%m%d%H%i%s')) AS 'age'

    FROM recentchanges, page, revision

    WHERE 

        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

    LIMIT 50*/