Toolserver:Query service/8

From mediawiki.org

This page was moved from the Toolserver wiki.
Toolserver has been replaced by Toolforge. As such, the instructions here may no longer work, but may still be of historical interest.
Please help by updating examples, links, template links, etc. If a page is still relevant, move it to a normal title and leave a redirect.

Unused templates enwiki[edit]

Description List of unused templates (including redirects)
Assignee Duesentrieb
JIRA bug DBQ-8
Source Query service/unused templates#Query
Results http://tools.wikimedia.de/~daniel/misc/unusedtemplates-enwiki.txt (for enwiki)
Approximate run time a couple of hours
Interval
Category:Query service


Query[edit]

SELECT concat("Template:", page_title)
FROM page
LEFT JOIN templatelinks
ON page_namespace = tl_namespace AND page_title = tl_title
WHERE page_namespace = 10 AND tl_from IS NULL