Wikipedia:List of templates by usage
From Wikipedia, the free encyclopedia
These tables were generated at http://www.wikisign.org using the 20.02.2006 dump of the database, which is somewhat out of date. See also:
- Wikipedia:High-risk templates
- Wikipedia:List of permanently protected pages#High use templates.
- Wikipedia:Transclusion costs and benefits
[edit] Meta-templates
This table shows the 200 templates which are most linked to by other templates. In most cases this will be because one template has another template transcluded inside it. Note that some of these templates are already protected (see also Wikipedia:List of permanently protected pages#High use templates).
SELECT CONCAT('[[Template:',templatelinks.tl_title,']]') AS title, COUNT(templatelinks.tl_title) AS count FROM templatelinks, page WHERE templatelinks.tl_namespace = 10 AND templatelinks.tl_from = page.page_id AND page.page_namespace = 10 GROUP BY title ORDER BY count DESC LIMIT 200
[edit] High-volume templates
This table shows the 200 templates which are most linked to overall. In most cases this will be because the template is transcluded in a page.
SELECT CONCAT('[[Template:',tl_title,']]') AS title, COUNT(tl_title) AS count FROM templatelinks WHERE tl_namespace = 10 GROUP BY title ORDER BY count DESC LIMIT 200