nlwiki Navigation templates with mostly red links

SQL

/*SELECT page_title, page_len
FROM page tpl
WHERE page_namespace=10 AND page_is_redirect=0 AND page_title REGEXP '^Navigatie_' AND
	EXISTS (SELECT * FROM pagelinks WHERE pl_from=page_id AND pl_namespace=0) AND
	NOT EXISTS (SELECT * FROM pagelinks, page tgt WHERE 
                pl_from=page_id AND pl_title!=tpl.page_title AND pl_namespace=tgt.page_namespace AND pl_title=tgt.page_title)
LIMIT 1000
SELECT page_title, page_len, (SELECT COUNT(*) FROM pagelinks, page tgt WHERE 
                pl_from=page_id AND pl_title!=tpl.page_title AND pl_namespace=tgt.page_namespace AND pl_title=tgt.page_title) AS blue
FROM page tpl
WHERE page_namespace=10 AND page_is_redirect=0 AND page_title REGEXP '^Navigatie_' AND
	EXISTS (SELECT * FROM pagelinks WHERE pl_from=page_id AND pl_namespace=0)
LIMIT 10*/
SELECT * FROM pagelinks, (SELECT * FROM page LIMIT 10) tgt WHERE 
                pl_from=page_id AND pl_namespace=tgt.page_namespace AND pl_title=tgt.page_title
SQL

Checking query status...
