nlwiki Books without yearcategory

SQL

/*SELECT page_title, cl_to
FROM categorylinks bc, page
WHERE cl_to REGEXP '^Boek|boek$|^Roman|roman$' AND cl_to!='Boekverfilming' AND cl_from=page_id AND page_namespace=0 AND
	NOT EXISTS (SELECT * FROM categorylinks yc WHERE yc.cl_from=page_id AND yc.cl_to REGEXP '_uit_[0-9]+$')
LIMIT 10*/
SELECT page_title, cl_to
FROM categorylinks bc, page
WHERE
	cl_to REGEXP '^Roman(_|$)|roman$' AND
    cl_to NOT IN ('Boekverfilming', 'Victoriaanse_roman', 'Middeleeuwse_roman') AND
    cl_to NOT REGEXP '^[0-9]+e-eeuwse_roman$' AND
    cl_from=page_id AND page_namespace=0 AND
	NOT EXISTS (SELECT * FROM categorylinks yc WHERE yc.cl_from=page_id AND yc.cl_to REGEXP '_uit_[0-9]+$')
LIMIT 50
SQL

Checking query status...
