DBQ-8 Unused templates on en.wiki
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	JiraBugConverter
	Jan 3 2014, 3:22 PM

Description

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

Version: unspecified
Severity: minor

Details

Reference: bz59261

Event Timeline

• bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:19 AM

• bzimport added a project: Tool-Database-Queries.

• bzimport set Reference to bz59261.

JiraBugConverter created this task.Jan 3 2014, 3:22 PM

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

DBQ-8 Unused templates on en.wikiClosed, ResolvedPublicActions