nlwiki Pages w/ deletion template w/o link to nomination page

SQL

USE nlwiki_p;
/*SELECT page_id, page_title FROM page WHERE page_namespace=4 AND page_title REGEXP '^Te_beoordelen_[^/]+$';*/

/*SELECT page_namespace, page_title
FROM categorylinks, page
WHERE
	cl_from=page_id AND (
	(cl_to='Wikipedia:Pagina_weg' AND (
		(page_namespace=0 AND NOT EXISTS (SELECT * FROM pagelinks WHERE pl_from=336338 AND pl_namespace=0 AND pl_title=page_title))
    	OR
		(page_namespace=6 AND NOT EXISTS (SELECT * FROM pagelinks WHERE pl_from=202885 AND pl_namespace=6 AND pl_title=page_title))
    )) OR
	(cl_to='Wikipedia:Sjabloon_weg' AND page_namespace=10 AND
		NOT EXISTS (SELECT * FROM pagelinks WHERE pl_from=109653 AND pl_namespace=10 AND pl_title=page_title))
    OR
	(cl_to='Wikipedia:Categorie_weg' AND page_namespace=14 AND
		NOT EXISTS (SELECT * FROM pagelinks WHERE pl_from=109651 AND pl_namespace=14 AND pl_title=page_title))
    )
ORDER BY page_namespace, page_title*/
# above is more precise, below is simpler but should be the same
SELECT page_namespace, page_title
FROM categorylinks, page LEFT JOIN pagelinks ON (
  pl_from IN (SELECT page_id FROM page WHERE page_namespace=4 AND page_title REGEXP '^Te_beoordelen_[^/]+$') AND 
  pl_namespace=page_namespace AND pl_title=page_title)
WHERE
	cl_from=page_id AND 
    cl_to REGEXP '^Wikipedia:[CPS][a-z]+_weg$' AND 
    pl_from IS NULL AND
    page_namespace IN (0, 6, 10, 14)
ORDER BY page_namespace, page_title
SQL

Checking query status...
