nlwiki Wanted templates in main namespace

Fork of nlwiki Wanted templates in main namespace by Bdijkstra

This query is marked as a draft This query has been published by Ennomien.

SQL

SELECT CONCAT('[[Speciaal:VerwijzingenNaarHier/Sjabloon:', REPLACE(lt_title,'_',' '), ']]') AS backlink, COUNT(*) AS `count`
FROM templatelinks INNER JOIN linktarget ON tl_target_id=lt_id RIGHT JOIN page pf ON tl_from=page_id
WHERE
	lt_namespace=10 AND
    tl_from_namespace=0 AND
    NOT EXISTS (SELECT * FROM page pt WHERE pt.page_namespace=lt_namespace AND pt.page_title=lt_title) AND
    NOT EXISTS (SELECT * FROM categorylinks WHERE cl_from=tl_from AND cl_to REGEXP '^Wikipedia:Verwijderbaar/')
GROUP BY lt_title
ORDER BY `count` DESC

SQL

Checking query status...