https://bugzilla.wikimedia.org/show_bug.cgi?id=59261
Web browser: ---
Bug ID: 59261
Summary: DBQ-8 Unused templates on en.wiki
Product: Tool Labs tools
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: minor
Priority: Unprioritized
Component: Database Queries
Assignee: wmf.bugconver...@gmail.com
Reporter: wmf.bugconver...@gmail.com
Classification: Unclassified
Mobile Platform: ---
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 <dan...@brightbyte.de>
-------------------------------------------------------------------------------
From: MZMcBride <mzmcbr...@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
--
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
