Last modified: 2014-01-03 15:42:13 UTC
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
------------------------------------------------------------------------------- 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