Fork of
Transclusions of missing templates
by Plastikspork
This query is marked as a draft
This query has been published
by EqJjgOa8rVvsRmZL.
SQL
x
select page_namespace, page_title, lt_namespace, lt_title from linktarget
join templatelinks on tl_target_id = lt_id
join page on tl_from = page_id and page_namespace % 2 = 0 and page_namespace != 2
where lt_namespace in (10, 828)
and lt_title not in (select page_title from page where page_namespace = lt_namespace)
limit 100
-- order by page_namespace
/*
select page_title, pl_title from pagelinks
join page on pl_from = page_id and page_namespace = 0
where pl_namespace = 10
and pl_title not in (select page_title from page where page_namespace = 10)
limit 100;
*/
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.