nlwiki Shortest non-stub articles

SQL

  	# recent bewerkte artikelen die niet genomineerd zijn en ouder dan 24 uur
	SELECT DISTINCT page_id, page_title, rev_timestamp, NOW()-STR_TO_DATE(rev_timestamp,'%Y%m%d%H%i%s')
	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(NOW()-STR_TO_DATE(rev_timestamp,'%Y%m%d%H%i%s'))>86400
  	ORDER BY rev_timestamp*/
    LIMIT 50
SQL

Checking query status...
