nlwiki Wanted templates

excluding those linked from user (talk) space.

Executes in < 10 s.

Links to namespace MediaWiki (8) are excluded because content from translatewiki.net does not appear in the page table.
Links to namespace Portaal (100) are excluded because apparently unfinished portals are condoned.
Links from cascade-protected pages are excluded because it is normal there to transclude non-existing pages.

SQL

USE nlwiki_p;
SELECT tl_namespace, tl_title, COUNT(*) AS `count`, GROUP_CONCAT(DISTINCT tl_from_namespace) AS ns
FROM templatelinks
WHERE
	tl_namespace!=8 AND
    tl_from_namespace NOT IN (2, 3) AND
    NOT EXISTS (SELECT * FROM page WHERE page_namespace=tl_namespace AND page_title=tl_title)
GROUP BY tl_title
ORDER BY `count` DESC

AخA
 
USE nlwiki_p;SELECT tl_namespace, tl_title, COUNT(*) AS `count`, GROUP_CONCAT(DISTINCT tl_from_namespace) AS nsFROM templatelinksWHERE    tl_namespace!=8 AND    tl_from_namespace NOT IN (2, 3) AND    NOT EXISTS (SELECT * FROM page WHERE page_namespace=tl_namespace AND page_title=tl_title)GROUP BY tl_titleORDER BY `count` DESC

SQL

Checking query status...