Template Transclusions

This query is marked as a draft This query has been published by Nettrom.

An example query that grabs the first 25 transclusions of the "Refimprove" template from the English Wikipedia database, as well as the first 10 transclusions of "User:SuggestBot/userbox".

SQL

USE enwiki_p;
SELECT page_id, page_namespace, page_title
FROM templatelinks
JOIN page
ON (page_id=tl_from)
WHERE tl_namespace=10
AND tl_title='Refimprove'
LIMIT 25;
SELECT page_id, page_namespace, page_title
FROM templatelinks
JOIN page
ON (page_id=tl_from)
WHERE tl_namespace=2
AND tl_title='SuggestBot/userbox'
LIMIT 10;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...