Fork of
Transclusions of missing templates
by Frietjes
This query is marked as a draft
This query has been published
by Plastikspork.
SQL
AخA
SELECT t.tl_title FROM templatelinks t
LEFT JOIN page p
ON p.page_namespace = t.tl_namespace AND p.page_title = t.tl_title
INNER JOIN page p2
ON t.tl_from = p2.page_id
WHERE p.page_title IS NULL AND t.tl_namespace = 10
GROUP BY 1
LIMIT 500;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.