DBQ-50 Old unused templates on English Wikibooks
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	JiraBugConverter
	Jan 3 2014, 3:42 PM

Description

This issue was converted from https://jira.toolserver.org/browse/DBQ-50.
Summary: Old unused templates on English Wikibooks
Issue type: Task - A task that needs to be done.
Priority: Minor
Status: Done
Assignee: (none)

From: Mike.lifeguard <mike.lifeguard+ts@gmail.com>

Date: Fri, 14 Nov 2008 00:36:41

We'd like a list of old (say >3 months) unused (no transclusions, links are ok) templates (including redirects) on enwikibooks. The preferred format would be a wikitext table with rows like this:

[[Template:Whatever]]
timestamp of last edit last user number of links to the template

etc

otherwise a simple list will be fine

Thanks

Version: unspecified
Severity: minor

Details

Reference: bz59305

Event Timeline

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

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

• bzimport set Reference to bz59305.

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

From: MZMcBride <mzmcbride@gmail.com>

Date: Fri, 14 Nov 2008 02:03:58

Wrote and ran the query. Didn't include the JOIN on pagelinks because I'm lazy.

SELECT page_title,rev_timestamp,rev_user_text

FROM page
LEFT JOIN templatelinks
ON page_namespace = tl_namespace AND page_title = tl_title
JOIN revision ON rev_page = page_id
WHERE page_namespace = 10 AND tl_from IS NULL
AND rev_timestamp = (SELECT MAX(rev_timestamp) FROM revision WHERE rev_page = page_id)
AND page_is_redirect = 0;

Results posted to http://en.wikibooks.org/w/index.php?oldid=1332296

Sortable wikitable format with numbered output.

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: (none)
CC list: b@mzmcbride.com, mike.lifeguard+bugs@gmail.com

DBQ-50 Old unused templates on English WikibooksClosed, ResolvedPublicActions