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=tpl.page_id AND pl_title!=tpl.page_title AND pl_namespace=tgt.page_namespace AND pl_title=tgt.page_title) AS blue,
	(SELECT COUNT(*) FROM pagelinks WHERE pl_from=tpl.page_id AND NOT EXISTS (
      	SELECT * FROM page tgt WHERE pl_title!=tpl.page_title AND pl_namespace=tgt.page_namespace AND pl_title=tgt.page_title)) AS red
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)
HAVING blue <= 2 AND red > 0
ORDER BY red DESC, page_title
LIMIT 1000
SQL

Checking query status...
