Last modified: 2014-01-03 15:22:45 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T61261, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 59261 - DBQ-8 Unused templates on en.wiki
DBQ-8 Unused templates on en.wiki
Status: RESOLVED FIXED
Product: Tool Labs tools
Classification: Unclassified
Database Queries (Other open bugs)
unspecified
All All
: Unprioritized minor
: ---
Assigned To: Bugzilla Bug Importer (valhallasw)
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2014-01-03 15:22 UTC by Bugzilla Bug Importer (valhallasw)
Modified: 2014-01-03 15:22 UTC (History)
0 users

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Bugzilla Bug Importer (valhallasw) 2014-01-03 15:22:41 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
Comment 1 Bugzilla Bug Importer (valhallasw) 2014-01-03 15:22:43 UTC
-------------------------------------------------------------------------------
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>.
Comment 2 Bugzilla Bug Importer (valhallasw) 2014-01-03 15:22:45 UTC
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

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links