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 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 
    pl_from IS NULL AND (
	(cl_to='Wikipedia:Pagina_weg' AND (
		(page_namespace=0)
    	OR
		(page_namespace=6)
    )) OR
	(cl_to='Wikipedia:Sjabloon_weg' AND page_namespace=10)
    OR
	(cl_to='Wikipedia:Categorie_weg' AND page_namespace=14)
    )
ORDER BY page_namespace, page_title

SQL

Checking query status...