nlwiki Oldest to-categorize

SQL

USE nlwiki_p;
SELECT rc_namespace, rc_title, rev_timestamp
FROM category, categorylinks, recentchanges, revision
WHERE 
	cat_title REGEXP '^Wikipedia:Nog_te_categoriseren_sinds_' AND
	cl_to=cat_title AND
    cl_from=rc_cur_id AND
	rc_namespace=0 AND
    rev_parent_id=0 AND
    rev_page=cl_from
ORDER BY rev_timestamp ASC
LIMIT 50
/*
SELECT page_namespace, page_title, rev_timestamp
FROM category, categorylinks, page, revision
WHERE 
	cat_title REGEXP '^Wikipedia:Nog_te_categoriseren_sinds_' AND
	cl_to=cat_title
    cl_from=page_id AND
	page_namespace=0 AND
    rev_parent_id=0 AND
    rev_page=cl_from
ORDER BY rev_timestamp ASC
LIMIT 50
*/
SQL

Checking query status...
