User:Microchip08/Database dump/Untranscluded templates
Jump to navigation
Jump to search
Introduction[edit]
This dump lists all eight-hundred-and-something untranscluded templates on English Wikinews. The aim is to root out a few useless ones, as well as to find some gems that perhaps have been overlooked. Bear in mind the following: Articles that are meant to be substituted appear here (such as {{yourarticlegone}}, and others are meta-templates, such as {{Delete/Messages/A1}}, which are only transcluded when {{delete|A1}} is parsed.
Dump code tweaked marginally from MZMcBride; dump performed by Bluegoblin7.
SELECT CONCAT("{{/entry|namespace=10|page=", 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;