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!='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 50

SQL

Checking query status...