Last modified: 2014-01-03 15:22:45 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-8. Summary: Unused templates on en.wiki Issue type: Task - A task that needs to be done. Priority: Minor Status: Done Assignee: Daniel Kinzler <daniel@brightbyte.de> ------------------------------------------------------------------------------- From: MZMcBride <mzmcbride@gmail.com> Date: Sun, 06 Jan 2008 20:40:46 ------------------------------------------------------------------------------- Would it be possible to get a list of all unused template on en.wiki. The Template: namespace is a complete mess; it's time for a major clean out. : - ) I copied and pasted the query that MediaWiki currently uses below; feel free to adapt it or write a better one. Thanks! SELECT 'Unusedtemplates' AS type, page_title AS title, page_namespace AS namespace, 0 AS value FROM $page LEFT JOIN $templatelinks ON page_namespace = tl_namespace AND page_title = tl_title WHERE page_namespace = 10 AND tl_from IS NULL
------------------------------------------------------------------------------- From: Daniel Kinzler <daniel@brightbyte.de> Date: Mon, 07 Jan 2008 00:31:16 ------------------------------------------------------------------------------- results at <http://tools.wikimedia.de/~daniel/misc/unusedtemplates-enwiki.txt> (23572 entries, including redirects), details at <http://wiki.ts.wikimedia.org/view/Query_service/unused_templates>.
This bug was imported as RESOLVED. The original assignee has therefore not been set, and the original reporters/responders have not been added as CC, to prevent bugspam. If you re-open this bug, please consider adding these people to the CC list: Original assignee: daniel.kinzler@wikimedia.de CC list: b@mzmcbride.com, daniel.kinzler@wikimedia.de