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, 
        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
SQL

Checking query status...
