Fork of
Transclusions of missing templates
by Plastikspork
This query is marked as a draft
This query has been published
by Plastikspork.
SQL
AخA
SELECT lt.lt_title FROM templatelinks t
INNER JOIN linktarget lt
ON lt.lt_id = t.tl_target_id
LEFT JOIN page p
ON p.page_namespace = lt.lt_namespace AND p.page_title = lt.lt_title
INNER JOIN page p2
ON t.tl_from = p2.page_id
WHERE p.page_title IS NULL AND lt.lt_namespace = 10
GROUP BY 1
LIMIT 300;
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.