Benutzer:Umherirrender/Spielvorlage

 MariaDB [dewiki_p]> SELECT tl_namespace AS namespace,tl_title AS title,COUNT(*) AS value FROM `templatelinks` LEFT JOIN `page` ON ((page_namespace = tl_namespace) AND (page_title = tl_title)) WHERE (page_title IS NULL) AND tl_namespace = '2' and tl_title in ( select REPLACE(page_title, '~dewiki/', '/' ) from page where page_namespace = 2 and page_title like '%~dewiki/%' ) GROUP BY tl_namespace,tl_title ORDER BY value DESC LIMIT 500;