nlwiki Shortest non-stub articles

SQL

SELECT page_title, page_is_new, page_len, rev_timestamp
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_id=0
ORDER BY rev_timestamp

SQL

Checking query status...