nlwiki Navigation templates with mostly red links

SQL

/*SELECT page_title, page_len, 
	(SELECT COUNT(*) FROM pagelinks, page tgt WHERE pl_namespace=0 AND
     	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_namespace=0 AND 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 page_title NOT REGEXP '^Navigatie_isotopen_van_'
HAVING blue <= 2 AND red > 0
ORDER BY blue, red DESC, page_title
LIMIT 100*/
SELECT CONCAT('[[Sjabloon:',REPLACE(page_title,'_',' '),']]') AS template, page_len, 
	(SELECT COUNT(*) FROM pagelinks, linktarget, page tgt WHERE pl_target_id=lt_id AND lt_namespace=0 AND
     	pl_from=tpl.page_id AND lt_title!=tpl.page_title AND lt_namespace=tgt.page_namespace AND lt_title=tgt.page_title) AS blue,
	(SELECT COUNT(*) FROM pagelinks, linktarget WHERE pl_target_id=lt_id AND lt_namespace=0 AND pl_from=tpl.page_id AND NOT EXISTS (
      	SELECT * FROM page tgt WHERE lt_title!=tpl.page_title AND lt_namespace=tgt.page_namespace AND lt_title=tgt.page_title)) AS red
FROM page tpl
WHERE page_namespace=10 AND page_is_redirect=0 AND page_title REGEXP '^Navigatie_' AND page_title NOT REGEXP '^Navigatie_isotopen_van_'
HAVING blue>0 AND blue <= 2 AND red > 0
ORDER BY page_title
LIMIT 100
SQL

Checking query status...
