USE nlwiki_p;

SELECT page_title, page_is_new, page_len

FROM page, revision

WHERE 

    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:(Beginnetje_|Verwijderbaar/)') AND

    page_namespace=0 AND

    page_is_redirect=0 AND

    page_len < 512 AND

    page_title NOT REGEXP '^Isotopentabel_|^Lijst_van_[A-Za-z_]+-spellen$' AND

    page_latest=rev_id AND

    rev_parent=0